ContextQMD
Back to Flyway

Flyway Db2 ZOS SQL ID Setting

documentation/Reference/Configuration/Flyway Namespace/Flyway DB2 zOS Namespace/Flyway Db2 zOS SQL ID Setting.md

latest1.2 KB
Original Source

Description

The SQLID to be used in execution. This is the user under which it will create objects like tables etc. As creator, this user will get all rights on the object. If not explicitly set, the DB2z community support plugin will use the schema name as SQLID.

Type

String

Default

<i>none</i>

Usage

Flyway Desktop

This can't be configured via Flyway Desktop, although it will be honoured.

Command-line

powershell
./flyway -db2z.sqlId="example_group" info

TOML Configuration File

toml
[flyway.db2z]
sqlId="example_group"

Configuration File

properties
flyway.db2z.sqlId="example_group"

Environment Variable

properties
FLYWAY_DB2Z_SQL_ID=example_group

API

java
DB2ZConfigurationExtension dB2ZConfigurationExtension = configuration.getConfigurationExtension(DB2ZConfigurationExtension.class);
dB2ZConfigurationExtension.setSqlId("example_group");

Gradle

groovy
flyway {
    pluginConfiguration = [
        db2zSqlId: 'example_group'
    ]
}

Maven

xml
<configuration>
    <pluginConfiguration>
        <db2zSqlId>example_group</db2zSqlId>
    </pluginConfiguration>
</configuration>