Type Conversion before Look up
Posted: Wed Jan 19, 2005 3:58 pm
Hi All,
I am using newvalue:string = string_from_decimal (oldvalue) in the Modify stage to convert the type from decimal to string before I do a lookup against a DB2 table where the key is defined as char.
My questions are:
1. The oldvalue is 000. After the job is executed, it converted the oldvalue to ' 00'. Why would it do that? Well, I expected it to be '000'.
2. Is there a way that I can do a type conversion in the DB2 stage when the lookup is happening?
Thanks!!
Fan
I am using newvalue:string = string_from_decimal (oldvalue) in the Modify stage to convert the type from decimal to string before I do a lookup against a DB2 table where the key is defined as char.
My questions are:
1. The oldvalue is 000. After the job is executed, it converted the oldvalue to ' 00'. Why would it do that? Well, I expected it to be '000'.
2. Is there a way that I can do a type conversion in the DB2 stage when the lookup is happening?
Thanks!!
Fan