Archives of the TeradataForum
Message Posted: Mon, 18 Jul 2011 @ 09:40:55 GMT
<-- Anonymously Posted: Monday, July 18, 2011 05:22 -->
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: 23 Jun 2019|