DB2 zOS SQL ID
Published 03 October 2024
DB2 z/OS SQL ID
Description
(Required) 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.
Usage
Commandline
./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>