Archives of the TeradataForum
Message Posted: Wed, 06 Feb 2002 @ 12:22:20 GMT
| Subj: || || Multiload Delete Question |
| From: || || Tony Howe |
I have a customer that got an error during a MULTILOAD DELETE process. Can you use CAST in MULTILOAD?
18:44:21 UTY0817 MultiLoad submitting the following request:
USING EMPID(CHAR(12)), MEMBERNBR(DECIMAL(9,0)), DTROWUPD(CHAR(26)),
CLID(DECIMAL(7,0)), CNIDMAIN(CHAR(6)), PRODUCT(DECIMAL(3,0))
WHERE EMP_ID = :EMPID
AND MEMBER_NBR = :MEMBERNBR
AND CAST((DT_ROW_UPD) AS CHAR(26)) = :DTROWUPD
**** 18:44:21 UTY0805 RDBMS failure, 3537: A MultiLoad DELETE Statement is Invalid.
It uses all the columns in the primary key. The DTROWUPD column is defined on the table as TIMESTAMP(6).