Re: SQL Problem

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