Re: comp-3 fields

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 22 Jun 2005 08:01:44 -0700
Message-ID: <1119452512.782589_at_yasure>


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)
Received on Wed Jun 22 2005 - 17:01:44 CEST

Original text of this message