Introduction | This operator allows for importing data e.g. from a database but also from text files, MS-Excel files …
|
Using Parameters in the WHERE Statement | PARAMETERS in the statement are used in the following way: Example: |
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
select * from #XI.TISTable( '<Folderpath_name>' , '<Table_Name>' )#
Example: |
| More complex addressing takes place like this: |
ACCESS the current Date & Time | Independent of specific database one gets the current date and time with |
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: |