equivalent DB2/sql query

[kkumardatastage]

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

[kkumardatastage]

SELECT CHAR(RTRIM(CHAR(293))|| RIGHT(RTRIM('0000000000'|| SUBSTR(CHAR(Column1),1,10-(POSSTR(CHAR(Column1),'.')))),10))