APT_ORACLE_PRESERVE_BLANKS = TRUE generating spaces

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
NigeGriff
Premium Member
Premium Member
Posts: 46
Joined: Mon Nov 24, 2003 5:46 am

APT_ORACLE_PRESERVE_BLANKS = TRUE generating spaces

Post by NigeGriff »

A varchar2(50) source column containing a string value less than 50 in length with no trailing spaces when loaded to target oracle table where the target column is defined as varchar2(50) is padding out the string value with trailing spaces to 50 characters in length.

My understanding was that when APT_ORACEL_PRESERVE_BLANKS is set to TRUE then only existing trailing spaces would be preserved and additional trailing spaces would not be generated to pad out the string to the maximun length of 50.

Is this the expected behaviopur of the environmental variable?
Thanks
Nigel
Post Reply