Trim Issues while sending Data to Fixed length File
Posted: Sat Aug 07, 2010 12:19 pm
The input Data comes as varchar(10) - TERADATA (SOURCE)
col
0000
0009508
03669
08018
08065
0003065
09620
desired output ( i used char(5)) FIXED LENGTH FILE(TARGET)
00000
09508
03669
08018
08065
03065
09620
I have tried this code
if (DSLink3.col) ='0000' Then '00000' else DSLink3.col[3,7]
When the job ran the output is as follows
08018 output comes as 018 (it should be 08018)
09620 ------- 620
08065 ------- 065
0003065 ----- 065
Any inputs on this issue is greatly appreciated.
Thank you all.
col
0000
0009508
03669
08018
08065
0003065
09620
desired output ( i used char(5)) FIXED LENGTH FILE(TARGET)
00000
09508
03669
08018
08065
03065
09620
I have tried this code
if (DSLink3.col) ='0000' Then '00000' else DSLink3.col[3,7]
When the job ran the output is as follows
08018 output comes as 018 (it should be 08018)
09620 ------- 620
08065 ------- 065
0003065 ----- 065
Any inputs on this issue is greatly appreciated.
Thank you all.