Use of Cursor Variables
From: <pkuditip_at_itds.com>
Date: Wed, 26 Aug 1998 20:16:05 GMT
Message-ID: <6s1qe5$29m$1_at_nnrp1.dejanews.com>
EXEC SQL PREPARE s1 FROM :sqlstmt;
EXEC SQL DECLARE c1 CURSOR FOR s1;
Date: Wed, 26 Aug 1998 20:16:05 GMT
Message-ID: <6s1qe5$29m$1_at_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 - 22:16:05 CEST