db2 Raw sql file having "CONNECT TO DB" while executing it throwing error

Description

*java -jar liquibase.jar --driver=com.ibm.db2.jcc.DB2Driver --classpath="/opt/ibm/db2/V10.5/java/db2jcc4.jar" --url="jdbc:db2://boxname:5228/DBUOB55" *

*<changeSet author="ganapathineediv" id="BNK">

<sqlFile dbms="db2" encoding="utf8" endDelimiter=";" path="modules/database/install/bnk/data/default/tmp/ARCISOCURRENCYCD.sql" relativeToChangelogFile="true" splitStatements="true" stripComments="true"/>

</changeSet>

Liquibase is failing while executing db2 raw sql file. At very first line "CONNECT TO dbuob55". But if i comment this line rest of the script going good.

Unexpected error running Liquibase: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=TO;CONNECT ;JOIN <joined_table>, DRIVER=4.19.26 [Failed SQL: CONNECT TO dbuob55]

But if I run same from command line db2 "CONNECT TO dbuob55" working fine.

My raw sql file use to run through command line. Now I am doing POC on Liquibase and this is a show stopper issue as hundreds of raw sql files are having this line "CONNECT TO dbuob55". It is not possible to comment in all the scripts files.

Environment

AIX@DB2

Status

Assignee

Unassigned

Reporter

vijay murali krishna

Labels

None

Fix versions

Affects versions

Priority

Blocker
Configure