This operator fetches the content of a TIS table into the data nodes.
Getting Started | This operator allows reading a TIS table from user defined folders or with user defined table names. The definition of the folder and the table name are defined via a parameter and eventually with in the [TIS]Board. |
Define a parameter for your folder and/or your table name. | Go to General Parameter for Operations and create parameters with Data Type "Text". Define a value for each parameter. ![](_scroll_external/attachments/e50f2807446e/worddav8cab61221e6714e01c0ace2b6b730ecf.png) |
Read TIS table 3.0 | The input Manual_TT#XI.TISPar('Read Folder')# reads the TIS Table from a subfolder of the folder "Manual_TT" with the name which was defined in the parameters. The table name can also be a simple name or a parameter definition – like in the example: #XI.TISPar('Read Table')# ![](_scroll_external/attachments/4f2578fc994a/worddav19157c11adfa4abc2ab1abcca24080e2.png) |
Options | Like importing data from SQL you can choose which data should be read from the TIS table: Select: Choose only the columns you need with the respective column number C0, C1 … Where: Define which data in a column should be imported only. Define for each necessary column an ID number starting with 0. Then define in the field "Parameter for Where" the values for each ID. Order by: The sorting of imported data can be user defined. For that the column numbers can be typed into the field "Order by". If more than one column is applied, use comma as separator. By standard data is sorted ascending. If your data should be sorted descending, type "desc" after der column number. ![](_scroll_external/attachments/5866d89139c2/worddav30897fe9e6f8b2e36ff946ea9d449230.png) |
Avoiding empty Tables | As of version 5.8 empty tables can be avoided by selecting the option. In case an empty table would be returned a defined warning appears instead of the table. ![](_scroll_external/attachments/de28091c6c2c/worddav2663469436eb896c921295113b9c3359.png) |
Using Parameters for 'Where' | As of version 5.8 parameters can be used to define the 'where' in Read TIS Tables. ![](_scroll_external/attachments/5cdf191dc423/image2017-7-7_14-59-25.png) This filters all data with the value of the parameter in column c1. |
Select DISTINCT | As of Version 5.10 a selection can be made DISTINCT ![](_scroll_external/attachments/106fdf65d278/image2017-2-21_13-47-51.png)
|
Timeout | Start from Version 5.16 a timeout for the query execution can be specified. Default is 30 sec. 0 deactivates the timeout. ![](_scroll_external/attachments/b022533cc710/image2018-5-3_16-29-13.png)
|
Result type | Following options are available - Table content: returns the content of the specified TIS table
- Information about table structure: returns the meta information of the specified TIS table, having a row for each column.
![](_scroll_external/attachments/7b33f7cb53bb/image2016-12-20-10-40-51.png)
|
Settings
This operator fetches the content of a TIS table into the data nodes.
Troubleshooting
Problem | Frequent Cause | Solutions |
---|
Error: Cannot read TIS Table
| Path is incorrect | Check Table path (e.g., has PATH Parameter been changed) |
Error: Cannot read TIS Table | Operation settings "Order by" are wrong (e.g., it looks for 2 columns but your TIS Table has only 1) ![](_scroll_external/attachments/8e3d159ae2de/image2017-2-2_10-40-41.png)
| Check settings and number of columns in your TIS Table, and adapt settings if necessary |