All,
I am working on Datastage 8.1 to Datastage 8.5 migration project. I just wanted to know
a) will the extra leading & trailing spaces will be trimmed by default in datastage?
b) Do we need to explicitly use TRIM function to trim the leading & trailing space in Datastage 8.5 ?
We have noticed some weird scenario while inserting the records into a table.
yes...
i have the below file...
ABC Manpower
XYZ Pvt ltd
MVC Pipes
kk Hardwares
NJK Gardens
Datastage 8.1 inserts the record without trailing space.
say for example
ABC Manpower- In 8.1 -- it was inserted without any space after the last letter. i.e without trailing space. Other records also inserted as mentioned above.
Datastage 8.5 inserts the record with trailing space.
ABC Manpower<one empty space> - 8.5 All the records were inserted with one epmty space after the last character/letter.
how? i heard like...datastage 8.1 will TRIM the trailing spaces by default.
is it ? Datstage 8.5 won't have this facility ? is it?
Trim in 8.1 and 8.5
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Trim in 8.1 and 8.5
Karthik
DataStage will generally not automatically trim strings. Is your database Oracle? Did you use the same configuration file (DSPARAMS) in both installation? If your database is ORACLE, your setting for "APT_ORACLE_PRESERVE_BLANKS" might be different between the 2 installations and that might be causing the different behaviour.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Are both versions writing to the same database? Perhaps one Oracle installation is using other options if they are different. Also, in the 8.5 version, put in a test transform stage just before writing to the database which has a 2nd output link which has the condition "In.{StringColumn} <> Trim(In.{StringColumn})" to see if the appended space is present in DataStage before writing to the database.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact: