Description
|
Reads records blockwise from a table
|
Input parameter
|
tableName
string |
Table name (e.g. T_CAX_FIL_TMP) |
cursorId
string |
CursorId (always 0 - for future use) |
cursorAction
string |
"NEXT" (Opens cursor and/or reads next block of records)
or "CLOSE" (Closes cursor)
|
cpOraWhrCond
string |
Where condition in Oracle syntax, or "" (eg. "STRUCTURE_ID=25")
|
cpMsqWhrCond
string |
Where condition in MSSQL-Server syntax, or "" (eg. "STRUCTURE_ID=25")
|
iNumRec
string |
Max. number of records to read (the blocksize)
|
cpaRetFld
stringlist |
Name of returned fields, or "%" to read all fields of
table.
|
|
Output
parameter
|
cursorId
string |
Cursor Id (for future use)
|
iColNum
string |
Number of return fields.
|
iNumRec
string |
Number of found records. |
cpaRetFld
stringlist |
Name of return fields. |
retFldVal_1...retFldVal_n
stringlist |
Values of return fields of first record. |
... |
... |
stringlist |
Values of return fields of last record in block. |
|
|
Sample: Read all fields of the next 100 records in
table T_CAX_FIL_TMP with STRUCTURE_ID=2
Name |
Value |
tableName |
T_CAX_FIL_TMP |
cursorId |
0 |
cursorAction |
NEXT |
cpOraWhrCond |
STRUCTURE_ID=2 |
cpMsqWhrCond |
STRUCTURE_ID=2 |
iNumRec |
100 |
cpaRetFlds |
% |
|