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

none

Usage

Flyway Desktop

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

Command-line

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

TOML Configuration File

[flyway.db2z]
sqlId="example_group"

Configuration File

flyway.db2z.sqlId="example_group"

Environment Variable

FLYWAY_DB2Z_SQL_ID=example_group

API

DB2ZConfigurationExtension dB2ZConfigurationExtension = configuration.getPluginRegister().getPlugin(DB2ZConfigurationExtension.class);
dB2ZConfigurationExtension.setSqlId("example_group");

Gradle

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

Maven

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