Environment: liquibase-1.9.4called via ant task, linux, DB2 Express-C 9.5
We’re trying to call a stored procedure with the tag.
This works, except when we need to call the SP in a schema other than the default schema for the DB user.
Changing: “CALL MY_PROC;”
to: “CALL MYSCHEMA.MY_PROC;”
works, except that the schema name varies.
We’ve tried – but this does not appear to modify sql defined a tag – probably b/c it is not “generated” sql.
We’ve also tried “Changelog parameter” – but these, too, do not appear to get substituted in a tag.
The only solution I can think of is to call out to sql files (and use the tag). We could use variable substitution with ant to get the schema names correct.
I was hoping for a more elegant solution.