Archives of the TeradataForum

Message Posted: Thu, 28 May 2009 @ 09:19:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thank for the answer.(But it doesn't seem to solve the problem).

This is a problem in the way to obtain an indipendent exe file to use. I have also to do the graphic interface ....

The goal is to use the best performance of "Server Teradata" to get information from a production side and put them on developper side. I can use DBI interface but it's slow.

It was better to use FastExport (the script already work!) and to use MultiLoad to reinsert data.

I don't want use local server function becouse soon it will be inacessible from us (problem of security).

If you find more documentation about multi load interface will be Appreciated.

I'm using the one with Perl driver (REV 12):

cpansearch.perl.org/src/DARNOLD/DBD-Teradata-1.52/doc/index.html

Actually I tried to do a MultiLoad on a table with one field (!) using the (doc example) statement:

     my $total = $ctldbh->tdat_UtilitySetup(
         {
             Utility      => 'MLOAD',
             Sessions     => $sesscount,
             SQL => [

              "MARK DUPLICATE ROWS;MARK MISSING ROWS;
                  INSERT INTO jedi_kbo_db.T_TEST_T VALUES( :col1 );",

             ],
             SourceFields => 'USING (col1 varchar(30))',
           LogTables => {
                 'jedi_kbo_db.T_TEST_T'    => [ qw(T_TEST_T_wt  T_TEST_T_et  T_TEST_T_uv) ],
                 },
             Source       => "VARTEXT '|' ".$filenameF ,
             MP => 1 ,
              });

and the problem seem that doesn't create an automatic table "T_TEST_T_uv" returning the error:

Failure 3807: Object 'T_TEST_T_uv' does not exist. on Statement 1.

I also don't know which fields the tables _wt, _et and _uv contains !

Thanks in advance

Giulio

	<Prev	Next>		<<First	<Prev	Next>	Last>>