Chris Winters > SPOPS > SPOPS::Import::DBI::TableTransform::Sybase

Download:
SPOPS-0.87.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Module Version: 3.03   Source  

NAME ^

SPOPS::Import::DBI::TableTransform::Sybase - Table transformations for Sybase/MSSQL

SYNOPSIS ^

 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>

DESCRIPTION ^

Sybase-specific (and Microsoft SQL Server) type conversions for the auto-increment and other field types.

METHODS ^

increment

Returns 'NUMERIC(10,0) NOT NULL IDENTITY NOT NULL'

increment_type

Returns 'NUMERIC(10,0)'

datetime

Returns 'DATETIME'

BUGS ^

None known.

TO DO ^

Nothing known.

SEE ALSO ^

SPOPS::Import::DBI::TableTransform

COPYRIGHT ^

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.

AUTHORS ^

Chris Winters <chris@cwinters.com>

syntax highlighting: