Re: Running scripts within SQL

Having to live in an Oracle world, just because something can be done, doesn't mean that its a good idea to do it. (Oracle temp tables anyone?) As pointed out already, you asked about running a command from SQL. I believe you're actually talking about PL/SQL and exec'ing a shell script from a stored procedure. Already pointed out, use the system command. If you wanted to call a script from an adhoc sql, that would not be a good idea. (Try and be paranoid and think about the potential dangers.) HTH >howie.lfc@googlemail.com wrote: > > Hello all, > > > > Quick question for you here, > > > > If I am running a piece of SQL, is it possible to run a script from > > within the SQL.....in oracle I know you would use the "@" so what > > would you use in Informix? > > > > Thanks in advance. > > > > Cheers, > > > > Howard > >have a look at SQSL (see my sig) it will do that and much more >-- >Ciao, >Marco >______________________________________________________________________________ >Marco Greco /UK /IBM Standard disclaimers >apply! > >Structured Query Scripting Language >http://www.4glworks.com/sqsl.htm >4glworks >http://www.4glworks.com >Informix on Linux >http://www.4glworks.com/ifmxlinux.htm >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Capture the missing critters!'' Play Search Queries and earn great prizes. http://club.live.com/search_queries.aspx?icid=sq_hotmailtextlink1_oct