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
Solved

cursor name length limit

Posted on 1999-01-12
1
471 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 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
SQL Syntax 2 456
Problems writing binary files to Sybase from PHP 2 188
Cluster Resource error 3 69
How to get the table names associated with a server 3 73
IT certifications are a concrete representation of continual learning on the part of the candidate.  Continual learning is necessary for the long term success of an IT professional, but are IT certifications the right path for you?
Some of the SEO trends we might expect in 2017.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 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