Re: Simple sql ?

--- James Howerton <jth@moray.hs.uab.edu> > wrote: >All, > >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? > In 4gl code you can use: display "Text",variable,"more text" If you want to dump directly into a file you can use: run "echo 'Text line here'>>filename" If you want to include variable values you will have to define a runline character variable and build your command: let runline = "echo 'Text ",variable," more text'" run runline There is also a prompt command (since you mentioned it) if that's what you're really after. You can get more info on that (and better descriptions than mine) at http://www.informix.com/documentation/ == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net