Data Transformation Engine ODBC Adapter Reference Guide

Chapter 4 - ODBC Adapter Commands Adapter Command Summary
ODBC Adapter Reference Guide
13
Database Adapter Type (-DBTYPE)
Use the Database Adapter Type adapter command (-DBTYPE) to specify the
database adapter type.
-DBTYPE ODBC
Option Description
ODBC
The database adapter type is ODBC.
Note This command must be specified if the original card is
not a database and no database is specified using the
Database/Query adapter command (-MDQ) and the
Database Name adapter command (-DBNAME).
Row Count (-ROWCNT)
Use the Row Count adapter command (-ROWCNT) to specify the number of rows to
be retrieved per fetch.
-ROWCNT
row_count
Option Description
row_count
This is the number of rows to be retrieved per fetch.
The time to fetch is optimized in accordance with the
increase in the number of rows to retrieve. Therefore, a
significant performance improvement may be gained by
retrieving as many rows as possible in a single fetch.
Note The number of rows retrieved is limited only by the
amount of memory installed on the querying PC.
The default for the number of rows to be retrieved per
fetch for the ODBC adapter is one row.