Multiple record types into CFF stage (EBCIDIC)
Posted: Wed May 02, 2012 1:22 pm
Hi, dont know if anyone can help - but have a job that basically needs to write an EBCIDIC file as follows
Multiple records of the following type
REC_TYPE(D) ACCOUNTNUM VALa VALb VALc VALd
Followed by a single checkrecord of type
REC_TYPE(T) ACCOUNTNUM COUNT FILLER
However this scenerio is repeated thus
D 1234 7 8 9
D 1234 12 33 9
D 1234 32 11 2
T 1234 3 xxxx
D 1111 7 8 9
D 1111 12 33 9
T 1111 2 xxxx
D 2222 7 8 9
D 2222 12 33 9
D 2222 32 11 2
T 2222 3 xxxx
The problem is that there are some 2000 values of ACCOUNT so cant do a loop in the sequencer - and keep appending to the file
But as far as I can see the CFF stage only allows you to write one particular record type (for single file headers/trailers) - have just used different jobs as the overhead is small.
To complicate the issue more - the VALa, VALb are comp-3 - but the COUNT field is PIC 9(5) - so cant even just string everything together into a single record layout.
Any help gratefully recieved
Multiple records of the following type
REC_TYPE(D) ACCOUNTNUM VALa VALb VALc VALd
Followed by a single checkrecord of type
REC_TYPE(T) ACCOUNTNUM COUNT FILLER
However this scenerio is repeated thus
D 1234 7 8 9
D 1234 12 33 9
D 1234 32 11 2
T 1234 3 xxxx
D 1111 7 8 9
D 1111 12 33 9
T 1111 2 xxxx
D 2222 7 8 9
D 2222 12 33 9
D 2222 32 11 2
T 2222 3 xxxx
The problem is that there are some 2000 values of ACCOUNT so cant do a loop in the sequencer - and keep appending to the file
But as far as I can see the CFF stage only allows you to write one particular record type (for single file headers/trailers) - have just used different jobs as the overhead is small.
To complicate the issue more - the VALa, VALb are comp-3 - but the COUNT field is PIC 9(5) - so cant even just string everything together into a single record layout.
Any help gratefully recieved