Re: What is 5722ST1?

When I sent off this earlier email, these are the responses I received:

Actually in V5R1 & prior the DB2 SQL Development Kit is required if you
want to create an SQL procedure, SQL trigger, or SQL function.

In summary, what are they doing with the money generated from the purchase
of 5722ST1?  Granted, shareholders and whatnot deserve a chunk, but some
should be going back into R&D.
##Some of that money goes into R&D for increasing the SQL functionality of
the iSeries, so it better supports all of the SQL interfaces that are
available

- Are they enhancing STRSQL?  I don't think so.
##No the R&D money is going to the DB2 interfaces in Ops Navigator.

- Are they enhancing STRQM?  Has anyone seen evidence of that?
##No, IBM's QMF for Windows product is another graphical product getting
the majority of R&D money.

- Are they improving the precompiler?  At least not for the last several
releases.

##No, it hasn't been improved... but based on customers requirements raised
in the last
6-9 months enhancements are planned for next year's release.  Coding for
this year's
release is frozen

- Are they putting it into DB2 for the iSeries as a whole?
If it is the last, then shouldn't they just include the functions of
5722ST1 with the base operating system?
##Actually the revenue from 5722ST1 does not go directly back into the DB2
development bucket.  It goes into the bigger iSeries development bucket and
then marketing,strategy,etc decide which areas of iSeries development
receive the R&D investment

I would suggest that you keep making the IBM executives aware of the fact
that the precompiler is slowing your efforts to use SQL - the strategic
database interface for the iSeries.


Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    rob@dekko.com
                    Sent by:                To:     rpg400-l@midrange.com
                    rpg400-l-admin@mi       cc:     rchudb@us.ibm.com
                    drange.com              Fax to:
                                            Subject:     What is 5722ST1?

                    03/22/2002 02:29
                    PM
                    Please respond to
                    rpg400-l







What is 5722ST1?
On my system it says it is DB2 Query Manager and SQL Development Kit for
AS/400.

And what does that NOT compose?  On machines without it I still have:
-RUNSQLSTM
-STRQMQRY
-Interactive SQL via Operations Navigator.
-Externally defined files.
-BLOBS, datalinks, etc
-Stored procedures
-User Defined Functions.
-etc.

So what does shelling out the money for 5722ST1 give me?
-STRSQL.  Very basic prompting.  Extremely limited as far as joins, etc.
Many commands are not supported for prompting, but can be typed in
manually.  I suspect that this won't have a lot of new features added to
it.  The latest rage is Op's Nav.
-STRQM.  Not a bad product.  Has more features than Query/400.  Just a
teensy bit less user friendly.  You actually could build your QMQRY's using
your favorite editor and the CRTQMQRY command which comes packaged with
SS1.
-The SQL precompiler.  An alternative would be using the SQL CLI's.  I've
done a little research into this, and I'd rather have a decent precompiler.

In summary, what are they doing with the money generated from the purchase
of 5722ST1?  Granted, shareholders and whatnot deserve a chunk, but some
should be going back into R&D.
- Are they enhancing STRSQL?  I don't think so.
- Are they enhancing STRQM?  Has anyone seen evidence of that?
- Are they improving the precompiler?  At least not for the last several
releases.
- Are they putting it into DB2 for the iSeries as a whole?
If it is the last, then shouldn't they just include the functions of
5722ST1 with the base operating system?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.