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

FreeBSD Manual Pages

  
 
  

home | help
SQLEngine::Driver::SybUser3Contributed Perl DocumeSQLEngine::Driver::Sybase(3)

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.

       The SQLEngine framework doesn't yet have	a strategy or interface	for
       dealing with one	of  the	limitations of DBD::Sybase: each connection
       can only	have one statement handle active. If AutoCommit	is on, then it
       silently	opens up another database handle for each additional statement
       handle. However,	transactions can't span	connections, so	if AutoCommit
       is off, it dies with this message: "DBD::Sybase:	Can't have multiple
       statement handles on a single database handle when AutoCommit is	OFF".

   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.

POD ERRORS
       Hey! The	above document had some	coding errors, which are explained
       below:

       Around line 50:
	   L<> starts or ends with whitespace

perl v5.32.1			  2004-11-18	  SQLEngine::Driver::Sybase(3)

NAME | SYNOPSIS | DESCRIPTION | FETCHING DATA (SQL DQL) | EDITING DATA (SQL DML) | DEFINING STRUCTURES (SQL DDL) | SEE ALSO | POD ERRORS

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

home | help