Re: Substitute operators...

On Wed, 12 Aug 1998 12:20:30 +0200, "Florin Micle" <florinmicle@gsc-mbh.de> wrote: >Is there any substitute operator in Informix sql, like '&' in Oracle? >I want to use an index name in a variable. >Can I do something like >drop index index_name, where index_name is a variable containing the index>name? There is no product called Informix sql. With Informix you use sql as a part of different other products. In dbaccess you can only use plain sql. There is no language with variables, control structures and the like in the product itself. You can however create and execute stored procedures that includes a programming language. That's documented in one of the sql manuals available at http://www.informix.com/answers You can however not do what you ask in spl. If you want to do things like you describe you will want to use some programming language. For simple things you can use Perl or Informix 4GL. With 4GL you can of course also create advanced applications, but it's very well suited for creating simple solutions including ad hoc things as well. For Perl you will want DBD::Informix that you can find at http://www.perl.com/CPAN Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)