DSXchange

Posted: **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.

Posted: **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

Posted: **Wed Mar 08, 2006 4:49 am**

Read up on the $APT_ORACLE_PRESERVE_BLANKS setting in PX.

Posted: **Wed Mar 08, 2006 4:50 am**

hi,

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

Posted: **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.

Posted: **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?

DSXchange

trailing spaces getting trucated.

trailing spaces getting trucated.