UseSQLFetch UseSQLFetchScroll UseSQLExtendedFetch

These parameters instruct IBM® Cognos® TM1® to use a particular fetch call.

Parameter type: optional, dynamic

When you run TurboIntegrator process that extracts information from an ODBC data source, Cognos TM1 tries to use the most efficient SQL fetch call possible. Cognos TM1 queries the ODBC driver to determine which of the following SQL Fetch calls to use to extract the data:

SQLFetch(), an ODBC 1 function

SQLExtendedFetch(), an ODBC 2function

SQLFetchScroll(), an ODBC 3 function

These parameters are all dynamic.

If Cognos TM1 receives no response when it queries the ODBC driver, your Cognos TM1 process will result in an error unless one of the following parameters is set to T in your Tm1s.cfg file:

UseSQLFetch

UseSQLFetchScroll

UseSQLExtendedFetch

These parameters instruct Cognos TM1 to use a particular fetch call. You must ensure that the call specified in Tm1s.cfg is appropriate for the ODBC driver being accessed, and you can specify only one of these parameters in Tm1s.cfg.

For example, to instruct the Cognos TM1 server to use the SQLExtendedFetch() call to extract data from an ODBC source, add the following line to Tm1s.cfg:

UseSQLExtendedFetch=T