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 Note that the file must have extension .sql Select an existing file by providing path which may include parameters in syntax #XI.TISPar('par')#

Want to learn more?

Settings

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

Parameter	Value	Opt.	Description	Example
@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.	-