SPOPS::Import::DBI::TableTransform::Sybase - Table transformations for Sybase/MSSQL
my $table = qq/ CREATE TABLE blah ( id %%INCREMENT%% primary key, name varchar(50) ) /; my $transformer = SPOPS::Import::DBI::TableTransform->new( 'sybase' ); $transformer->increment( \$table ); print $table; # Output: # CREATE TABLE blah ( id NUMERIC(10,0) IDENTITY NOT NULL primary key, # name varchar(50) )</pre>
Sybase-specific (and Microsoft SQL Server) type conversions for the auto-increment and other field types.
increment
Returns 'NUMERIC(10,0) NOT NULL IDENTITY NOT NULL'
increment_type
Returns 'NUMERIC(10,0)'
datetime
Returns 'DATETIME'
None known.
Nothing known.
SPOPS::Import::DBI::TableTransform
Copyright (c) 2002-2004 intes.net, inc.. All rights reserved.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Chris Winters <chris@cwinters.com>
To install SPOPS, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SPOPS
CPAN shell
perl -MCPAN -e shell install SPOPS
For more information on module installation, please visit the detailed CPAN module installation guide.