Received: from h-62.96.159.93.host.de.colt.net (h-62.96.159.93.host.de.colt.net [62.96.159.93]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA30885 for ; Fri, 7 Jan 2000 15:22:27 -0500 (EST) (envelope-from michael@fam-meskes.de) Received: (from michael@localhost) by tanja.fam-meskes.de (8.9.3/8.9.0/Debian/GNU) id VAA00433; Fri, 7 Jan 2000 21:16:47 +0100 Date: Fri, 7 Jan 2000 21:16:47 +0100 From: Michael Meskes To: Tim Kane Cc: pgsql-interfaces@postgresql.org Subject: Re: [INTERFACES] ECPG and sqlda Message-ID: <20000107211647.A420@fam-meskes.de> Mail-Followup-To: Tim Kane , pgsql-interfaces@postgresql.org References: <3874486C.1B529C0E@hotgames.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <3874486C.1B529C0E@hotgames.com>; from timk@hotgames.com on Thu, Jan 06, 2000 at 06:46:52PM +1100 On Thu, Jan 06, 2000 at 06:46:52PM +1100, Tim Kane wrote: > There doesn't seem to be any support for the SQLDA... Correct. ECPG does not support SQLDA. AFAIK SQLDA is not standard anyway. > Does this mean that I can't do proper dynamic queries? > > eg: select * from :table where :field = :result You can. How about this? exec sql prepare STMT from "select * from ? where ? = ?"; exec sql declare cur cursor for STMT; exec sql open cur using :table, :field, :result; > Somebody please tell me that I'm wrong! > The test files in the source don't seem to utilize this feature at all. test[2|3].pgc do use prepare. > ECPGstatus() seems to have changed to ECPGstatus (int, const char); > What exactly am I supposed to pass to this function? The first argument is the line-number (i.e. __LINE__). The second is the connection name. If you do not have different connections you can use NULL as connection name or just use "CURRENT". Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!