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.