5486LPDb.fm Draft Document for Review October 18, 2004
618 IBM Eserver i5 and iSeries System Handbook
Components
Query Manager, an interactive query and report generator, allows users to
define and run queries accessing DB2 UDB for iSeries databases. Data edit
and report capabilities are also provided.
SQL Development Kit provides precompilers and tools for processing SQL
statements embedded in the C, RPG, COBOL, PL/I, and REXX programming
languages. Support is also included for the ILE compilers. Runtime support
for the programming languages is provided directly by the DB2 UDB for
iSeries database manager.
Interactive SQL is a query environment that allows users and programmers
to enter and execute SQL interactively.
New with V5R3
Query Manager and SQL Development Kit for iSeries include the following
enhancements:
Interactive SQL session attributes:
– Partitioned table support added for file output
– A session attribute added for SQL rules
– A session attribute added for password visibility
Query Manager
– Data type support for Binary, Varbinary, up to 63 digits for large decimal
numbers, UTF-8 and UTF-16
SQL Pre-compilers
– Binary, Varbinary, and up to 63 digits for large decimal numbers
– New command parameters COMPILEOPT and DECRESULT
– Allow a data structure in an UPDATE statement
– SQL diagnostics area changes
– Increased length of user ID parameter
– ILE RPQ enhancements that allow the use of:
• Qualified subfields
• Array data structures
• LIKEDS
• RPG logical (indicator) variable
• LIKEREC
• Recognize CCSID keyword
• Add an option so that /Copy directives and the conditional logic of / If, /
Else, / Elseif, / Endif, / Eof, / Define, and / Undefine directives are
understandable for the precompiler.
To Next Page
Loading...
Need help?
General