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

NAME

DBIO::Sybase::Storage::ASE - Sybase ASE SQL Server support for DBIO

VERSION

version 0.900000

SYNOPSIS

# Recommended connect_info settings for Sybase ASE:
on_connect_call => [['datetime_setup'], ['blob_setup', log_on_update => 0]]

DESCRIPTION

Storage driver for Sybase ASE (Adaptive Server Enterprise) databases via DBD::Sybase.

If your Sybase version does not support placeholders, the storage is reblessed to DBIO::Sybase::Storage::ASE::NoBindVars automatically. FreeTDS connections are supported but TEXT/IMAGE columns will not work; use the native Sybase OpenClient libraries for full functionality.

Autoincrement retrieval is done via SELECT MAX(col) inside a locked transaction, as Sybase ASE provides no single-statement equivalent of SCOPE_IDENTITY(). TEXT/IMAGE (blob) columns require a separate write operation on a dedicated connection and are handled transparently.

Bulk inserts use the DBD::Sybase bulk API when available.

METHODS

connect_call_blob_setup

Used as:

on_connect_call => [ [ 'blob_setup', log_on_update => 0 ] ]

Does $dbh->{syb_binary_images} = 1; to return IMAGE data as raw binary instead of as a hex string.

Recommended.

Also sets the log_on_update value for blob write operations. The default is 1, but 0 is better if your database is configured for it.

See "Handling IMAGE/TEXT data with syb_ct_get_data()/syb_ct_send_data()" in DBD::Sybase.

connect_call_datetime_setup

Used as:

on_connect_call => 'datetime_setup'

In connect_info to set:

$dbh->syb_date_fmt('ISO_strict'); # output fmt: 2004-08-21T14:36:48.080Z
$dbh->do('set dateformat mdy');   # input fmt:  08/13/1979 18:08:55.080

This works for both DATETIME and SMALLDATETIME columns, note that SMALLDATETIME columns only have minute precision.

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.