A new topic, '<sql> running in default schema, not specified schema (at least
in DB2)', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=147.new#new
The text of the topic is shown below:
Environment: liquibase-1.9.4called via ant task, linux, DB2 Express-C 9.5
We're trying to call a stored procedure with the <sql> 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 <modifySql> -- but this does not appear to modify sql defined a
<sql> 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 <sql> tag.
The only solution I can think of is to call out to sql files (and use the
<sqlFile> tag). We could use variable substitution with ant to get the schema
names correct.
I was hoping for a more elegant solution.
Any ideas?
Regards,
Jonathan
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
