Re: comp-3 fields

Scott Winston via DBMonster.com wrote:
> I am using SQLPLUS to extract information from an oracle table. I need to
> format the output for a cobol program to read. Can I create a field on the
> output file that is a comp-3 format (packed decimal field)????
>
> Thank you
>
> Scott Winston

DECIMAL data is in packed decimal format: two digits per byte, except for the last byte, which contains a digit and sign. DECIMAL fields allow the specification of an implied decimal point, so fractional values can be represented.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10825/ldr_field_list.htm#sthref1161

Further research can be done at:
http://tahiti.oracle.com

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)