trailing spaces getting trucated.

legendkiller · Post by **legendkiller** » Wed Mar 08, 2006 3:43 am

Hi,

my input field is char(25) and destination field in oracle target table is varchar2(30). in my data i have trailing spaces in char(25) column, when i load the data through oracle enterprise then all data is getting loaded without trailing spaces.

To avoid this do we need to some seeting for oracle enterprise stage.

kcshankar · Post by **kcshankar** » Wed Mar 08, 2006 4:05 am

Hi,
Varchar2 is for that,it save spaces.
For example "DataStage " will store as "DataStage".
Why you want trailing blank spaces in your target table?

regards
kcs

ArndW · Post by **ArndW** » Wed Mar 08, 2006 4:49 am

Read up on the $APT_ORACLE_PRESERVE_BLANKS setting in PX.

legendkiller · Post by **legendkiller** » Wed Mar 08, 2006 4:50 am

hi,

Thanks for input but i am not able to find above environment varible in datastage.

ArndW · Post by **ArndW** » Wed Mar 08, 2006 4:52 am

legendkiller - <sigh> did you actually read the information on $APT_ORACLE_PRESERVE_BLANKS? This is exactly what this setting does.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 08, 2006 8:28 am

Or is the problem that legendkiller has not done a thorough enough search in the environment variables in the Administrator client?