1DBIx::Class::Storage::DUBsIe:r:SCQoLnAtnryiwbhuetreedD(B3PI)exr:l:CDloacsusm:e:nSttaotriaogne::DBI::SQLAnywhere(3)
2
3
4

NAME

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

DESCRIPTION

9       This class implements autoincrements for SQL Anywhere and provides
10       DBIx::Class::InflateColumn::DateTime support and support for the
11       "uniqueidentifier" type (via
12       DBIx::Class::Storage::DBI::SQLAnywhere::Cursor.)
13
14       You need the "DBD::SQLAnywhere" driver that comes with the SQL Anywhere
15       distribution, NOT the one on CPAN. It is usually under a path such as:
16
17         /opt/sqlanywhere11/sdk/perl
18
19       Recommended connect_info settings:
20
21         on_connect_call => 'datetime_setup'
22

METHODS

24   connect_call_datetime_setup
25       Used as:
26
27           on_connect_call => 'datetime_setup'
28
29       In connect_info to set the date and timestamp formats (as temporary
30       options for the session) for use with
31       DBIx::Class::InflateColumn::DateTime.
32
33       The "TIMESTAMP" data type supports up to 6 digits after the decimal
34       point for second precision. The full precision is used.
35
36       The "DATE" data type supposedly stores hours and minutes too, according
37       to the documentation, but I could not get that to work. It seems to
38       only store the date.
39
40       You will need the DateTime::Format::Strptime module for inflation to
41       work.
42

MAXIMUM CURSORS

44       A DBIx::Class application can use a lot of cursors, due to the usage of
45       prepare_cached.
46
47       The default cursor maximum is 50, which can be a bit too low. This
48       limit can be turned off (or increased) by the DBA by executing:
49
50         set option max_statement_count = 0
51         set option max_cursor_count    = 0
52
53       Highly recommended.
54

FURTHER QUESTIONS?

56       Check the list of additional DBIC resources.
57
59       This module is free software copyright by the DBIx::Class (DBIC)
60       authors. You can redistribute it and/or modify it under the same terms
61       as the DBIx::Class library.
62
63
64
65perl v5.32.1                      2021D-B0I1x-:2:7Class::Storage::DBI::SQLAnywhere(3)
Impressum