Trim in 8.1 and 8.5
Posted: Fri Jul 13, 2012 12:48 am
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?
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?