-SETC (SET CURRENT APPLICATION COMPATIBILITY statement)
The -SETC command sets the application compatibility level. The following sections of the worklist might include -SETC commands for a table space, table, or synonym create:
- ALIAS SECTION
- CREATE MQTS
- CREATE VIEW NOT DEPENDENT ON MQT SECTION
- CREATE TABLESPACE SECTION
- TABLE SECTION
- UNATTACHED SYNONYMS SECTION
The -SETC command is applicable in IBM Db2 V12 or later subsystems.
The worklist omits -SETC if migrating objects from a subsystem with a lower application compatibility level (V12R1M503) to a subsystem with a higher compatibility level (V12R1504). On the receiving subsystem, use an installation module that specifies the APPLCOVR=Y option.
Example of the -SETC command
***********************************************************************
-SETC 000350 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'
-SETS 000400 SET CURRENT SQLID = 'J1OSS9A'
-SQL 000450 CREATE TABLESPACE BMCSEC3 IN DQACM121
USING STOGROUP SYSDEFLT
PRIQTY -1
SECQTY -1
PCTFREE 99 FOR UPDATE -1
BUFFERPOOL BP0
CLOSE NO
SEGSIZE 4
-SETS 000500 SET CURRENT SQLID = USER
-SETC 000550 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504'
-SYNC 000600 END OF CREATE TABLESPACE SECTION
***********************************************************************
-SETC 000650 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'
-SQL 000700 CREATE TABLE DQACM121.TB_BMCSEC3
(
COL1
CHAR(6) NOT NULL WITH DEFAULT IMPLICITLY HIDDEN
)
CCSID EBCDIC
IN DQACM121.BMCSEC3
-SETC 000750 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504'
-SYNC 000800 END OF TABLE SECTION
***********************************************************************
-SETC 000350 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'
-SETS 000400 SET CURRENT SQLID = 'J1OSS9A'
-SQL 000450 CREATE TABLESPACE BMCSEC3 IN DQACM121
USING STOGROUP SYSDEFLT
PRIQTY -1
SECQTY -1
PCTFREE 99 FOR UPDATE -1
BUFFERPOOL BP0
CLOSE NO
SEGSIZE 4
-SETS 000500 SET CURRENT SQLID = USER
-SETC 000550 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504'
-SYNC 000600 END OF CREATE TABLESPACE SECTION
***********************************************************************
-SETC 000650 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'
-SQL 000700 CREATE TABLE DQACM121.TB_BMCSEC3
(
COL1
CHAR(6) NOT NULL WITH DEFAULT IMPLICITLY HIDDEN
)
CCSID EBCDIC
IN DQACM121.BMCSEC3
-SETC 000750 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504'
-SYNC 000800 END OF TABLE SECTION
***********************************************************************
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*