Semi-Optimistic

[bvining@xxxxxxxxxxxx]

David,

There are no exceptions to using SQL's "fun" when the SQL program product
is not installed.  SELECT functionality can be matched using the Query
(QQQQRY) API or the Process Extended Dynamic SQL (QSQPRCED) API; likewise
either API (among others) could be used by a user-written SQL based
precompiler in order to provide support for imbedded SQL.  AS/400 development
has been very careful to ensure that the SQL program product is not the only
method by which one can access OS/400 based function.

Eric,

In order to use SQL functionality there is no need to purchase the SQL
program product.  Many users may feel however that the program product
is a good investment relative to writing their own SQL (or other DB
language) based front end due to the up front cost of learning the
APIs and then building their own HLL precompilers and/or interactive
prompting support.

Bruce

>
>Eric,
>
>It would be nice if SQL were free, but you can utilize most of SQL's function
>without purchasing SQL.  Exceptions are embedded SQL, and running
>select statements.
>
>David Morris
>
>>>> <eric.delong@pmsi-services.com> 02/19 12:28 PM >>>
>
>     So, if SQL is the preferred method, then when is SQL/400 going to
>     become a "free" licensed program? It just doesn't make sense to me
>     that:
>     1) If SQL is a fully supported feature of OS400 (already built in),
>     and
>     2) IBM increases value of DB2 and SQL by optimizing and enhancing
>     its technology, then
>     3) We who develop OS400 application can't use any of this unless we
>     shell out $$$ to access features built-in to OS400 (which we've
>     already paid for).
>
>     eric.delong@pmsi-services.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
+---