How to insert zero while writing data to excel sheet
Posted: Thu Nov 30, 2006 1:20 pm
Hi Friends,
How to insert zero valuees while writing data to excel sheet using DataStage
Ex:
input: output
------- ----------
00004545--->00004545
I want the data in this format but by default it is removing zerso ,so please help how to insert zero values into Excel sheet.
How to insert zero valuees while writing data to excel sheet using DataStage
Ex:
input: output
------- ----------
00004545--->00004545
I want the data in this format but by default it is removing zerso ,so please help how to insert zero values into Excel sheet.