RE: RPG400-L Digest, Vol 8, Issue 563

I, too, have gotten the "Data loss may occur" when using CHGPF. In all cases it came when I was dropping some filler field that a S/34/36 programmer (that did not really understand blocking) had inserted to make the field some factor of 256. Pressing help (F1) on the error will, IIRC correctly, tell you what field is being dropped or truncated.

I have taken to using SQL's DDL to define tables in the last couple of years. I have never had to change those tables, but I have wondered if ALTER Table worked like CHGPF. Haven't tried it nor RTFM nor searched the archives in this regard. When a real need arises, I will.

Thanks.

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of dale janus
Sent: Monday, July 27, 2009 8:16 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: RPG400-L Digest, Vol 8, Issue 563

Hmmm, why not use CHGPF?

Because old habits die hard?

Because the first time I tried CHGPF I got a warning message that scared
me that I could lose data?

Because you're in a hurry?

CHGPF sounds like a better way of doing things that I will try next time.
Thanks for the suggestions.

---Dale

Why do you use CPY instead of just doing a CHGPF on the file once you added the new fields to the source? You can add the fields anywhere you want and the CHGPF takes care of mapping the data

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of dale janus
Sent: Friday, July 24, 2009 4:41 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: timestamp data type in DDS

Thanks to all who pointed out my dumb mistake of using *nochk instead of
*map and *drop. That fixed it.

I wish PHP would say "invalid data" instead of Fetch failed. But at
least now I know what to look for.

I will sign up to midrange -l and ask future questions like this over
there, for those who suggested that approach.

Thanks.

---Dale

IMPORTANT: This email is intended for the use of the individual
addressee(s) named above and may contain information that is
confidential, privileged or unsuitable for overly sensitive persons with
low self-esteem, no sense of humor or irrational religious beliefs. If
you are not the intended recipient, any dissemination, distribution or
copying of this email is not authorized (either explicitly or
implicitly) and constitutes an irritating social faux pas. Unless the
word absquatulation has been used in its correct context somewhere other
than in this warning, it does not have any legal or no grammatical use
and may be ignored. No animals were harmed in the transmission of this
email, although the terrier next door is living on borrowed time, let me
tell you. Those of you with an overwhelming fear of the unknown will be
gratified to learn that there is no hidden message revealed by reading
this warning backwards, so just ignore that Alert Notice from Microsoft.
However, by pouring a complete circle of salt around yourself and your
computer you can ensure that no harm befalls you and your pets. If you
have received this email in error, please add some nutmeg and egg
whites, whisk and place in a warm oven for 40 minutes.