Archives of the TeradataForum

Message Posted: Mon, 18 Jul 2011 @ 09:40:55 GMT

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

<-- 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
Source Database = db_old

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.

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