var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to pass variables into .sql file
I'm trying to write a batch file executing some sql statements (drop database, create database ...) in DB2 and the database name is a parameter.
1. I have 2 files: run.bat and script.sql
db2cmd db2 -f script.sql
drop database mydb
create database mydb
connect to mydb user myuser using mypwd
How can I pass variable (mydb...) into script.sql from run.bat?
2. I include the sql statements within run.bat like below
db2cmd -c -w -i db2 drop database mydb db2 create database mydb ...
But it seems not able to execute more than 1 sql statement. How can I run many sql statements?
I'm using DB2 8.1
Thanks for your reading
check this out: http://www.dbforums.com/showthread.php?t=1615385
there is explanation how to have only one DB2 file on Windows.
Hope this helps,
Thanks so much for the link, it really helps me