Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Hrvoje Niksic <hniksic at iskon dot hr>
Subject: Re: Unable to use ? placeholders in DBD::Sybase when connecting to MS SQL
Date: Nov 16 1999 4:56PM

Michael Peppler  writes:

> Placeholders are supported at the protocol level. Sybase started
> supporting placeholders (aka dynamic SQL in Sybase-talk) with TDS
> 5.0. The common protocol understood by Sybase and MS-SQL is 4.2, so
> you're out of luck.

OK.  Additionally, I noticed that you documented the ? placeholders
not to work with MS SQL in your man page.

(For some reason I thought DBI emulates the placeholders if they are
not available, but a better look at the spec shows that this is not

> If I may make a suggestion: use stored procedures instead of using
> SQL straight in the perl scripts. The stored procs can be easily
> tuned, and give you an additional level of abstraction between the
> script and the database, and are pre-compiled (so a little bit
> faster)

I've never used stored procedures before, and I'm not sure how they're
supported by DBI.  But I'll look at them.

Once again, thanks for your help.