++ed by:
TSIBLEY

1 PAUSE user

Alexander Kuznetsov
and 1 contributors

NAME

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

SYNOPSIS

  use SAS::TRX::MySQL;

  my $trx = new SAS::TRX::MySQL 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, ...),
    (VALUE1, VALUE2, ...),
    ...
    (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.