3165 - SQL 应用程序增强.pdf

1、Sponsored byData Technical Summit IBM TechXchange 20253165Tammie DangIBM,Senior Technical Staff MemberDb2 13 for z/OS SQL and Application Administration EnhancementsAgendaCurrent function level V13R1M507V13R1M507:Restriction removal SQL syntax(DML and DDL)Access path improvement Instrumentation Appl

2、ication managementFuture function level:Built-in function Performance improvement DDL enhancements Application managementIBM TechXchange|2025 IBM CorporationV13R1M50 xFunction level V13R1M507 Remove restriction for column mask -FL506 Multiple-row INSERT with VALUES clause-FL506 Short form of APPLCOM

3、PAT-FL100 Remove restriction for temporal and archive-enable tables Built-in global variable for system-period temporal table update ALTER ADD ROWID column-FL506 ALTER to change partitioning scheme Performance improvement for IN list predicate-FL506 IFCID 350(PREPARE dynamic SQL)and 316(execution of

4、 cached dynamic SQL)FL100 Local plan execution dateIBM TechXchange|2025 IBM Corporation3Column mask enhancementIBM TechXchange|2025 IBM Corporation4Column Mask Background-20478 THE STATEMENT CANNOT BE PROCESSED BECAUSE COLUMN MASK mask-name(DEFINED FOR COLUMN column-name)EXISTS AND THE COLUMN MASK C

5、ANNOT BE APPLIED OR THE DEFINITION OF THE MASK CONFLICTS WITH THE REQUESTED STATEMENT.REASON CODE reason-code.Db2 10 feature providing column level access control for customer sensitive data Restrictions(SQLCODE-20478)when a column with column mask is referenced in some context of an SQL statement 1

6、0 reason codes5IBMTechXchange|2025 IBM CorporationColumn Mask reason codes1 1The result table of the select is derived from a set operation that involves one of the following set operators:EXCEPT ALL/EXCEPT DISTINCT/INTERSECT ALL/INTERSECT DISTINCT2 2The column is referenced in the select list of th