Re: Can I use variable substitution in create table sql ?

No, but you can write a script (which likes variables) to generate the SQL and then pipe it through dbaccess. SC > Hi Listers, > > I need to create a table everytime in a specific dbspace. Our Application > uses a batch process that drops and recreates the table every night using > predefined create table sql's. Instead of hardcoding the in 'dbspacename' in > each SQL file, can I use a variable such as in $DBSPACENAME in the SQL which > is defined in the users' .profile. > Actually, I tried this already but it did not work. Is there any way to > accomplish this? > > Thanks in advance, > > Denmark W.