NAME

SPOPS::DBI::Sybase -- Sybase-specific routines for the SPOPS::DBI

SYNOPSIS

# Using a class-only defintion
package MySPOPS;
@MySPOPS::ISA = qw( SPOPS::DBI::Sybase SPOPS::DBI );

# Using a config-only definition
'myspops' => {
    'isa' => [ qw/ SPOPS::DBI::Sybase SPOPS::DBI / ],
    'syb_identity' => 1, # optional
    ...
},

DESCRIPTION

This just implements some Sybase-specific routines so we can abstract them out.

One of them optionally returns the IDENTITY value returned by the last insert. Of course, this only works if you have an IDENTITY field in your table:

CREATE TABLE my_table (
  id    numeric( 8, 0 ) IDENTITY not null,
  ...
)

NOTE: You also need to let this module know if you are using this IDENTITY option by setting in your class configuration the key 'syb_identity' to a true value.

METHODS

sql_quote

DBD::Sybase depends on the type of a field if you are quoting values to put into a statement, so we override the default 'sql_quote' from SPOPS::SQLInterface to ensure the type of the field is used in the DBI->quote call.

BUGS

TO DO

SEE ALSO

DBD::Sybase, DBI

COPYRIGHT

Copyright (c) 2001 intes.net, inc.. All rights reserved.

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

AUTHORS

Chris Winters <chris@cwinters.com>