Use of Cursor Variables

From: <pkuditip_at_itds.com>
Date: Wed, 26 Aug 1998 20:16:39 GMT
Message-ID: <6s1qf7$2a0$1@nnrp1.dejanews.com>

EXEC SQL PREPARE s1 FROM :sqlstmt;
EXEC SQL DECLARE c1 CURSOR FOR s1;

EXEC SQL OPEN c1;
EXEC SQL FETCH c1 USING DESCRIPTOR......;

Question: Can I use cursor variables in the above statements instead of static names c1 and s1? Reading the documentation I gather that you cannot use cursor variables - BUT is there a work around??

Padma
e-mail: pkuditip_at_itds.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 15:16:39 CDT