Hi all,
I have a server job having a sequential file as source. This file has a field DC_ID with 'Incomplete column' value set to 'Error'.
This field is being mapped to another sequential file in same format. But on compilation I get the follwoing error:
The Incomplete column value of Column DC_ID must have values in ascending order
Can anybody tell me the meaning and reason for this error??
Thanks in advance.
Incomplete column value??
Moderators: chulett, rschirm, roy
Re: Incomplete column value??
Could you post your job design and the complete error message. ie., the stage where you are getting the error, you can identify it by clicking show error or more buttons on compile window.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray,
Thanks for your response. I understood the different options for 'incomplete column' from DataStage help. However, I still have a query...
In my job, the DC_ID is 10th out of 15 columns in the input file. Incomplete column value is set to Error for it. While mapping to an intermediate file, I make it the last column of the file. In doing so, DataStage does not accept any value for 'incomplete column' rule other than Replace.....What can be the possible reason for this behavior?
Thanks for your response. I understood the different options for 'incomplete column' from DataStage help. However, I still have a query...
In my job, the DC_ID is 10th out of 15 columns in the input file. Incomplete column value is set to Error for it. While mapping to an intermediate file, I make it the last column of the file. In doing so, DataStage does not accept any value for 'incomplete column' rule other than Replace.....What can be the possible reason for this behavior?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have to set column#15 first, then column #14, and so on till you get to column #10. And higher-numbered columns must always have "weaker" rules than lower-numbered columns.
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.