Re: SQL Problem

<Raising my Hand :-)>



Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "Peter Dow"
                    <pcdow@yahoo.com>        To:     <rpg400-l@midrange.com>
                    Sent by:                 cc:
                    rpg400-l-admin@mi        Subject:     Re: SQL Problem
                    drange.com


                    09/14/01 03:10 PM
                    Please respond to
                    rpg400-l






Hi Mark,


From: <MWalter@hanoverwire.com>
> Regardless of your choice of I/O, you still have to handle the data
> properly. The AS/400 supplies the record format level id that helps you
in
> this.
> In using SQL, by selecting only the columns that I need, if the
underlying
> database structure changes, unless a change is made to one of the columns
> selected, I don't need to recompile.


Yes, but if you're using SQL, and a change *is* made to one of the columns
(e.g. changing character to packed-decimal without changing the field name,
or changing the length of a field), you have no warning, although you
*might* get a run-time error, since (as you can see from a compiled
SQLRPGLE
listing) your program is actually doing EVAL's to move data, and EVAL's
will
not convert character-to-numeric or vice versa as MOVE does.

With native I/O, you'd get a CPF4131 level-check error when the file is
being opened.

Raise your hand if you've seen more than one report with 404040.40 in a
money field<G>.

Regards,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.