Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!uwm.edu!cs.utexas.edu!tut.cis.ohio-state.edu!pt.cs.cmu.edu!o.gp.cs.cmu.edu!andrew.cmu.edu!bg0l+
From: bg0l+@andrew.cmu.edu (Bruce E. Golightly)
Newsgroups: comp.databases
Subject: Re: Dynamic SQL syntax (Ingres 6.0)
Message-ID: <gb4Qog200WBNA0pmEn@andrew.cmu.edu>
Date: 9 Oct 90 13:14:20 GMT
References: <24771@uflorida.cis.ufl.EDU>
Distribution: usa
Organization: Carnegie Mellon, Pittsburgh, PA
Lines: 14
In-Reply-To: <24771@uflorida.cis.ufl.EDU>

The general syntax is really pretty simple - 

  EXEC SQL PREPARE statement_name FROM string_variable | string_literal;

  EXEC SQL EXECUTE statement_name [USING variable [,variable...]];

  EXEC SQL DESCRIBE statement_name INTO descriptor_name;

A useful variation is:

  EXEC SQL IMMEDIATE string_variable | string_literal;

Please bear in mind that dynamic SQL becomes available in 6.x. Version 5
releases do not support dynamic SQL.