var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 Passing parameter from os shell windows
I need to create a batch script that create tablespace and schema , the batch file suppose to pass this 2 parms to an sql file that will create the objects.
How it can be done?
The shell will substitute the values of the command line arguments ($1 and $2) given to the script before passing the strings to db2.
db2 -t <<!eof
create tablespace $1 managed by system using ('$2');
Oh, it's on Windows... I guess you'll have to install Cygwin :-)
echo create tablespace %1 managed by system using ('%2'); > tmp.sql
echo commit; >> tmp.sql
db2 -tf tmp.sql
if errorlevel 0 del tmp.sql
10x that was very helpfull, if i have multi statements i'll have 2 use the echo command or is their another way?