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>
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