User`s guide

runsqlscript
7-205
results = runsqlscript(conn, 'compare_sales.sql')
results =
1x2 array of cursor objects
Batching occurs internally within fetch, in that it fetches in increments of two rows at a
time. The batching preferences are applied to all the queries in the SQL script.
• “Configuring a Driver and Data Source” on page 2-13
Input Arguments
connect — Database connection
connection object
Database connection, specified as a connection object.
sqlfilename — File name of SQL commands
string
File name of SQL commands to run, specified as a string. The file must be a text file,
and can contain comments along with SQL queries. Start single-line comments with --.
Enclose multiline comments in /*...*/.
Example: 'C:\work\sql_file.sql'
Name-Value Pair Arguments
Specify optional comma-separated pairs of Name,Value arguments. Name is the
argument name and Value is the corresponding value. Name must appear inside single
quotes (' '). You can specify several name and value pair arguments in any order as
Name1,Value1,...,NameN,ValueN.
Example: 'RowInc',3,'QTimeOut',60 specifies that results be returned in increments
of three rows and the query time out in 60 seconds
'rowInc' — Row limit
0 implies all rows (default) | positive scalar
Row limit indicating the number of rows to retrieve at a time, specified as the comma-
separated pair consisting of 'rowInc' and a positive scalar value. Use rowInc when