Skip to Content
0
Former Member
Feb 17, 2009 at 11:01 AM

Recordsets per message - only works with RECORDSET

26 Views

I have previously got recordsets per message working when I use RECORDSET. I now have a scenario that uses "row" instead of "RECORDSET".

This is working for RECORDSET - it splits into a new message every 100 records........

Recordset Name RECORDSET

Recordset Structure RECORDSET,100

Recordsets per Message 100

ignoreRecordsetName true

RECORDSET.fieldNames RECORDCODE,ACCOUNTID,CO..............

RECORDSET.fieldFixedLengths 2,6,1,3,4,3,2,1,.............

RECORDSET.lastFieldsOptional yes

When I change RECORDSET to be row - it only produces 1 message, even though 11,000 records

Recordset Name row

Recordset Structure row,950

Recordsets per Message 950

ignoreRecordsetName true

row.fieldNames RECORDCODE,ACCOUNTID,CO..............

row.fieldFixedLengths 2,6,1,3,4,3,2,1,.............

row.lastFieldsOptional yes

Can anyone tell me what I am doing wrong?