Skip to Content
0
Aug 31, 2007 at 12:14 PM

Recordeset per message with variable recordset sequence?

160 Views

Hi,

I'm uploading a text-file with three different recordset substructures in any number and in variable sequence. I.e. a file could look like below:

structure 1

structure 1

structure 3

structure 2

structure 1

structure 3

structure 1

Thus the File adapter settings are as follows:

Recordset Structure = structure 1,,structure 2,,structure 3.*

Recordset Sequence = Variable

This works fine, the problem is the file is huge and I would like to limit the number of records in each message by using the recordset per message parameter. But if you have a variable recordset sequence the whole message is regarded as one recordset. If I change to ascending sequence I get an unpredictable number of messages since a recordset change is only done every time the file "breaks the order" defined in the Recordset Structure. Basically I want each record to be regarded as a recordset so I can split the file up with a predictable number of record per message. Is there any work around possible?

//Johan