dbix::class::storage::dbi::sqlanywhere5.18(3) [mojave man page]

DBIx::Class::Storage::DBI::SQLAnywhere(3)		User Contributed Perl Documentation		 DBIx::Class::Storage::DBI::SQLAnywhere(3)

NAME

       DBIx::Class::Storage::DBI::SQLAnywhere - Driver for SQL Anywhere

DESCRIPTION

       This class implements autoincrements for SQL Anywhere and provides DBIx::Class::InflateColumn::DateTime support and support for the
       "uniqueidentifier" type (via DBIx::Class::Storage::DBI::SQLAnywhere::Cursor.)

       You need the "DBD::SQLAnywhere" driver that comes with the SQL Anywhere distribution, NOT the one on CPAN. It is usually under a path such
       as:

	 /opt/sqlanywhere11/sdk/perl

       Recommended connect_info settings:

	 on_connect_call => 'datetime_setup'

METHODS

   connect_call_datetime_setup
       Used as:

	   on_connect_call => 'datetime_setup'

       In connect_info to set the date and timestamp formats (as temporary options for the session) for use with
       DBIx::Class::InflateColumn::DateTime.

       The "TIMESTAMP" data type supports up to 6 digits after the decimal point for second precision. The full precision is used.

       The "DATE" data type supposedly stores hours and minutes too, according to the documentation, but I could not get that to work. It seems to
       only store the date.

       You will need the DateTime::Format::Strptime module for inflation to work.

MAXIMUM CURSORS

       A DBIx::Class application can use a lot of cursors, due to the usage of prepare_cached.

       The default cursor maximum is 50, which can be a bit too low. This limit can be turned off (or increased) by the DBA by executing:

	 set option max_statement_count = 0
	 set option max_cursor_count	= 0

       Highly recommended.

AUTHOR

       See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.18.2							    2013-12-16				 DBIx::Class::Storage::DBI::SQLAnywhere(3)

Check Out this Related Man Page

DBIx::Class::Storage::DBI::Informix(3)			User Contributed Perl Documentation		    DBIx::Class::Storage::DBI::Informix(3)

NAME

       DBIx::Class::Storage::DBI::Informix - Base Storage Class for Informix Support

DESCRIPTION

       This class implements storage-specific support for the Informix RDBMS

METHODS

   connect_call_datetime_setup
       Used as:

	 on_connect_call => 'datetime_setup'

       In connect_info to set the "DATE" and "DATETIME" formats.

       Sets the following environment variables:

	   GL_DATE="%m/%d/%Y"
	   GL_DATETIME="%Y-%m-%d %H:%M:%S%F5"

       The "DBDATE" and "DBCENTURY" environment variables are cleared.

       NOTE: setting the "GL_DATE" environment variable seems to have no effect after the process has started, so the default format is used. The
       "GL_DATETIME" setting does take effect however.

       The "DATETIME" data type supports up to 5 digits after the decimal point for second precision, depending on how you have declared your
       column. The full possible precision is used.

       The column declaration for a "DATETIME" with maximum precision is:

	 column_name DATETIME YEAR TO FRACTION(5)

       The "DATE" data type stores the date portion only, and it MUST be declared with:

	 data_type => 'date'

       in your Result class.

       You will need the DateTime::Format::Strptime module for inflation to work.

AUTHOR

       See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.18.2							    2013-12-16				    DBIx::Class::Storage::DBI::Informix(3)

Linux and UNIX Man Pages

dbix::class::storage::dbi::sqlanywhere5.18(3) [mojave man page]

Check Out this Related Man Page