Solved

cursor name length limit

Posted on 1999-01-12
1
499 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
david_levine earned 50 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

Three Considerations for Containers

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read our article on Experts Exchange.

Question has a verified solution.

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

Let's take a look back at the commercialization of the internet to understand why keeping it open and neutral is in our best interest as a society.
Let's recap what we learned from yesterday's Skyport Systems webinar.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

628 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