Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
SPOPS::DBI::Sybase(3) User Contributed Perl DocumentationSPOPS::DBI::Sybase(3)

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

SYNOPSIS
	# In your configuration:

	'myspops' => {
	    'isa' => [ qw/ SPOPS::DBI::Sybase SPOPS::DBI / ],

	    # If you have an IDENTITY field, set increment_field to true...
	    'increment_field' => 1,
	    # ...and the IDENTITY field	in 'no_insert' and 'no_update'
	    'no_insert'	      => [ 'id'	],
	    'no_update'	      => [ 'id'	],
	    ...
	},

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
       'increment_field' 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
       Working with FreeTDS

       SPOPS works with	FreeTDS/MS SQL Server (presumably with FreeTDS/Sybase
       as well,	but it has not been tested). However, there is one hitch: the
       combination of DBD::Sybase and FreeTDS does not seem to work properly
       with the	standard DBI field type	discovery. As a	result,	you need to
       specify your datatypes in your SPOPS configuration using	the
       "dbi_type_info" key:

	my %config = (
	      doodad =>	{
		 class		=> 'My::Doodad',
		 isa		=> [ 'SPOPS::DBI::Sybase', 'SPOPS::DBI'	],
		 ...,
		 dbi_type_info	=> { doodad_id => 'int',
				     name      => 'char',
				     action    => 'char' },
	      },
	);

       See the discussion of "fake types" in SPOPS::DBI::TypeInfo for more
       information.

TO DO
       Nothing known.

SEE ALSO
       SPOPS::Key::DBI::Identity

       DBD::Sybase

       DBI

       FreeTDS:	http://www.freetds.org/

COPYRIGHT
       Copyright (c) 2001-2004 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>

       See the SPOPS module for	the full author	list.

perl v5.32.1			  2004-06-02		 SPOPS::DBI::Sybase(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | BUGS | TO DO | SEE ALSO | COPYRIGHT | AUTHORS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=SPOPS::DBI::Sybase&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help