Re: DDS Support

["Eric N. Wilson" <doulos1@xxxxxxxx>]

As many other people have pointed out, IBM has finite recourses, where
should they place them? DB2 UDB is slowly but surely being made to have all
the same features across all platforms. The lingua fracas is SQL for DDL
(Data Definition Language). Why should IBM continue to enhance a DDL that
only works on one platform?

I would like to see native support for CLOB/BLOB in RPG.

Someone else voiced a concern about not having source based info on the file
creation. Try this, create a source PF call QSQLSRC then add a member to.
You could ( and should ) have your table/index/etc. commands in a source
member and then run the source member with runsqlstmt.

Would I replace CL with REXX? You bet! (REXX resembling a real language much
more so than CL)

Eric

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: "M. Lazarus" <mlazarus@ttec.com>
To: <MIDRANGE-L@midrange.com>
Sent: Tuesday, June 27, 2000 6:55 PM
Subject: Re: DDS Support


> James,
>
> At 6/27/00 10:24 AM -0700, you wrote:
> >I, too, like the functionality of DDS.  What I am proposing is that with
> >your own methods you are no longer restricted or at the mercy of the
> >platform provider.  I learned a long time ago not to wait for IBM to
> >provide every slick method known to man kind and also I've learned that
> >IBM can pull the plug at any time they feel like it.
>
>   Since IBM is the (only) DB provider on the /400 and data definition is
an
> integral part of a DB, I think that this is a case that we should insist
> that IBM do the sensible thing for their customers, not just the direction
> du jour.
>
>   Out of curiosity, would you have the same opinion if we were talking
> about replacing CL with REXX?
>
>
> >BTW, if you -do- have to change the underlying DB (and at some time you
> >undoubtedly will), with the appropriate tool you can create new DDS and
> >new SQL and a conversion program when CHGPF or CPYF *MAP *DROP won't do
> >the job for you.
>
>   When is this the case?
>
>   -mark
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---