1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
package DBIx::Class::Storage::DBI::DB2;
use strict;
use warnings;
use base qw/DBIx::Class::Storage::DBI/;
# __PACKAGE__->load_components(qw/PK::Auto/);
sub last_insert_id
{
my ($self) = @_;
my $dbh = $self->_dbh;
my $sth = $dbh->prepare_cached("VALUES(IDENTITY_VAL_LOCAL())", {}, 3);
$sth->execute();
my @res = $sth->fetchrow_array();
return @res ? $res[0] : undef;
}
sub datetime_parser_type { "DateTime::Format::DB2"; }
1;
=head1 NAME
DBIx::Class::Storage::DBI::DB2 - Automatic primary key class for DB2
=head1 SYNOPSIS
# In your table classes
__PACKAGE__->load_components(qw/PK::Auto Core/);
__PACKAGE__->set_primary_key('id');
=head1 DESCRIPTION
This class implements autoincrements for DB2.
=head1 AUTHORS
Jess Robinson
=head1 LICENSE
You may distribute this code under the same terms as Perl itself.
=cut
|
