>
>
> >uunet!bjudev!dwooster, in your mail you wrote:
> > [ sample code left out... ]
> >>
> >> ***** Here is the error I get when I run this *****
> >>
> >> Program stopped at "listdb.4gl", line number 17.
> >> SQL statement error number -201.
> >> A syntax error has occurred.
> >>
> >> ***** Does anyone know what is wrong ?????
> >>
> >I sure do! The sql statement INFO is just that, an SQL statement. It is NOT
> >a valid 4GL statement, nor is it in the 4GL manuals.
>
> [. . .deleted text. . .]
>
> Therefore, I concluded that I could use INFO in a prepare statement. Does any
> one have a list of which SQL statements can be used in a PREPARE?
>
> Dan Wooster
> uunet!bjudev!dwooster
>
Dan,
The problem is that you cannot use an INFO statement in 4GL; it isn't
recognized by the compiler for that reason. (The statement in I-SQL
simply pumps info to the screen; that's a bit disorganized for a
programming language.)
If you need the features of the INFO statement, simply query the system
catalogs. You'll find their structure documented in Appendix B of your
reference manual.
David Coburn coburn@infmx.com
Systems Engineer ...!uunet!infmx!coburn
Informix Software, Inc.
============================================================================
The stuff contained herein is not necessarily the opinion of my employer.
============================================================================