1 package DBIx::Class::Storage::DBI::ODBC::DB2_400_SQL;
5 use base qw/DBIx::Class::Storage::DBI::ODBC/;
7 sub _dbh_last_insert_id {
8 my ($self, $dbh, $source, $col) = @_;
10 # get the schema/table separator:
11 # '.' when SQL naming is active
12 # '/' when system naming is active
13 my $sep = $dbh->get_info(41);
14 my $sth = $dbh->prepare_cached(
15 "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM${sep}SYSDUMMY1", {}, 3);
18 my @res = $sth->fetchrow_array();
20 return @res ? $res[0] : undef;
27 my ($self, $dbh) = @_;
30 limit_dialect => 'FetchFirst',
31 name_sep => $dbh->get_info(41)
40 DBIx::Class::Storage::DBI::ODBC::DB2_400_SQL - Support specific to DB2/400
45 # In your table classes
46 __PACKAGE__->load_components(qw/PK::Auto Core/);
47 __PACKAGE__->set_primary_key('id');
52 This class implements support specific to DB2/400 over ODBC, including
53 auto-increment primary keys, SQL::Abstract::Limit dialect, and name separator
54 for connections using either SQL naming or System naming.
59 Marc Mims C<< <marc@sssonline.com> >>
61 Based on DBIx::Class::Storage::DBI::DB2 by Jess Robinson.
65 You may distribute this code under the same terms as Perl itself.