Hi, I was wondering how to pass system environment variables into sql script. Basically I have a bat file that setups tablespaces based on project names, and I would like to update my create table sql file to use the tablespaces defined in the bat file. is this possible?

for example lets say I have this

setEnv.bat
set TABLESPACE=ProjectA


createTable.sql
CREATE TABLE TEST
(
textA VARCHAR(3) NOT NULL,
textB VARCHAR(3) NOT NULL
) IN %TABLESPACE%;

Can you pass it as an argument to a shell script. Something like:

$ more create.table
db2 connect to sample
db2 "create table testt (c1 int, c2 int) in $*"


$ ./create.table userspace1

Database Connection Information

Database server = DB2/AIX64 9.7.2
SQL authorization ID = xxxxxx
Local database alias = SAMPLE

DB20000I The SQL command completed successfully.

thanks that worked....

another question how do I import data into a specified table in a table space.

tried this but no luck
db2 "import from TAG.ixf of ixf COMMITCOUNT 100 messages TAG.log insert into TAG IN %TABLESPACE%"

use import/insert into an existing table without specifying the tablespace or import/create into a new table and specify the tablespace