Parameters in the "Import data from SQL sources 5.0" Operator

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 MSSQL 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:

Example: select * from #XI.TISTable('Root\User Manual', 'example')# reads the table:

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: