cancel
Showing results for 
Search instead for 
Did you mean: 

FileSender Adapter - Recordset Structure Problem

Former Member
0 Kudos

Hi,

I would like to know if it is possible to create a recordset structure in the FileSender Adapter for a flatfile where certain Record Types might reoccur.

The source structure is as follows:

3222:003:051201:093056:7596:001:F:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:H:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:S:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:T:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:N:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:T:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:F:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:H:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:N:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:F:100:0011: :0000000000000000

The Key Field is the “F”, “H” etc. A new record should be created for every “F” value. I specified the following Recordset Structure on the adapter: HRecord,,SRecord,,TRecord,,NRecord,,FRecord,1

I am getting the following error message: “missing structure(s) before type 'TRecord'” on the Adapter. It works fine if the “T” record does not repeat after the “N” record. Any help would be appreciated.

Thanks

Rudi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

check this weblog.This might help u.

<a href="/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file:///people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

Regards,

Sudharshan

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Not sure if this will help, but please have a look

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Regards,

Anirban.

STALANKI
Active Contributor
0 Kudos

sorry mistake.it is not for thz thread.

STALANKI
Active Contributor
0 Kudos

/people/gowtham.kuchipudi2/blog/2006/01/13/stop-creation-of-an-empty-file-from-file-adapter-using-module

will solve it.

Former Member
0 Kudos

Did u set the record set sequence to 'variable'?

As per your input file, you shud set FRecord,* instead of FRecord,1..as it is appearing more than once...

thx

praveen

Former Member
0 Kudos

Thanks Praveen,

the "F" record is the key field, 1 "F" record per message.(see above)

The record set sequence is set to variable.

Regards