i’m quite new to liquibase so i wish your kindness.
I try using changelog wto create stored procedures.
My problem is relating to delimiters.
The sql code of my SP uses ; as delimiter so to create the SP i use @ delimiter
encoding=“ISO-8859-1” endDelimiter="@" splitStatements=“false” />
I need to generate SQL to send to DBadmins but it mixes
MY_SP.sql (with @ delimiter)
INSERT INTO DATABASECHANGELOG … (with ; delimiter)
DROP PROCEDURE MY_SP()@
CREATE OR REPLACE PROCEDURE MY_SP()
INSERT INTO ACATLS.DATABASECHANGELOG … ;
The resulting SQL code is wrong because there is no alternate delimiter feature in DB2 (like in Oracle)
My question is :
is there a way to define another delimiter when liquibase generate the INSERT INTO DATABASECHANGELOG statements ?
Many thanks in advance