Garbled data on sequential file output

aesguerra · Post by **aesguerra** » Thu Oct 14, 2004 9:48 am

Hi all,

I'm trying to output data into a sequential file. Problem is, some or most of the fields in the file are garbage. I've tried setting all values to "0" but still gives me the same thing. However, when I output it to a dataset, everything looks ok. Anybody encountered something like this before?

TIA.

sandy · Post by **sandy** » Fri Oct 15, 2004 1:44 am

Can you please provide some more information?

gh_amitava · Post by **gh_amitava** » Fri Oct 15, 2004 3:50 pm

Hi,

Can you give some example of the output data ?? Also check the DataStage parameter APT_STRING_PADCHAR.

Regards
~Amitava

aesguerra · Post by **aesguerra** » Sat Oct 16, 2004 8:13 am

output of data looks something like this.

"Agent","Age"00008958",,"Regular","GG042","E3",64","25-3"H",n" 000001.","00006951"

gh_amitava · Post by **gh_amitava** » Sat Oct 16, 2004 2:21 pm

Hi,

Please give the data that you expect. I want to compare it.

Regards
Amitava

aesguerra · Post by **aesguerra** » Mon Oct 18, 2004 1:02 am

record should be something like:

"Agent", "Agent", "Regular", "GG042", "E3", ">64", "25-36 months", "Male"

Now I'm thinking that because of this I'm having some records being rejected when passing thru a lookup stage.