-1

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.

Ether
  • 53,118
  • 13
  • 86
  • 159
Terrence Brannon
  • 4,760
  • 7
  • 42
  • 61

1 Answers1

2

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?

Dave Cross
  • 68,119
  • 3
  • 51
  • 97
  • 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. – Terrence Brannon Aug 23 '10 at 16:17
  • 2
    The depreciation of Dblib is from Sybase – mmmmmm Aug 29 '10 at 09:32