Can this be done in Informix ?
Can this be done in Informix ?
(OP)
In Oracle, we can run an SQL script through the command line. Eg plus80w.exe scott/tiger@HOSTSTR script.sql
This would execute whatever inside script.sql
It comes handy if we need to run the script under a scheduler.
In Informix, do we have anything similar?
Thank you.
This would execute whatever inside script.sql
It comes handy if we need to run the script under a scheduler.
In Informix, do we have anything similar?
Thank you.
RE: Can this be done in Informix ?
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 "here" documents:
export userid="fred"
dbaccess -e testdb <<MSG
select * from s_user where userid = "$userid"
MSG
I'd check out the dbaccess/isql documentation. I've just scratched the surface.
Regards,
Ed
Schaefer
olded@ix.netcom.com