×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I wasn't aware that SQL was still a separate chargeable package anymore.
Oh yes, DB2 Query Manager and SQL Development Kit for i 7.1 (5770-ST1 at i
7.1) is still a chargeable Program Product (LPP). The Announcement Letter
states;
"DB2 Query Manager and SQL Development Kit for i 7.1 contains the following
functions that assist users and application developers to write SQL queries
and application programs for the DB2 for i database manager:
* Query Manager, an interactive query and report generator, allows users
to define and run queries accessing DB2 for i databases. Data edit and
report capabilities are also provided.
* The SQL Development Kit provides precompilers and tools for processing
SQL statements embedded in the C, C++, RPG, COBOL, and PL/I programming
languages. Runtime support for the programming languages is provided
directly by the DB2 for i database manager.
* Interactive SQL is a query environment that allows users and
programmers to enter and execute SQL interactively.
This product is only required for Query Manager and SQL application
development. Once created, these applications can be run on other servers
running IBM i which do not have this product installed, using the DB2 for i
database manager support."
5770-ST1 is needed to create programs with embedded SQL and to use the
green-screen STRSQL tool. However, the runtime is incorporated in DB2 on i.
So, you can run your compiled programs, use CLI, execute the CL command
RUNSQLSTM, etc. without 5770-ST1. (You can also use the SQL facilities in
Access for i (Windows), Access for i (Web), QuantumDB plug-in for RDp, etc.
without the LPP.)
Brian Parkins.
midrange.com
