SAS::TRX::MySQL - Format TRX-learned structure and data into MySQL dialect.
use SAS::TRX::MySQL; my $trx = new SAS::TRX::MySQL DATASET=>'trx_insert.sql', STRUCT=>'trx_dd.sql'; $trx->load('source.trx');
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, ...), (VALUE1, VALUE2, ...), ... (VALUE1, VALUE2, ...);
SAS::TRX for the base class
Alexander Kuznetsov, <acca (at) cpan.org>
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.
To install SAS::TRX, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SAS::TRX
CPAN shell
perl -MCPAN -e shell install SAS::TRX
For more information on module installation, please visit the detailed CPAN module installation guide.