Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

cursor name length limit

Posted on 1999-01-12
1
Medium Priority
?
504 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 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Read on to get a few ideas on how to promote your next corporate event.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

721 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