Hi, I have created an output file in a datastage job that has 3 fields. One of the 3 fields is a varchar 50. We are having trouble reading this same file into a seperate DataStage job. We can't understand why DataStage can create a file in one job, but cannot read that same file into another job. We assume it has something to do with var char.
When we view the data in MS Word we see this
00000"100","2005-11-02-10.57.08.000000"
12"1","2005-11-02-10.57.08.000000
The ouput file is "delimeter = comma quote = double"
Problems reading file with varchar field
Moderators: chulett, rschirm, roy
Hello RStone,
in this case I do not think that VarChar is the culprit, it is one of your file-level formatting options or specific settings for your first column. You are adding a binary length value where you do not need (or want) to. I can't open a PX designer window to list the specific settings that can cause this, but there are some length prefix options that will do this to your file.
in this case I do not think that VarChar is the culprit, it is one of your file-level formatting options or specific settings for your first column. You are adding a binary length value where you do not need (or want) to. I can't open a PX designer window to list the specific settings that can cause this, but there are some length prefix options that will do this to your file.