on 01-12-2006 5:28 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry mistake.it is not for thz thread.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
/people/gowtham.kuchipudi2/blog/2006/01/13/stop-creation-of-an-empty-file-from-file-adapter-using-module
will solve it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.