Hi Tom, DBI itself has no control over this. It's DBD::Sybase, and more precisely what DBD::Sybase tells OpenClient to do.
You need to rebuild your DBD::Sybase binary with the 15.x OpenClient installation, and you need to use a version of DBD::Sybase that is recent enough to understand CS_VERSION_150 or CS_VERSION_CURRENT (1.09 or later, I believe). Michael On Aug 20, 2011, at 12:43 PM, Tim Bunce wrote: > ----- Forwarded message from "Mackin, Thomas E." <thomas.mac...@lfg.com> ----- > > Date: Fri, 19 Aug 2011 14:33:11 -0400 > From: "Mackin, Thomas E." <thomas.mac...@lfg.com> > To: tim.bu...@pobox.com > Subject: Sybase 15.0 > > > Tim, > > We migrated our Sybase database (AIX) to 15.0.2 about 2 years ago. We also > use Open Client 15.0 and > everything works, mostly. We have been butting up against the 30 character > limit for object names when > running scripts through Perl (5.6) ever since. Most of the time we simply > rename things to be 30 > characters or less. This is now becoming somewhat of a pain. Is it > possible to recompile/tweak/modify > something in the Perl DBI code to get around this? Keep in mind that I am > NOT a Perl developer (he > left!) but am tasked with trying to get this fixed. We found some C code > that uses Sybase.h, and we > assume that somewhere in all that is the datatype restriction that limits > the object names to 30 > characters. Can a newer header file be used to recompile the dll or am I > barking up the wrong tree? > > Any help or direction you could give us would be great. Surely someone has > Sybase 15.0 and Perl 5.6 > working with long object names... > > Thanks, > Tom Mackin > ------------------------------------------- > Lincoln Financial Group > > Investments, IA, and Risk Management IT > > Application Systems Analysis & Programming Lead > [1]thomas.mac...@lfg.com > 260.455.1466 > Mailstop: 2C12 > > Notice of Confidentiality: **This E-mail and any of its attachments may > contain > Lincoln National Corporation proprietary information, which is privileged, > confidential, > or subject to copyright belonging to the Lincoln National Corporation > family of > companies. This E-mail is intended solely for the use of the individual or > entity to > which it is addressed. If you are not the intended recipient of this > E-mail, you are > hereby notified that any dissemination, distribution, copying, or action > taken in > relation to the contents of and attachments to this E-mail is strictly > prohibited > and may be unlawful. If you have received this E-mail in error, please > notify the > sender immediately and permanently delete the original and any copy of this > E-mail > and any printout. Thank You.** > > References > > Visible links > 1. mailto:thomas.mac...@lfg.com > > ----- End forwarded message ----- > -- Michael Peppler Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html "A successful [software] tool is one that was used to do something undreamed of by its author." -- S. C. Johnson
