Hi,
My source files are complex flat files from V series Mainframe systems which send files in EBCDIC fixed length format.
I collect rejects (using the save reject mode property) from these source files into another sequential file (just being curious). Now what type of rejects should I expect to get collected in the sequential file?
For Example:
Say the source file (converted to ASCII) is like this:
Metadata - 9(3)X(3)X(3)
[ 9 stands for numeric in Mainframe world ; X stands for CHAR]
File Data: [Ignore newlines - Actual files in fixed lenght format]
001AAABBBCCC
002CCCDDDEEE
003CCCRRRTTT
...
XXXYYYZZZQQQ
<blank><blank><blank>EEERRRTTT
.....
Now I belive that I should see 2 records [ the last two shown above] in the reject file. Am I correct?
Also can sombody confirm that if the number of data bits in the file [excluding headers and trailers], are not a multiple of record length, then DataStage will not be able to read the source file [aborting with short read message - Schema read failure]?
Thanks!!
Clarification about rejects from a CFF
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 33
- Joined: Mon Nov 12, 2007 1:02 am
- Location: Bangalore
Clarification about rejects from a CFF
Rishabh Sagar V
Bangalore
Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I would expect to see all these rows in the reject file. You have declared three fields (999., XXX. and XXX.) but the "good" data have more fields than three.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 33
- Joined: Mon Nov 12, 2007 1:02 am
- Location: Bangalore
-
- Participant
- Posts: 33
- Joined: Mon Nov 12, 2007 1:02 am
- Location: Bangalore
Bounce
Anyone has any ideas? Kindly help me with this....vrishabhsagar wrote:Oh.. Very sorry... The original structure was 999,XXX,XXX and XXX.ray.wurlod wrote:I would expect to see all these rows in the reject file. You have declared three fields (999., XXX. and XXX.) but the "good" data have more fields than three. ...
Rishabh Sagar V
Bangalore
Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 33
- Joined: Mon Nov 12, 2007 1:02 am
- Location: Bangalore
Okay let me paraphrase so that my dilemma becomes clearer.ray.wurlod wrote:How about you tell us what you get on the reject link from the CFF stage? ...
I have a source CFF (with EBCDIC Fixed length data) and I rout the reject link into a column restructure sage and convert the varbinay input into a varchar output (and peek it)
Now I expect to see the whatever is being rejected from the source file in the director logs, but although the number of rejects is 2 (as expected); I can only see '??' in the director logs.
Also when I try to dump the restructured rejects into a seq file, I see blank lines (2 blank lines) in the file.
Is this happening because restructure stage (functionally) does not convert the EBCDIC source data into ASCII before giving a VARCHAR output?
Rishabh Sagar V
Bangalore
Bangalore