Enterprise Communication Interface (ECI)

eci_rea_nxt

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.

RückgabeparameterOutput 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 %