 |
 |
Archives of the TeradataForum
Message Posted: Wed, 27 May 2009 @ 12:50:13 GMT
Subj: | | Re: Perl and Invalid SQL statement for MLOAD |
|
From: | | Geoffrey Rommel |
Unfortunately, I can't find the documentation for DBD::Teradata's MultiLoad interface. However, your $select variable contains both "IGNORE
DUPLICATE INSERT ROWS;" (part of a .DML LABEL statement) and an Insert. The Insert probably needs to be in a separate variable. Also, you might
want to rename that variable $insert, since it is an Insert statement rather than a Select.
If you're just running a MultiLoad script, why not simply call mload from perl?
| |