Hi I am getting following error in multiload report file.
USING A(DECIMAL(18,0)), B(DECIMAL(18,0)) UPDATE Table_X
SET A = :B
WHERE A = :A;
**** 10:03:57 UTY0805 RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid.
The job has sequential file ( Col A, B). transformer & Teradata multi load stage.
I am using load typr custom & In Script- Custom tab I have following script.
.DML label updates;
UPDATE Table_X
SET A= :B
WHERE A = :A;
.DML label deletes;
DELETE FROM Table_X
WHERE A = :A;
.DML label inserts;
INSERT Table_X (A,
B)
VALUES (:A,
:B);
.import INFILE #$PATH#/data/input.dat
format fastload layout internal
apply updates where 1=1;
Teradata Multi Load uodate fail
Moderators: chulett, rschirm, roy
Well there is no issue in TD when it comes to updating the UPI or PI. it wil do it and just redistribute the table. I think its the problem with the what is being specified in the update script by him which is giving an error. Are you generating the script or trying to use a custom one?
Teradata Certified Master V2R5
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am
Here's the description of error 3538 in the Teradata Messages manual. The problem is that you are trying to update the primary index which is not supported by MultiLoad. For future reference, you can find the Teradata Messages manual for each release here:
http://www.info.teradata.com/DataWareho ... m=Messages
3538 A MultiLoad UPDATE Statement is Invalid.
Explanation: The user has provided an UPDATE
statement in a MultiLoad Complex Import Task that
does not fully specify a primary index value, does not
fully specify the values of all the partitioning columns,
or modifies the primary index or partitioning columns.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.
The WHERE condition, including any taken from a
view definition, must allow for primary index access
(and, if partitioned, partition access) with possible
ANDed residual conditions. The list of updated fields
must not include any column in the primary index or
partitioning expression, and only one table may be referenced.
http://www.info.teradata.com/DataWareho ... m=Messages
3538 A MultiLoad UPDATE Statement is Invalid.
Explanation: The user has provided an UPDATE
statement in a MultiLoad Complex Import Task that
does not fully specify a primary index value, does not
fully specify the values of all the partitioning columns,
or modifies the primary index or partitioning columns.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.
The WHERE condition, including any taken from a
view definition, must allow for primary index access
(and, if partitioned, partition access) with possible
ANDed residual conditions. The list of updated fields
must not include any column in the primary index or
partitioning expression, and only one table may be referenced.