/ 
DBIO-Sybase-0.900000
/ DBIO::Sybase::Storage::ASE::NoBindVars

NAME

DBIO::Sybase::Storage::ASE::NoBindVars - Support for Sybase ASE via DBD::Sybase without placeholders

VERSION

version 0.900000

DESCRIPTION

Storage driver for Sybase ASE (Adaptive Server Enterprise) accessed via DBD::Sybase when your combination of DBD::Sybase and libraries (most likely FreeTDS) does not support ? style placeholders. DBIO::Sybase::Storage::ASE reblesses the storage into this class automatically on connect when no placeholder support is detected.

This driver uses DBIO::Storage::DBI::NoBindVars as a base, so bind variables are interpolated (properly quoted) into the SQL query itself instead of being passed as placeholders. Because that renders prepared statement caching useless, caching is explicitly disabled.

One advantage of not using placeholders is that SELECT @@IDENTITY works for obtaining the last insert id of an IDENTITY column, instead of having to do SELECT MAX(col) in a transaction as the base ASE driver does. This class sets _identity_method to @@IDENTITY accordingly.

In all other respects it behaves as DBIO::Sybase::Storage::ASE.

METHODS

interpolate_unquoted

Decides whether a given bind value should be interpolated into the SQL unquoted, based on its column data type. Recognizes the Sybase numeric and MONEY types and only skips quoting when the value matches the expected shape for that type. Falls back to "interpolate_unquoted" in DBIO::Storage::DBI::NoBindVars otherwise.

_prep_interpolated_value

Prepares a value for direct interpolation into the SQL query. For MONEY types it prefixes a $ sign when one is not already present.

SEE ALSO

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.