Hi
Please could any one can help me in this
i want equivalent DB2/sql query for the logic.This logic is in datastage so i want it as sql query:
Logic: '12345': PadString('','0',(10-len(Field(trim(Column1),'.',1)))):Field(trim(Column1),'.',1).
Note: Column1 has the datatype as BIGINT Column1 input data have
-1
1234
-2
4567
Thanks in advance
equivalent DB2/sql query
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 84
- Joined: Sat Jul 19, 2008 8:50 am