Re: Null Capable Fields

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

Buck Calabro wrote:
> 
> Bruce,
> Good point, but the original question revolved around work fields, and using
> SQL for work variables is a bit messy, to say the least.  All SQL variables
> are nullable,

Uhhh.... no. The SQL variable may be nullable, but the SQL columns can
be set to not allow nulls. If the table came from DDS, the default is no
nulls.

> so writing an SQL-language stored procedure may be one way to
> approach this.  Of course, if one wants to write an SQL-language stored
> procedure one needs to have the C compiler, DB2 Query manager and the SQL
> development kit installed...  Sigh.
>

Again, no. Stored procedures do not require the C compiler. You can
write them in RPG IV, COBOL, REXX or SQL. Yes, you require the toolkit
to have the precompilers, but again, in this day and age, why not have
access to your database through the same interface that virtually ALL of
the other databases use?


-- 
===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---