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

Archive/Recovery (ARC Prefix) Messages

brand
Teradata Tools and Utilities
prodname
Teradata Tools and Utilities
vrm_release
15.10
category
Programming Reference
featnum
B035-1096-151K

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.