Re: SQL Problem

[MWalter@xxxxxxxxxxxxxxx]

Can anyone smell Decimal Data Error?


Thanks,

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



                    "R. Bruce
                    Hoffman, Jr."            To:     <rpg400-l@midrange.com>
                    <rbruceh@attgloba        cc:
                    l.net>                   Subject:     Re: SQL Problem
                    Sent by:
                    rpg400-l-admin@mi
                    drange.com


                    09/14/01 10:15 AM
                    Please respond to
                    rpg400-l






-----Original Message-----
From: Phil <sublime78ska@yahoo.com>
To: rpg400-l@midrange.com <rpg400-l@midrange.com>
Date: Thursday, September 13, 2001 5:59 PM
Subject: RE: SQL Problem


>Alright Dr. Smith!
>I have two questions:
>1. How is it different (as far as level checking) from Mark's code?

I am not sure what you mean, but in SQL, you should select the fields that
you want/need and ignore the fields that you don't want/need.

>2. How do you make the pgm fail with a level check error?


In SQL, you don't. SQL and relation database technology is designed to
isolate I/O from the physical structure of the data. The level check
technology is based on native I/O where the I/O is related directly to, and
reliant upon, the physical structure of the data. These are checked at open
time. SQL does no such checking as the * is really a "convenience" item and
not meant to be the programming construct for embedded applications.

>Normally I use an external ds for my hostds.


And you can still do this and maintain isolation, just so long as you don't
then ask for all the fields (*) to be inserted into that structure. The
field definitions are what you are after in that case and will apply, but
the structure of the record as a whole is ignored.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman



_______________________________________________
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.