So are you reading the records one at a time through DBI and looking for
duplicates? There is probably a better way.
I work with Teradata, so I'll use Teradata syntax, but the syntax for other
databases will be similar.
To find the duplicates in your table, you can select all columns from the
I don't work with Oracle, but here's a guess. Maybe the database was
unresponsive before your script started running, not as a result of it. If
so, maybe your script tried to prepare the statement, failed, and retried
12000 times. Eventually the DBA noticed the problem and restarted the
database,
The general rule for using parameter markers ('?'s) is that a parameter
marker can appear wherever a literal can appear. (As far as I know, this is
true in any ANSI-compliant database; it goes back to the early years of DB2
and SQL/DS.) The substituted parameters are equivalent to literals. Hence,
As you probably know, DBD::Teradata is not actively supported by the author
and probably hasn't been tested with TTU 15.0. You may wish to try using
Teradata::SQL instead.
When you say Teradata Client 15.00, are you referring to the client
software (TTU) on your Red Hat machine? What version is
