Discrepancy in records

suri · Post by **suri** » Thu Feb 02, 2006 1:37 pm

Hi All,
I have created a job which is loading into a file.
I am getting the required output but in couple of records from column 3 it is moving one column a head. ie 3rd column is becoming null and 4 col will have 3rd column value, 5 will have 4th value and soon.

Column 1 and 2 are hardcode values.
column 3 is current timestamp.
So the is no question of delimiter.

Since only couple of records are population with the above issue.

Please someone let me know the solution for the above issue.

Thanks
Suri

reachthiru · Post by **reachthiru** » Thu Feb 02, 2006 2:04 pm

Hi Suri,

I feel if you give more details like what is the input source and is there any changes before writing to the file, etc. Then only we can help u.

ArndW · Post by **ArndW** » Thu Feb 02, 2006 2:04 pm

I don't think you have declared the metadata for your sequential file correctly, either that or the nullability. Could you perhaps post a sample of the line as it is in the file and what you expect?