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

Summary

This operator imports data from MSSQL, ORACLE, PostgreSQL or ODBC data sources storing the query into a TIS File

Overview


Screenshot

Query file reference
  • Create a new file
  • Select an existing file (warning) Note that the file must have extension .sql
  • Select an existing file by providing path which may include parameters in syntax #XI.TISPar('par')#

Troubleshooting

Want to learn more?

This operator imports data from MSSQL, ORACLE or ODBC data sources

Parameter


ParameterValueOpt.DescriptionExample
@SQLIMPORT

System.String

---
Generate blank row if nothing has been found

System.Boolean

opt.Must a blank line be created if filtering does not find anything? Zero will be entered in the numerical columns or the data columns, the text located in the parameter "Content text fields in case of blank line" will be displayed in the text columns.-
Text fields content for blank line

System.String

opt.If the filter operator creates a blank line, then this text will be displayed in all text columns.-

Related topics