Received: from m8.jersey.juno.com (m8.jersey.juno.com [209.67.34.63]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA88442 for ; Sun, 21 Nov 1999 00:16:41 -0500 (EST) (envelope-from coyotitos_house@juno.com) From: coyotitos_house@juno.com Received: (from coyotitos_house@juno.com) by m8.jersey.juno.com (queuemail) id ERW3UB3C; Sun, 21 Nov 1999 00:16:15 EST To: pgsql-interfaces@postgresql.org Date: Sun, 21 Nov 1999 00:25:11 -0500 Subject: ECPG FETCH [number|ALL] IN cursor_name... with host variable Message-ID: <19991121.002513.-4143103.0.Coyotitos_house@juno.com> X-Mailer: Juno 3.0.13 MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Juno-Line-Breaks: 1-2,4-11,14-15,17-18 X-Juno-Att: 0 X-Juno-RefParts: 0 The ECPG FETCH statement is very different from Pro*C & ESQL/C. It's hard to know how to make normal features work. I'm trying to tell FETCH to load host arrays with a run-time determined number of rows: int count = 10; int age[10]; char name[10][30]; EXEC SQL FETCH :count IN the_cursor INTO :age, :name; FETCH statements WILL allow a constant number in place of ":count". So, replacing ":count" with "10" fetches the first ten rows from the cursor. The keyword "ALL" also works. So, the backend functionality is there. I'm using the RPM files for Postgres 6.5.3 and ECPG 2.6.0. I don't think I have the source code. Can anyone tell me whether I can just modify the parser to make this feature possible? I understand yacc, and this can't be hard.