Jon,
Yes. Here's a way to cheat the system. Make a DD version of the same table
(say V200). Expand the packed fields to zoned (leave same name) and then
use the DD reformat pgm supplied by CA. You would extract the table and
run the reformatter and ctl stmt would input PROD status and output V200.
Data is then the way you want it....
Glenn Hart
Dynamic Consultants Intl, Inc.
At 08:29 AM 2/20/98 -0800, you wrote:
I tried to extract from datacom using DBUTLTY and the flat file has packed
fields in it. After searching the internet, I found that
CA suggests using EZtrieve to convert, IBM has a utility in OS/2 CICS to
convert, Microfocus Cobol and Realia have utilities too.
Unfortunately, we don't have any of those tools here. My next attempt
will be to use FileAid or Sort and probably give up and just write
an Ideal program for every singe table that has packed fields.
I bet there has already been a discussion of this issue here. Has anybody
done this before? Did you have to write an Ideal program for each table or
is there a way to use DBUTLTY to unpack those numbers?
>
>
>
I'm back at least until 3/23. JB