NAME

DBIx::SQLEngine::Driver::Sybase - Extends SQLEngine for DBMS Idiosyncrasies

SYNOPSIS

DBI Wrapper: Adds methods to a DBI database handle.

my $sqldb = DBIx::SQLEngine->new( 'dbi:Sybase:server=MyServer' );

Portability Subclasses: Uses driver's idioms or emulation.

$sqldb->do_insert(                          # use identity column
  table => 'students', sequence => 'id',        
  values => { 'name'=>'Dave', 'age'=>'19', 'status'=>'minor' },
);

DESCRIPTION

This package provides a subclass of DBIx::SQLEngine which compensates for Sybase's idiosyncrasies.

Under Development

Note: this driver class has been added recently and not yet tested in real-world conditions.

About Driver Subclasses

You do not need to use this package directly; when you connect to a database, the SQLEngine object is automatically re-blessed in to the appropriate subclass.

For more information about the underlying driver class, see DBD::Sybase.

About DBMS Flavors

This driver uses the DatabaseFlavors trait. For more information, see DBIx::SQLEngine::Driver::Trait::DatabaseFlavors.

It does this in order to support use of DBD::Sybase with Microsoft SQL Server. For more information, see " DBIx::SQLEngine::Driver::Sybase::MySQL".

FETCHING DATA (SQL DQL)

Methods Used By Complex Queries

sql_limit()

Not yet supported.

See http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.12

EDITING DATA (SQL DML)

Insert to Add Data

do_insert_with_sequence()

$sqldb->do_insert_with_sequence( $sequence_name, %sql_clauses ) : $row_count

Implemented using _seq_do_insert_postfetch and seq_fetch_current.

seq_fetch_current()

$sqldb->seq_fetch_current( ) : $current_value

Implemented using Sybase's "select @@IDENTITY".

Note that this doesn't fetch the current sequence value for a given table, since it doesn't respect the table and field arguments, but merely returns the last sequencial value created during this session.

For more information see http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.9

DEFINING STRUCTURES (SQL DDL)

Column Type Methods

dbms_create_column_types()

$sqldb->dbms_create_column_types () : %column_type_codes

Implemented using Sybase's blob and identity types.

dbms_create_column_text_long_type()

$sqldb->dbms_create_column_text_long_type () : $col_type_str

Implemented using Sybase's blob type.

SEE ALSO

See DBIx::SQLEngine for the overall interface and developer documentation.

See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.