Re: changing two fields in a file

[John Hall <jhall@xxxxxxxxxxx>]

> 
> > I am thinking this is easy but I have been able to really complicate it.
> >
> > I have a file where the record has 110 fields in it.   Two of those fields
> > are to be changed, one from 1 alpha to 4 numeric, the other from 1 numeric
> > to 4 numeric.
> >
> > This seems to me to be a 15 line program but it isn't turning out that
> > way.  Any ideas of a good fast algorithym to do it?
> 
> what's the problem?  the alpha field turning numeric?
> 


If you create the new file with all of the same field names then you
should be able to do a cpyf *MAP

It should work for you as long as the alpha field only contains numeric.

If this doesn't work split it into two conversions.

First Define the 1 Alpha field as 1 Numeric.  Then do a cpyf *NOCHK this
will "force" the data in.

Then you can do a chgpf to change the field lengths on the (2) 1 numeric
fields.

You shouldn't need to write a program at all.


John Hall
Home Sales Co.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---