DB2 Passing parameter from os shell windows

ronenshi · #1 (**permalink**) 10-04-04, 12:44

Hi,
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?

10x

n_i · #2 (**permalink**) 10-04-04, 13:08

Code:

#!/bin/sh
db2 -t <<!eof
create tablespace $1 managed by system using ('$2');
commit;
!eof

The shell will substitute the values of the command line arguments ($1 and $2) given to the script before passing the strings to db2.

n_i · #3 (**permalink**) 10-04-04, 13:11

Oh, it's on Windows... I guess you'll have to install Cygwin :-)

n_i · #4 (**permalink**) 10-04-04, 13:20

But still...

Code:

@echo off
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

ronenshi · #5 (**permalink**) 10-05-04, 06:49

10x that was very helpfull, if i have multi statements i'll have 2 use the echo command or is their another way?

Internet Services

Web Development

Digital Marketing

Consumer Tech