Alexander Kuznetsov > SAS-TRX-0.06 > SAS::TRX::SQLite

Download:
SAS-TRX-0.06.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source   Latest Release: SAS-TRX-0.07

NAME ^

SAS::TRX::SQLite - Format TRX-learned structure and data into SQLITE dialect.

SYNOPSIS ^

  use SAS::TRX::SQLite;

  my $trx = new SAS::TRX::SQLite DATASET=>'trx_insert.sql', STRUCT=>'trx_dd.sql';
  $trx->load('source.trx');

DESCRIPTION ^

Parses 'source.trx' and splits onto DATASET and STRUCT files. Make sure you have write access permission to the destination files. INSERT is in packed format like

    INSERT INTO DATA_TABLE (COLUMN1, COLUMN2, ...) VALUES(VALUE1, VALUE2, ...);
    INSERT INTO DATA_TABLE (COLUMN1, COLUMN2, ...) VALUES(VALUE1, VALUE2, ...);
    ...
    INSERT INTO DATA_TABLE (COLUMN1, COLUMN2, ...) VALUES(VALUE1, VALUE2, ...);

SEE ALSO ^

SAS::TRX for the base class

AUTHOR ^

Alexander Kuznetsov, <acca (at) cpan.org>

COPYRIGHT AND LICENSE ^

Copyright (C) 2009 by Alexander Kuznetsov

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.10.0 or, at your option, any later version of Perl 5 you may have available.

syntax highlighting: