tags:

views:

30

answers:

1
Q: 

Higher level libraries for Sybase::DBLib?

Has anyone written something similar to SQL::Abstract for Sybase::DBLib? in particular, I'm interested in being able to insert a hash of values into a table without manually forming the sql query myself.

A big issue in working with sybperl is that SQL::Abstract returns bind values and placeholder SQL, not concrete SQL.

The way to create concrete SQL form bind variables has been discussed - http://www.perlmonks.org/?node_id=839885

I suppose I need to get off my duff and write the code myself if it has not been done.

+2  A: 

Surely if you switched to using DBD::Sybase instead of Sybase::DBLib then all of the modern DBI-based tools (including DBIx::Class) would be available for you to use.

And anyway, wasn't DBLib deprecated in favour of CTLib about ten years ago?

davorg  2010-08-23 16:11:54
switching is not an option at this point. not for me here or other places with large amounts of legacy code riding on sybperl.I scanned the CPAN docs and didnt see any mention of deprecation.
metaperl  2010-08-23 16:17:45
The depreciation of Dblib is from Sybase
Mark  2010-08-29 09:32:30

related questions

Regex to replace Boolean with bool
How do I lock a file in Perl?
How do you use XML::Parser with Style => 'Objects'
Parsing XML Elements & Attributes with Perl
Regex to match all HTML tags except <p> and </p>
Best way to extract data from a FileMaker Pro database in a script?
What's the fastest way to determine a full URL from a relative URL (given a base URL).
Why can't I connect to my CAS server with Perl's AuthCAS?
Why can't I fetch wikipedia pages with LWP::Simple?
How do I perform a Perl substitution on a string while keeping the original?
How do I read in the contents of a directory in Perl?
How can Perl's system() print the command that it's running?
How can I test STDIN without blocking in Perl?
How do I tell if a variable has a numeric value in Perl?
Why doesn't my Perl map return anything?
How can I determine the type of a blessed reference in Perl?
Parsing attributes with regex in Perl
How do you retrieve selected text using Regex in C#?
Why does the Perl conditional operator not do what I expect?
Class::DBI-like library for php?
How do you create objects in Perl?
How do I remove duplicate items from an array in Perl?
Is The Perl Journal available online?
Can you force either a scalar or array ref to be an array in Perl?
What's the safest way to iterate through the keys of a Perl hash?