Page 1 of 1

Garbled data on sequential file output

Posted: Thu Oct 14, 2004 9:48 am
by aesguerra
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.

Posted: Fri Oct 15, 2004 1:44 am
by sandy
Can you please provide some more information?

Posted: Fri Oct 15, 2004 3:50 pm
by gh_amitava
Hi,

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

Regards
~Amitava

Posted: Sat Oct 16, 2004 8:13 am
by aesguerra
output of data looks something like this.

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

Posted: Sat Oct 16, 2004 2:21 pm
by gh_amitava
Hi,

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

Regards
Amitava

Posted: Mon Oct 18, 2004 1:02 am
by aesguerra
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.