Archives of the TeradataForum

Message Posted: Fri, 04 Apr 2003 @ 08:21:49 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, April 03, 2003 19:32 -->

If you restore everything all you have to do is run a revalidate step. Tables that have referential integrity constraints cannot be updated until the references are revalidated. This is also true if you restore either the referencing or the referenced tahle.

Example ARCMAIN Script to perform a revalidate of DBNAME.

LOGON tpdid/user,passwd;
REVALIDATE REFERENCES FOR
(Dbname),
RELEASE LOCK;
LOGOFF;

	<Prev	Next>		<<First	<Prev	Next>	Last>>