Solved

Like Oracle does sybase have open cursors limit?

Posted on 2004-08-14
4
344 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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now