User`s guide

runsqlscript

7-207

• An SQL script containing more than 25,000 characters causes runsqlscript to

return an error.

More About

Batch

One or more SQL statements terminated by either a semicolon or the keyword GO.

Tips

• Any values assigned to rowInc or QTimeOut apply to all queries in the SQL script.

For example, if rowInc is set to 5, then all queries in the script return at most five

rows in their respective resultsets.

• You can set preferences for the resultsets using setdbprefs. Preference settings

apply to all queries in the SQL script. For example, if the DataReturnFormat is set

to numeric, all the resultsets return as numeric matrices.

• “Preference Settings for Large Data Import”