Re: Insert triggers, is this a bug, is there a work around?

Jonathan Leffler wrote: > > Richard Spitz wrote: > > Leffler, Jonathan wrote: > > > SELECT * FROM SomeTable;> > > !sleep 20 > > > UPDATE SomeTable > > > SET Information = 'Obsoleted by the passage of time' > > > WHERE RefNum = 123456; > > > SELECT * FROM SomeTable;> > > > Is the "!sleep 20" just "Pseudo code", or is it a valid shell > > escape syntax? > > On my system (dbaccess 5.10 on a SNI RM400 under ReliantUnix 5.43) > > it gives me a syntax error. > > Either or both. > > If you run it in the query language option (withthe menus and editor, > etc), it is a syntax error. > > If you run it from the command line "dbaccess database script", > then it is a valid (but undocumented) shell escape -- at least, > when I last tested it in ISQL it worked, and I think it is in > DB-Access too... Yes, it certainly works in version 5.10 & 7.23. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+