Re: Packed decimal

["Williams, Wes HS-SNS" <wes.williams@HS.UTC.COM>]

Yes it is fixed length file.  I can bring in data now and see it, but if the
length is DEC(12,3) which is equal to 8 and an integer is 1, 2 or 4 then
don't I have a problem? When I look at the data with a hex editor The values
in no way represent what I read in as integers.




Wes

-----Original Message-----
From: Franck Masson [mailto:franck.masson@BRIO.COM]
Sent: Friday, August 11, 2000 11:45 AM
To: SQR-USERS@list.iex.net
Subject: Re: Packed decimal


hi,

does your file is a fixed lenght line/record ?
if yes then it should work by using integer at the place where you have
packed fields.
Note the packed filed must be of fixed lenght.

Franck,

Wes Williams wrote:
>
> I have a flat-file that I need to read and manipulate it and appears that
SQR will not do the job. They are providing the numeric data in a MVS packed
decimal data format.
> X'0000000000121212'($1212.12)
>
> If I look at the file I see ASCII control characters for the numbers, see
attached. What the heck if anything can I accomplish with SQR?
>
> I have played with some of Tony's sqc's but to no avail.
>
> Thx
> Wes Williams
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> **********************************************************************
>
>   ------------------------------------------------------------------------
>
>                                        Name: MERCDEVL.MAX.OMPO.DMEPOS.TEST
>    MERCDEVL.MAX.OMPO.DMEPOS.TEST       Type: unspecified type
(application/octet-stream)
>                                    Encoding: base64