Page tree
Skip to end of metadata
Go to start of metadata

Summary

This operator creates or updates a TIS Table with the data and/or schema of the result table.

Example: Write result table into a TIS Table

Select a folder and enter a name for the table.

Select "Replace entire table (incl. structure). This writes the result table into the TIS Table as-is. It overwrites an existing table.

The table name can be defined via a parameter. The parameter value can be set within TIS Board.

#XI.TISPar('TIS Table Name')# refers to the Parameter "TIS Table Name"


Want to learn more?

This operator creates or updates a TIS Table with the data and/or schema of the result table.

Operator Settings


ParameterValueOpt.DescriptionExample
Select Folder

System.String


Name of the folder-
or enter folder

System.String


Name of the folder, can contain a parameter. E.g., Folder1\#XI.TISPar('Par1')#\Folder3-
Create folder if it does not exist

System.Boolean

-If checked, a folder or all folders on a new path will be created new if they do not exist-
Table

System.String

-Name of the TIS Table, can contain a parameter. E.g., #XI.TISPar('Par2')#-
Paste mode

System.String

  • Append only (key column is necessary)
  • Update (key column is necessary)
  • Replace entire table (incl. structure)
  • Write table structure (deletes all data)
  • Replace table content (keep structure)
  • Delete rows with matching keys
  • Delete rows not matching keys
  • Create only new table (no action if table exists)
opt.

Specifies how the data enters the TIS Table. Defaults to "Replace table content".


-
Keys for updating

System.String

opt.Set of key column names relevant for some of the "Paste mode" options-
Create columns for Editable Grid

System.Boolean

-
-

Nothing known yet.


Related topics