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
legendkiller
Participant
Posts: 60 Joined: Sun Nov 21, 2004 2:24 am
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
Charter Member
Posts: 91 Joined: Mon Jan 10, 2005 2:06 am
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Wed Mar 08, 2006 4:49 am
Read up on the $APT_ORACLE_PRESERVE_BLANKS setting in PX.
legendkiller
Participant
Posts: 60 Joined: Sun Nov 21, 2004 2:24 am
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.
Last edited by
legendkiller on Wed Mar 08, 2006 4:55 am, edited 1 time in total.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.