++ed by:
TSIBLEY

1 PAUSE user

Alexander Kuznetsov
and 1 contributors

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.