Archives of the TeradataForum

Message Posted: Wed, 20 Mar 2013 @ 12:29:24 GMT

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

Hi there,

Please add ALL key word in your syntax;? it works for me and should work for you as well:

     COPY DATA TABLES (sandbox) ALL,
     RELEASE LOCK,
     FILE = sandall;
     LOGOFF;

Once you backed up data with following command, use for copy :

---for backup

     COPY DATA TABLES (sandbox) ALL,

---for copy of above backup file

     COPY data tables
     (xxxx_DB) (FROM (xxxx_DB)),
     RELEASE LOCK,
     FILE = sandall;
     LOGOFF;

Mushtak Mirajkar.

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