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.
trailing spaces getting trucated.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Sun Nov 21, 2004 2:24 am
Read up on the $APT_ORACLE_PRESERVE_BLANKS setting in PX.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 60
- Joined: Sun Nov 21, 2004 2:24 am
hi,
Thanks for input but i am not able to find above environment varible in datastage.
Thanks for input but i am not able to find above environment varible in datastage.
Last edited by legendkiller on Wed Mar 08, 2006 4:55 am, edited 1 time in total.
legendkiller - <sigh> did you actually read the information on $APT_ORACLE_PRESERVE_BLANKS? This is exactly what this setting does.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: