How to avoid NULL Character in File.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

How to avoid NULL Character in File.

Post by laknar »

Hi,

We are generating the Files

when we generate the file getting (^@) i.e Null Character(Char(0)).
Due to this we are unable to load the file.
mahadev.v
Participant
Posts: 111
Joined: Tue May 06, 2008 5:29 am
Location: Bangalore

Post by mahadev.v »

You need to provide more information. Start by posting the exact error message and also search on that error message. And next time dont forget to ask a question.
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Post by laknar »

1$244$^@$$$
Where $ is Delimiter.
but ^@ generating extra.
I beleive this is due to Empty STring.
dsusr
Premium Member
Premium Member
Posts: 104
Joined: Sat Sep 03, 2005 11:30 pm

Post by dsusr »

Change the value of APT_STRING_PADCHAR variable to '' or Hex value 0x20.

you can do this either at project level or can add this parameter in the job and change its value for the specific job.
Post Reply