Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::storage::dbi::sqlanywhere(3) [osx 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.16.2 2012-08-16 DBIx::Class::Storage::DBI::SQLAnywhere(3)

Check Out this Related 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)
Man Page