Can this be done in Informix ?

James:

Yes, you can do this from Informix. Using either the Informix isql or dbaccess utility you can:

dbaccess -e <dbname> script.sql

You don't provide a username/password since Informix uses the permissions of the user executing the script.

You can create more powerful scripts using unix shell variables with the help of unix &quot;here&quot; documents:

export userid=&quot;fred&quot;

dbaccess -e testdb <<MSG
select * from s_user where userid = &quot;$userid&quot;
MSG

I'd check out the dbaccess/isql documentation. I've just scratched the surface.

Regards,


Ed
Schaefer
olded@ix.netcom.com