Unanswered: pass system environment variables into sql script
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
CREATE TABLE TEST
textA VARCHAR(3) NOT NULL,
textB VARCHAR(3) NOT NULL
) IN %TABLESPACE%;