Hi All,
Here i am getting values (Ex: -00005 Or 00009) from source as Decimal (5). If it is -00005 then out put should be 0000A and if it is 00009 then 0000X.
Can any body explain me how to do this...Thanks
Thanks
Chilli
Search found 2 matches
- Fri Sep 25, 2009 8:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Decimal to Varchar
- Replies: 1
- Views: 708
- Mon Sep 24, 2007 8:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Driver-Error
- Replies: 1
- Views: 786
ODBC Driver-Error
Folks, WHILE I AM EXTRACTING THE DATA WITH ODBC ,I AM GETTING THE ERROR BELOW. call to SQLConnect failed. SQLSTATE=IM003, DBMS.CODE=160 [DataStage][SQL Client][ODBC]Specified driver could not be loaded due to system error 5 (IBM DB2 ODBC DRIVER). Please help me to solve this problem. Cheers, Chilli