Creating stored procedures for DB2 database using <sqlFile> tag

General Discussion
1

Hi,

I am trying to create multiple stored procedures using tag of liquibase. 


File contents are 


CREATE PROCEDURE RECS_INS (IN R_ID Integer, IN R_Name Varchar(100))

 SPECIFIC RECS_INS

 LANGUAGE SQL

 DYNAMIC RESULT SETS 0

 MODIFIES SQL DATA

 BEGIN 

 INSERT INTO RECS

 VALUES (R_ID, R_Name);

 END go


I am facing issues with both statement terminator semicolon as well as go. 

Please let me know how to handle statement terminators for stored procedures/triggers etc. Since there is need of two terminators.


2

Try to put following comment lines at the beginning of the file:<?xml:namespace prefix=“o”><?xml:namespace><o:p></o:p>

--changeset Author:version (endDelimiter:@ dbms:db2)

Create the procedure with normal termination characters ';' or each SQL statement, At the end of the file enter the termination character (@).

This works for me. I am using liquibase 3.0.2 and UDB/DB2 Unix v9.7