Data Retrieval on DB2

There are some limitations on retrieving data with the asterisk (*) wild card in a retrieve profile.

Stepped Hitlist

The stepped hitlist mechanism is fully supported. By default, 10 hits are selected per step. This can be overruled by the connector option step size.

read

The following clauses of the read ProcScript statement are supported, with the indicated restrictions:

  • offset option for data pagination—supported for the DB2 U4.0 connector and higher.

  • where clause—fully supported. All text between the double quotation marks (") is inserted in the generated select statement.

Using the offset Option

On Windows or Unix, to use the offset option in the read statement, you need to configure the DB2 server to support the SQL LIMIT and OFFSET keywords.

To do so, set DB2_COMPATIBILITY_VECTOR to MYS or 4000; for example: dbset DB2_COMPATIBILITY_VECTOR=4000. Then stop and start the DB2 server (db2stop and db2start). For more information, consult the DB2 documentation.

Related Topics