Introduction

This operator allows for importing data e.g. from a database but also from text files, MS-Excel files …
In the following we explain how to use it with Parameters.
There are three major improvements in the Import-Operation:

  • One can define criteria in the WHERE statements using general Parameters
  • One can use address TIS-Tables much easier than before IN WORK: also with general Parameters.
    Accessing current date and time without using syntax that is MS-SQL or oracle specific

Using Parameters in the WHERE Statement

PARAMETERS in the statement are used in the following way:

Example: where projectid = #XI.TISPar('Parameter_ID')#

Adressing TIS-Tables

If you want to use TIS-Tables or other database tables that are on the same database as you work with your [TIS]Editor-Projects, then it is enough to enter dal in the field for the connection

If you want to access a TIS-Table build a statement with the following structure:

 

select * from #XI.TISTable('<Folderpath_name>','<Table_Name>')#

 

 

Example: select * from #XI.TISTable('Root\Import_jg','example2')# reads the table:

 

More complex addressing takes place like this:

select * from #XI.TISTable('TIS Parameter Description\2nd Level','Test 2nd Level')#

ACCESS the current Date & Time

Independent of specific database one gets the current date and time with
#XI.SysDate()#

Note regarding Parameter management

Different from the formula operator, the use of a Parameter within the IMPORT Data from SQL-sources" operator does not cause a listing of the data-node in the following list: