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

Can you provide an example please? Thanks, Denmark W. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Stephen F. Cawley Sent: Saturday, February 05, 2000 8:23 AM To: Denmark B. Weatherburn Cc: Informix Users Group (E-mail) Subject: 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.