RE: Prepare statement in 4gl

> > > >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. ============================================================================