ODBCOutput

ODBCOutput executes an SQL update query against an open ODBC data source. You should use the ODBCOpen function to open the data source before calling ODBCOutput, and use ODBCClose to close the data source before exiting the process.

This function is valid in TurboIntegrator processes only.

Syntax

ODBCOutput(Source, SQLQuery, [SQLQuery2, SQLQuery3, ...]);

Argument	Description
Source	The ODBC data source against which you want to run a query.
SQLQuery	An SQL query statement. Though ODBCOutput was developed to update tables, it can be used to execute any SQL query on the data source. In circumstances where the SQL query statement exceeds 255 characters, you should split the query into multiple SQLQuery arguments (SQLQuery2, SQLQuery3, etc.). This lets you create query statements that exceed the 255 character limit for TurboIntegrator arguments. When the ODBCOutput function is executed, all SQLQuery arguments are concatenated and the query is successfully executed.

Argument

Description

Source

The ODBC data source against which you want to run a query.

SQLQuery

An SQL query statement.

Though ODBCOutput was developed to update tables, it can be used to execute any SQL query on the data source.

In circumstances where the SQL query statement exceeds 255 characters, you should split the query into multiple SQLQuery arguments (SQLQuery2, SQLQuery3, etc.). This lets you create query statements that exceed the 255 character limit for TurboIntegrator arguments. When the ODBCOutput function is executed, all SQLQuery arguments are concatenated and the query is successfully executed.

Example

ODBCOutput('Accounting', 'INSERT [CategoryID], [CategoryName]FROM Categories;');

This example executes the specified query against the Accounting data source.