I am trying to read data from flat file and looking for record existance in hashedfile(which is populated from DB) . My hashed file contains a numeric field and i am getting it as 3, 4 etc. From the flat file i am getting input as 003, even though i defined the field as smallInt. Because of this my look up fails. How can i convert this 003 value to 3?
I tried using AsInteger function but datastage 7.5.1 doesn't compile.
Can some one help me solving the issue.
Last edited by svhari76 on Fri Dec 17, 2010 1:38 pm, edited 1 time in total.
I end up being using TRIM function to delete the leading zeros and it works fine now. But if i define SQL data type as smallint,integer it should work but appenrently it did not.