Re: OS/400 V4R5 and OPNQRYF

A new e-newsletter from as400network.com says...

********* Club Tech iSeries DB2 UDB & SQL/400 Newsletter *********
An AS400 Network Publication           http://www.as400network.com
Home of NEWS/400 Magazine
Issue 1                                             March 22, 2001

...


3. COMING IN V5 (THE NEXT RELEASE!)
Here are a few of the more important things IBM will deliver in
V5, the NEXT release of DB2 UDB for AS/400, due out in late May of
this year:

a. The RUNSQLSTM command will be shipped along with OS/400 -- you
won't need to buy the DB2 Query Manager and SQL Development Kit
for AS/400 product to get this feature. RUNSQLSTM lets you execute
a set of SQL statements that are in a source file member. This is
a MAJOR benefit because it means you can now easily use SQL Create
Table, Create View, Create Index, and other statements to create
database objects even if you don't have the SQL Development Kit
product. If you haven't been using SQL to define your database
objects because you lacked an effective way to enter SQL
statements, be sure you take advantage of this change.

For more information about the RUNSQLSTM command, see the "DB2 UDB
for AS/400 SQL Programming Concepts" manual in the iSeries
Information Center, at
http://publib.boulder.ibm.com/pubs/html/as400/v4r5m1/ic2924/index.htm

b. You won't have to buy the ILE C/400 compiler product to use the
SQL Procedural Language (SPL) to write stored procedures. This
change will open up SPL to any developers who have the SQL
Development Kit product installed. For more information about SPL,
see the article "Inside an SQL Stored Procedure" (NEWS/400, July
1999) at
http://www.as400network.com/artarchive/index.cfm?fuseaction=viewarticle&CO_C
ontentID=3066
[requires professional membership to view online]

c. Database extenders to support Extensible Markup Language (XML)
will let you store and access XML documents and create XML
documents from existing data (and vice versa). With the DB2 XML
Extenders, you can use SQL as the main access method to your XML
documents. For more details, see the article "Sneak Peek: Object-
Relational Futures for UDB/400" (NEWS/400, January 2001),
available online at
http://www.as400network.com/artarchive/index.cfm?fuseaction=viewarticle&CO_C
ontentID=9150

d. V5 will provide an SQL Create Trigger statement and statement-
level triggers. The Create Trigger statement is a major step in
fully supporting the ANSI and IBM SQL standards. Statement-level
triggers fire once for each SQL statement rather than once for
each insert, update, or delete. For more information, see the
"Sneak Peek" article referenced above.
...

This does not address the "breaking" of existing applications however if
that will in fact happen..

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