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 generatedselect
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.