This release provides the following functional enhancements
described in this and the other IBM PL/I books.
DB2 V9 support
- Support for STDSQL(YES/NO)
- Support for CREATE TRIGGER (aka multiple SQL statements)
- Support for FETCH CONTINUE
- Support for SQL style comments ('--') embedded in SQL statements
- Support for additional SQL TYPES including
- SQL TYPE IS BLOB_FILE
- SQL TYPE IS CLOB_FILE
- SQL TYPE IS DBCLOB_FILE
- SQL TYPE IS XML AS
- SQL TYPE IS BIGINT
- SQL TYPE IS BINARY
- SQL TYPE IS VARBINARY
- The SQL preprocessor will also now list the DB2 coprocessor options
Debugging improvements
- Under TEST(NOSEPNAME), the name of the debug side file will
not be saved in the object deck.
Performance improvements
- Support, under ARCH(7), of the z/OS extended-immediate facility
- Exploitation of the CLCLU, MVCLU, PKA, TP and UNPKA instructions under ARCH(6)
- Exploitation of the CVBG and CVDG instructions under ARCH(5)
- Expanded use of CLCLE
- Conversions involving DB2 date-time patterns are now inlined
- The ALLOCATION built-in function is now inlined
- Conversions with a drifting $ have been inlined
- Conditional code has been eliminated from assignments to PIC'(n)Z'
- Conversions from FIXED BIN to a PICTURE that specifies a scale factor have been inlined
- Assignments to BIT variables that have inherited dimensions but which
have strides that are divisible by 8 will now be inlined
Usability enhancements
- The MAP output will now also include a list in order of storage
offset (per block) of the AUTOMATIC storage used by the block
- Conformance checking has been extended to include structures
- Listings will now include 7 columns for the line number in a file
- The THREADID built-in function is now supported under z/OS
- The PICSPEC built-in function is now supported
- The new CEESTART option allows you to position the CEESTART csect
at the start or end of the object deck
- The new PPCICS, PPMACRO and PPSQL options allow you to
specify the default options to be used by the corresponding preprocessor
- The ENVIRONMENT option is now included in the ATTRIBUTES listing
- The DISPLAY option now supports a suboption to allow different DESC codes
for DISPLAY with REPLY versus DISPLAY without REPLY
- The message flagging a semicolon in a comment will now include the line
number of the line where the semicolon appears
- Flag assignments that can change a REFER object
- Flag use of KEYED DIRECT files without a KEY/KEYFROM clause
- Flag use of PICTURE as loop control variables
|
This information center is powered by Eclipse technology. (http://www.eclipse.org)