Hello Susmitha,
What are you viewing/printing the CSV file with?
To verify that you are getting the correct output in a CSV file, you
should open it up in a text editor. If you can see the whole value
(000012345) in the text editor, then the data is being generated
correctly.
What's probably happening is that you are opening the CSV file in Excel
and Excel is trying to be too smart. Excel looks at something like
000012345 and thinks it is a number so it drops the leading zeroes. Once
it has dropped those leading zeroes, you can't really get them back
inside Excel.
So, one question I would have for you is where is the CSV data supposed
to end up? If it is for an interface, then you probably don't really
need to do anything, just be aware of how Excel changes the data when it
reads it. If Excel is the target of the data, then you need to trick it
into believing that the LITM is text and not numeric. To do this, rename
your file to .txt instead of .csv. Then open the .txt file in Excel and
it will take you through the Text Import Wizard. On Step 3 make sure you
select the LITM column and specify that it is Text. When you finish
opening the document, it should treat LITM as text and display the
leading zeroes.
Good Luck,
Ellen Deak
Senior Systems Developer
Cooper Standard Automotive
JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R3M0,
Citrix Clients, Excel 2003 SP2