PadChar

dspxguy · Post by **dspxguy** » Mon Oct 01, 2007 9:30 am

What impact has the APT_STRING_PADCHAR environmental variable in datastage jobs?

Do we have to add it or is it present by default when creating a project?

Thanks

DSguru2B · Post by **DSguru2B** » Mon Oct 01, 2007 10:36 am

Whatever value you set in the admin will be used as a default. If you want to overide the default value, then you need to import this env. variable in your job and set the override value.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 01, 2007 2:46 pm

It specifies the character used to pad strings, particularly Char(N) data types. Its default value is 0x00. You can change this default in the Administrator. To override the default in a particular job, add the environment variable as a job parameter - use $PROJDEF as the default value for the job parameter, and override as necessary when submitting a job run request.

dspxguy · Post by **dspxguy** » Mon Oct 01, 2007 3:08 pm

ray.wurlod wrote:It specifies the character used to pad strings, particularly Char(N) data types. Its default value is 0x00. You can change this default in the Administrator. To override the default in a particular ...

Thanks guys