Too many columns in a Record
Moderators: chulett, rschirm, roy
Too many columns in a Record
Hi All,
I get flat files daily generated from COBOL extract,the job was running smoothly ,but yesterday in the prod the job is showing a lot of warnings like "Too many columns in a record".Due to this number of warnings they have stopped running the job and asking me to analyze.i am using a comma delimiter in the squential file stage.
it is looking strange to me that it has run smoothly before,but now it is showing this warnings.
Pl suggest me
I get flat files daily generated from COBOL extract,the job was running smoothly ,but yesterday in the prod the job is showing a lot of warnings like "Too many columns in a record".Due to this number of warnings they have stopped running the job and asking me to analyze.i am using a comma delimiter in the squential file stage.
it is looking strange to me that it has run smoothly before,but now it is showing this warnings.
Pl suggest me
Then check the file that is giving you the error. There must be something different about it from the ones that run without error.
Since you say they are fixed width, then it should be easy to tell. Each record should always be X bytes in length, the sum of the Display Sizes defined on your Columns tab. The bad file should have records > X bytes long.
Since you say they are fixed width, then it should be easy to tell. Each record should always be X bytes in length, the sum of the Display Sizes defined on your Columns tab. The bad file should have records > X bytes long.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Don't check the program, check the file!
DataStage isn't complaining about the program, it's complaining about the file.
What's the row length of the file? What is the total size of the file (use the wc command)? Is one an exact multiple of the other? If not there is at least one aberrant row in the file.
DataStage isn't complaining about the program, it's complaining about the file.
What's the row length of the file? What is the total size of the file (use the wc command)? Is one an exact multiple of the other? If not there is at least one aberrant row in the file.
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.