Solved

Like Oracle does sybase have open cursors limit?

Posted on 2004-08-14
4
366 Views
Last Modified: 2010-05-18
In oracle there is initialization parameter - open cursors limit
What is the setting similar to open cursors limit in sybase?

0
Comment
Question by:RadhikaGoel
4 Comments
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 20 total points
ID: 11800825
Sybase doesn't have a cursor-limit parameter. The practical limit is imposed by other things, such as the amount of RAM, I/O, etc. If you make sure any code that opens a cursor closes it and deallocates it, it's unlikely this will ever be a problem. Note the last two lines in this example:

DECLARE Cur1 CURSOR READ_ONLY FOR SELECT name FROM TableA

DECLARE @name varchar(40)
OPEN Cur1

...<loop>

CLOSE Cur1
DEALLOCATE Cur1

0
 
LVL 3

Expert Comment

by:knel1234
ID: 11932206
Hi,

While I appreciate your question is specifically relating to a cursor, I am curious about your need for a cursor.  Having working with Sybase, MSSQL, and Oracle.  I have found that I rarely use cursors except in Oracle.  What do you need the cursor for??


knel
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Employees depend heavily on their PCs, and new threats like ransomware make it even more critical to protect their important data.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question