I am trying to bring in a sequencial flat flile that is fixed width. The file format that I have brought into manager matches the file and I have made all the coloumns nullable. But when I run the job I get the following error:
NewJobTemplate..BPPastImp.Import: read_fixedwidth() - row 3, column Nvocc_Code, required column missing
I can open the file and see whats happening. The first two rows have data in the last coloumn, which is NVOCC_Code but the third row does not have any data there. That matches my business rules, but I cant get datastage to accept it. Has anyone seen anything similar and can tell me what little thing that I am missing. Im sure its simple, im just in it too deep to see it.
thanx
Jim
End Of File
Moderators: chulett, rschirm, roy
All you need to do is change some values in your Sequential stage. Scroll it over to the right and you'll see a (somewhat hidden) column labeled "Incomplete Column". It defaults to "Error" which is what is causing you grief. If it's not required to have data in that field, change it to "Replace" or "Retain". Check the online help for a description of all of the choices available there.
-craig
-craig
Jim
I'm pretty new to DataStage but I think I just successfully dealt with a similar problem. I have an input file of records with fixed-field lengths. Not all the records have data in some of the last records however so, in effect, the records are variable-length.
What I did was to edit the input sequential stage. In the Output/Format Tab, I checked the "suppress row truncations warning" checkbox and selected "map empty string" for the "missing columns action" listbox. THEN, I went to the "columns" tab and set the "nullable" column to "YES" for all of the trailing columns where there might not be data. This gave me the output file I was trying to obtain.
One catch that I have not taken care of yet... I get lots of warnings in the log file each time a field is missing in the input...
I hope that this helps... Have a good day everyone.
Dan Marshall
Alberta Learning
Edmonton, AB
I'm pretty new to DataStage but I think I just successfully dealt with a similar problem. I have an input file of records with fixed-field lengths. Not all the records have data in some of the last records however so, in effect, the records are variable-length.
What I did was to edit the input sequential stage. In the Output/Format Tab, I checked the "suppress row truncations warning" checkbox and selected "map empty string" for the "missing columns action" listbox. THEN, I went to the "columns" tab and set the "nullable" column to "YES" for all of the trailing columns where there might not be data. This gave me the output file I was trying to obtain.
One catch that I have not taken care of yet... I get lots of warnings in the log file each time a field is missing in the input...
I hope that this helps... Have a good day everyone.
Dan Marshall
Alberta Learning
Edmonton, AB
quote:Originally posted by chulett
[br]All you need to do is change some values in your Sequential stage. Scroll it over to the right and you'll see a (somewhat hidden) column labeled "Incomplete Column". It defaults to "Error" which is what is causing you grief. If it's not required to have data in that field, change it to "Replace" or "Retain". Check the online help for a description of all of the choices available there.
-craig
Well Craig, that certainly sounds easier.. thanks, I'll try that too. Sorry if my earlier reply confused anyone.
Dan Marshall
Alberta Learning
Edmonton, AB
[br]All you need to do is change some values in your Sequential stage. Scroll it over to the right and you'll see a (somewhat hidden) column labeled "Incomplete Column". It defaults to "Error" which is what is causing you grief. If it's not required to have data in that field, change it to "Replace" or "Retain". Check the online help for a description of all of the choices available there.
-craig
Well Craig, that certainly sounds easier.. thanks, I'll try that too. Sorry if my earlier reply confused anyone.
Dan Marshall
Alberta Learning
Edmonton, AB
I actualy did all that you suggested and it worked!!!
Thanx for the help
Jim
quote:Originally posted by danjm
[br]quote:Originally posted by chulett
[br]All you need to do is change some values in your Sequential stage. Scroll it over to the right and you'll see a (somewhat hidden) column labeled "Incomplete Column". It defaults to "Error" which is what is causing you grief. If it's not required to have data in that field, change it to "Replace" or "Retain". Check the online help for a description of all of the choices available there.
-craig
Well Craig, that certainly sounds easier.. thanks, I'll try that too. Sorry if my earlier reply confused anyone.
Dan Marshall
Alberta Learning
Edmonton, AB
Thanx for the help
Jim
quote:Originally posted by danjm
[br]quote:Originally posted by chulett
[br]All you need to do is change some values in your Sequential stage. Scroll it over to the right and you'll see a (somewhat hidden) column labeled "Incomplete Column". It defaults to "Error" which is what is causing you grief. If it's not required to have data in that field, change it to "Replace" or "Retain". Check the online help for a description of all of the choices available there.
-craig
Well Craig, that certainly sounds easier.. thanks, I'll try that too. Sorry if my earlier reply confused anyone.
Dan Marshall
Alberta Learning
Edmonton, AB