Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Jun 2001 @ 17:21:37 GMT


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


Subj:   Macros Restored using ARCMAIN copy
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, June 26, 2001 11:40 -- >

I archived macros from database CORPVMP1 and was restoring them to CORPVMDR. The macros go against views but the database is not hard- coded in the macros, so I thought when I restored the macros to CORPVMDR, then macros would go against the views I had created in CORPVMDR.

This is how I restored the macros.

COPY DATA TABLES
     (CORPVMDR)
 (   FROM (CORPVMP1) )

A sample macro (database is not hard-coded):
REPLACE MACRO KDCT11P3 AS
  (SELECT 'T074T000' (CHAR(8)),  COUNT(*),
       'RECORD COUNT FOR CDISWKLST' (CHAR(100))
       FROM CDISWKLSTV1
   ;

But when I execute the macro

EXEC CORPVMDR.KDCT11P3

I receive the error

Failure 3523 An owner referenced by user does not have SELECT WITH GRANT OPTION access to CORPVMP1.CDISWKLSTV1.

Therefore the macros on CORPVMDR seem to have a reference to CORPVMP1 embedded in them. The manual says that when you execute a COPY statement, partial names are fully qualified to the default database name. But my default database for the id I used for the COPY is another database.

Someone please enlighten me as to what is going on!



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016