# 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.
### 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 | %