Archives of the TeradataForum
Message Posted: Mon, 26 Jun 2001 @ 20:09:35 GMT
I failry confident that the problem you are having is that the user id that was used to execute the macro (EXEC CORPVMDR.KDCT11P3 in your message, has a default database defined as CORPVMP1. Even though you fully qualified the execution, the unqualified views, tables and other references will defer to the default database of the user id. I would guess that if, prior to the macro execution, you executed a .DATABASE CORPVMDR, the macro would reference the views you expect.
However, to Geoffrey's point, you still need to make sure that the CORPVMDR database has correct accessrights granted.
Thomas F. Stanek
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|