DB2 z/OS
Versions
Default Driver
- com.ibm.db2.jcc.DB2Driver
Sql Script Syntax
Compatibility
- DDL exported by DB2 for z/OS can be used unchanged in a Flyway migration.
- Any DB2 sql script for z/OS executed by Flyway, can be executed by db2 for z/OS (after the placeholders have been replaced).
Example
/* Single line comment */
CREATE TABLESPACE SENVIR
IN "${schema}"
USING STOGROUP SENSITIV PRIQTY -1 SECQTY -1 ERASE NO FREEPAGE 0 PCTFREE 10
DEFINE YES TRACKMOD YES SEGSIZE 64
BUFFERPOOL BP3
LOCKSIZE PAGE
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID UNICODE
;
CREATE TABLE test_user (
navn VARCHAR(25) NOT NULL
) IN "${schema}".SENVIR
CCSID UNICODE
;
/*
Multi-line
comment
*/
insert into test_user(name) values ('Mr. T');
Limitations
- Create Schema - is not supported in db2 on zOS
- Drop Schema - is not supported in db2 on zOS
MySQL
Boxfuse 