RE: Simple sql ?

On Tue, 19 Sep 2000, Martin, Wayne E. wrote: >In ISQL - Query or DBACCESS - Query, there is none. Well, there's no analogue of prompt, that's true. However, one of the lesser know features of ISQL and DB-Access is that if the command is being run using: dbaccess dbase - < file isql dbase file then you can use '!' to indicate that the rest of the line is a shell command, and you can therefore do '!echo Hi' to echo Hi. This does not work if you are using the Query-Language menu; the '!' stuff generates a syntax error. >-----Original Message----- >From: James Howerton [mailto:jth@moray.hs.uab.edu] >Sent: Tuesday, September 19, 2000 11:56 AM > >I'm an Oracle DBA trying to convert an Informix Database to Oracle. >Sorry, corporate decision. > >I need to get some debug statements to display at various points. What >is the Informix equivalent for the Oracle prompt command or the UNIX >echo command? I'm mildly surprised you need these in Informix; I presume you're trying to modify the Informix code to see how it works before translating to Orable where you have the features. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"