sybperl-l Archive

From: Gisle Aas <aas at a dot sn dot no>
Subject: Multiple CTlib CS_COMMAND structures
Date: Jan 15 1996 2:22PM

Hi,

We are trying to use client library cursors with CTlib. In order to
use more than one cursor at the same time we have understood that we
need to allocate a CS_COMMAND structure for each cursor. Is this
correct?

The allocation of a CS_CONNECTION and a CS_COMMAND are bundled
together inside the perl ct_connect routine. This means that it is not
possible to have several CS_COMMAND structures share the same
CS_CONNECTION.

We would like to be able have different perl connection objects
(Sybase::CTlib objects) that have different CS_COMMAND but share the
same CS_CONNECTION. Do you have any plans to include support for this?

  $dbh1 = new Sybase::CTlib 'user';
  $dbh2 = $dbh1->ct_cmd_alloc;

  $dbh1->ct_cursor(CS_CURSOR_DECLARE,...);
  $dbh1->ct_send;
  $dbh2->ct_cursor(CS_CURSOR_DECLARE,...);
  $dnh2->ct_send;

-- 
Gisle Aas                                         
Schibsted Nett AS                                 http://www.sn.no/~aas/