Zoned decimal is standard EBCIDC format with one character per byte.
Regardless of how you format stuff in Oracle, when you send a flat file (not
in binary), it is going to be done via ascii, which is different from EBCIDC
and which will have a diffeerent collating sequence. The solution is going to
be having a program on the mainframe side take your flat file and do the
necessary conversions (this might be done via JCL and using a utility like
Ibegener to properly format your file, it can run as soon as the file transfer
completes successfully). Even if Oracle is able to do it, I would rather have
a flat file sent to me and handle any conversions on the mainframe side.
In article <72uot3$mu$1_at_Starbase.NeoSoft.COM>, allenh_at_Starbase.NeoSoft.COM
(Allen) wrote:
>
>I have financial information stored in an Oracle database. I have to
>generate a flat file that gets uploaded to a mainframe (yuck), and the
>financial data has to be in zoned decimal format. Is there a way for
>Oracle to convert the numbers to zoned decimal numbers? I couldn't find
>anything in the TO_CHAR number format options. Any other package,
>procedure or function out there that can do this? Any info MUCH
>appreciated...
>
>thx.. Allen
>
Received on Wed Nov 18 1998 - 10:00:11 CST
