Right justified and prefixed with blanks - Fixed width file
Posted: Tue Feb 12, 2008 1:18 am
Hi,
I need to write a fixed width output file. I have converted all the column datatype to CHAR. Job is running fine without any error.
But
All the fields are left justified and suffixed with blanks. They should be right justified and prefixed with blanks.
I can pad spaces in front of all the colmns with str function.
Is there any other easy way to do it?
Thanks,
Sasikala
I need to write a fixed width output file. I have converted all the column datatype to CHAR. Job is running fine without any error.
But
All the fields are left justified and suffixed with blanks. They should be right justified and prefixed with blanks.
I can pad spaces in front of all the colmns with str function.
Is there any other easy way to do it?
Thanks,
Sasikala