Re: Substitute operators...
Nils Myklebust wrote:
> 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".)
Of course there is a product called Informix SQL. It is a client-only
application the functions pretty much just like dbaccess, but is purchased
standalone without the server product.
--
Matt Reprogle
IS Engineer, Delphi Delco Electronics Systems
phone:(765)451-9651 FAX: (765)451-8230 mcreprog@ictest.delcoelect.com