What's new for IBM i 7.1
This topic highlights the changes made to this topic collection for IBM® i 7.1.
The major new features covered in this book include:
- Three-part names in statements and aliases
- XML data type
- Global variables
- Array types in SQL procedures
- XML publishing functions
- MQ Series scalar functions
- BITAND, BITANDNOT, BITOR, BITXOR, and BITNOT scalar functions
- Currently committed concurrent access resolution
- Consuming result sets in embedded SQL
- Expressions in the CALL statement
- REPLACE option for CREATE statements
- ALTER TABLE ADD COLUMN BEFORE
- Field procedures
- Removal of identity column and constraint restrictions on partition tables
- Encoded vector indexes INCLUDE of aggregate functions
- MERGE statement
- Inlining of some SQL scalar functions
- Parameter marker enhancements
What's new as of April 2016
- Additional formatting options for TIMESTAMP_FORMAT and VARCHAR_FORMAT scalar functions.
- Enhancements to ROUND and TRUNCATE scalar functions.
- Support for the EXTIND option in SET OPTION for SQL functions, procedures, and triggers.
- Required DB2 PTF Group level tracking added for static statements to SYSPROGRAMSTMTSTAT.
What's new as of October 2015
- LIMIT and OFFSET support for queries
- OVERLAY and LOCATE_IN_STRING scalar functions
- System name for CREATE VARIABLE
What's new as of April 2015
- REPLACE option for CREATE TABLE
- VARBINARY_FORMAT and VARCHAR_FORMAT_BINARY scalar functions
- Maximum parameters for SQL functions increased to 1024
What's new as of October 2014
- LPAD and RPAD scalar functions
- REGEXP_xxx scalar functions and REGEXP_LIKE predicate for regular expression handling
- Support for PIPE statement in SQL table functions
What's new as of April 2014
- A create table statement that has a single partitioning key column can have the range partitions defined in any order.
- SYSPACKAGESTMTSTAT and SYSPROGRAMSTMTSTAT catalog views
What's new as of October 2013
- Compound (dynamic) statement can group multiple statements into an executable routine
- CREATE TABLE AS and CREATE TABLE LIKE generate REFFLD information
- An RDB alias can be specified directly in an SQL statement using a three-part name
- Maximum index size increased to 1.7 terabytes
What's new as of February 2013
- Multiple event triggers including a new trigger event predicate
- Specify system name on CREATE TABLE, CREATE INDEX, CREATE VIEW, and DECLARE GLOBAL TEMPORARY TABLE
- BASE_TABLE table function
What's new as of October 2012
- Default values for procedure parameters
- Named parameters for procedure invocation
- Allow period separator for qualification of objects in system naming
- CREATE TABLE and DECLARE GLOBAL TEMPORARY TABLE where the new table and the select-statement reference different relational databases
- A new QAQQINI option, SQL_GVAR_BUILD_RULE, to influence receiving errors for variables not found at precompile or create routine time.
What's new as of April 2012
- Obfuscation for SQL procedures and SQL functions
- XMLTABLE table function
- INSERT where the target table and the select-statement reference different relational databases
What's new as of October 2011
- SYSPARTITIONINDEXDISK view
What's new as of April 2011
- CONNECT BY for hierarchical queries
- Program name for CREATE TRIGGER
How to see what's new or changed
To help
you see where technical changes have been made, this information uses:
- The
image
to mark where new or changed information begins. - The
image
to mark where new or changed information ends.
To find other information about what's new or changed this release, see the Memo to users.
