Re: BLOB's on AS/400?

["Nelson C. Smith" <ncsmith@xxxxxxxx>]

Amen, Mark.

----- Original Message -----
From: "M. Lazarus" <mlazarus@ttec.com>
To: <RPG400-L@midrange.com>
Sent: Tuesday, May 02, 2000 9:37 PM
Subject: Re: BLOB's on AS/400?


> David,
>
> At 5/2/00 11:18 AM -0600, you wrote:
>
> >I know I have accessed a CLOB using RPGIV, it could be that I used
> >embedded SQL, I will
> >have to check when I get home.  What is the error you get and out of
> >curiosity why do you
> >need native support?
>
>   I think that in the zest to try / develop new things (i.e. SQL) a big
> point is being missed.  RPG is *the* primary language on the AS/400!  One
> of the major strengths of the /400 is its DB. Following this simple logic,
> all DB2/400 data and data types should be accessible (at least in some
> fashion) directly from RPG.  This rules out embedded SQL, since:
> A) It is an add-on product, not part of the base compiler.  (As an aside
to
> IBM, if you're trying to make SQL the powerhouse data access tool, include
> it as part of the database product.  Take a lesson from M$.  "They do
> marketing right!")
> B) SQL is kludgy in RPG
> C) The SQL pre-compiler is usually behind the times.
>
>   Therefore, RPG and DDS should support all DB data definition and
> manipulation.
>
>   JMHO.
>
>   -mark
> +---
> | 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
+---