Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

cursor name length limit

Posted on 1999-01-12
1
Medium Priority
?
512 Views
Last Modified: 2012-06-27
Using sqlanywhere 5.05.
What is a  limit in characters  for a cursor name ?
Found painfully that 30 char caused the problem
of client being locked when both odbc and embedded
apps tried to access db. Truncated cursor name to 25
chars but not sure what is a limit. Could not find anywhere.
0
Comment
Question by:mosur
1 Comment
 
LVL 9

Accepted Solution

by:
david_levine earned 200 total points
ID: 1098542
Found the issue on the support site and it says the limit is 29 characters. It was supposed to be increased in SQL Anywhere 5, but it wasn't.

Below is a statement from the issue on the site as well as the link to it:

http://info.sybase.com/cgi-bin/folioisa.dll/ptipswdb.nfo/query=+cursor+name+length/doc/{@3465}?

--------------------------------------------------------------

A new feature has been added to the database engine. The text of the description follows:

-----------

Feature:DESCRIBE LONG NAMES FOR ...

Version:5.0.03 and above

Description:

A new form of the Embedded SQL DESCRIBE statement has been created for retrieving column names for a statement or cursor. This can get names of arbitrary length as opposed to the 30 character limit on the existing form of describe. The syntax is:

EXEC SQL DESCRIBE LONG NAMES FOR [CURSOR] <stmt | cursor> INTO <sqlda>;

The sqlda is treated differently with this form of describe. It must be a sqlda set up like a FETCH sqlda is set up. There must be one entry for each column and the entry must be a string type. The DESCRIBE will put information into the strings fields as if you were fetchingfrom a cursor (the names go into memory pointed to by the SQLDATA sqlda members).


At this point, no mention has been made of changing ODBC to use this feature. I am enquiring.

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Loops Section Overview

885 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