![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage Posted: Mon, 18 Jul 2011 @ 09:40:55 GMT
<-- Anonymously Posted: Monday, July 18, 2011 05:22 --> Hi all, I need urgently to restore some tables with another name in a database on TD in Production. (via ARCMAIN on Mainframe) As it are very big tables, I need to copy 1 only partition. (and the criteria are known) Ib ve read in the manual that when you try to copy table from a partition of a table, the table needs to exist in the target database. That was not yet the case, so I grabbed the DDL from the prd table and used it to create the table in the target database where I want to copy a portion of that big tables data. (only 1 partition) But until now, I was getting only syntax errors. This was the ARC MAIN scripts I was trying to execute: (Ib ve replace the true database and tablename due to company security policy) Target Database = db_new Table is partitioned on field x (partition by x is present in the table definition that has been backupped) COPY DATA TABLE (db_new.table) (PARTITIONS WHERE (! x=106 !), FROM(db_old.table)), RELEASE LOCK, FILE=ARCHIVE; When I try to execute this I always get the following output: (b on mainframe !!!) COPY DATA TABLE (db_new.table) (PARTITIONS WHERE (! x=106 !), *** Failure ARC0202:( was not expected. LOGGED OFF 2 SESSIONS ARCMAIN TERMINATED WITH SEVERITY 12 I tried all sort of things in order to get this fixed. When I leave out the ( just after the WHERE, it says it doesnb t recognize the b !b . Can someone please help me out? Additional info: PROGRAM: ARCMAIN RELEASE: 13.00.00.05 BUILD: 080221eI (Nov 12 2009) CHARACTER SET IN USE: EBCDIC Teradata DBMS info: DBS LANGUAGE SUPPORT MODE Standard DBS RELEASE 13.00.01.03 DBS VERSION 13.00.01.05 Many thanks for your help.
| ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||