User`s guide

7 Functions — Alphabetical List
7-206
importing large amounts of data. Retrieving data in increments helps reduce overall
retrieval time.
Example: 'rowInc',5
Data Types: double
'QTimeOut' — Query timeout
0 implies unlimited time (default) | positive scalar
Query timeout (in seconds), specified as the comma-separated pair consisting of
'QTimeOut' and a positive scalar value.
Example: 'QTimeOut',180
Data Types: double
Output Arguments
results — Query results
cursor array
Query results from executing the SQL commands, returned as a cursor array. The
number of elements in results is equal to the number of batches in the file sqlfilename.
results(M) contains the results from executing the Mth SQL batch in the SQL script. If
the batch returns a resultset, it is stored in results(M).Data.
Limitations
• Use runsqlscript to import data into MATLAB, especially if you have long
and complex SQL queries that are difficult to convert into MATLAB strings.
runsqlscript is not designed to handle SQL scripts containing continuous PL/
SQL blocks with BEGIN and END, such as stored procedure definitions or trigger
definitions. However, table definitions do work.
• An SQL script containing any of the following can produce unexpected results:
• Apostrophes that are not escaped, including the ones in comments. For example,
write the string 'Here's the code' as 'Here''s the code'.
• Nested comments.