Re: Null Capable Fields

Bruce,

In response to the "why not just embed SQL" comment that surfaces every now
and again, I'd like to just point out that the SQL precompiler is always
lagging behind the RPG compiler in some pretty key areas. Although I'd like
to use SQL more often, I'm not willing to give up the latest RPG
enhancements in order to do so.

Null support is something that should be fully supported within RPG. The
argument that they will support it if the demand is there doesn't hold
water. I'd LOVE to use the fully capability of null capable fields within my
applications. I don't today specifically because it is poorly supported in
RPG. This is a case of "build it, and they will come".

Regards,

John Taylor

----- Original Message -----
From: R. Bruce Hoffman, Jr. <rbruceh@ibm.net>
To: <RPG400-L@midrange.com>
Sent: Tuesday, October 12, 1999 11:44
Subject: Re: Null Capable Fields


> John P Carr wrote:
> >
> >         >Not a work around, a different way of working.
> >         >Use embedded SQL statements for IO. This allows you to then
accept
> > the
> >         >null indicators in select statements.
> >
> >         Bruce
> >
> >         It's not the fields from the file that's the problem.   He wants
to
> > have
> >         working variables(fields) in his program that are Null capable.
> >
>
> Yup. I understand and empathize, but it is a language problem. RPG
> doesn't handle it right. Yup. I know. But rather than holding my breath,
> waiting patiently for IBM to change RPG, why not just flag the field?
> Why not just bite the bullet and put the SQL in? Ugly? Sure. But
> portable. Not language dependant.
>
> If I HAVE to rely on a specific, single platform language, I sure don't
> wanna do it with my data.
>
> Just my opinion.
> --
> ===========================================================
> 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
> +---
>

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