Re: Prompt message...
Peter Lancashire wrote:
> Florin Micle wrote:
> >
> > Can I prompt a message on the screen from within a sql script for Informix?
> > Is there any statement that can do this?
> If you want to display a message, try this in dbaccess:
>
> SELECT 'My message' AS message,
> CURRENT YEAR TO MINUTE AS printed_on
> FROM informix.systables
> WHERE tabid = 1;
> --
> Peter Lancashire
>
Peter,
I think you misunderstood. I think Florin is referring to a feature of ORACLE's
SQL*Plus (their equivalent to DB-Access) that allows displaying a prompt on
the screen and then waiting to accept user input - which can then be used in
the same SQL script.
Correct me if I'm wrong, but, as far as I know, this feature is not available in
DB-Access.
Cheers,
Avi.
************************************************************************
/\\ \\ /| Avi Abrami, Analyst/Programmer, Telegate Ltd.
/__\\ \\ / | 7 Haplada Street, Or-Yehuda, ISRAEL
/ \\ \\/ | Phone:+972-3-5388717 Fax:+972-3-5335877 eMail:avia@telegate.co.il