ARC2206 Multi-ARC does not support repeated FROM clause in copy. - Teradata Tools and Utilities

Archive/Recovery (ARC Prefix) Messages

Product
Teradata Tools and Utilities
Release Number
15.xx,16.xx
Language
English (United States)
Last Update
2018-10-23
dita:id
B035-1096-ARC
lifecycle
latest
Product Category
Teradata® Tools and Utilities

ARC2206 Multi-ARC does not support repeated FROM clause in copy.

Explanation:

The job contains repeated FROM clause(s) in the copy statement. Repeated FROM clauses are not supported when running in Multi-ARC mode. A repeated FROM clause is when you use multiple FROM clauses to copy the same source table to multiple target tables in the same copy statement. The following is invalid: copy data tables (target_db1.t1) (FROM(source_db.t1)), (target_db2.t1) (FROM(source_db.t1)), release lock, file=arch1; In Multi-ARC mode, only one FROM clause is allowed per source table. The following is valid: copy data tables (target_db1.t1) (FROM(source_db.t1)), release lock, file=arch1;

For Whom

End User.

Notes

Fatal error.

Remedy

Verify that the job does not contain any repeated FROM clauses in the copy statement and then re-submit the job.