1DBIx::Class::Storage::DUBsIe:r:SCQoLnAtnryiwbhuetreedD(B3PI)exr:l:CDloacsusm:e:nSttaotriaogne::DBI::SQLAnywhere(3)
2
3
4
6 DBIx::Class::Storage::DBI::SQLAnywhere - Driver for SQL Anywhere
7
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
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
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
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.28.1 2018D-B0I1x-:2:9Class::Storage::DBI::SQLAnywhere(3)