Archives of the TeradataForum

Message Posted: Mon, 26 Jun 2001 @ 20:09:35 GMT

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

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.

Regards,

Thomas F. Stanek
TFS Consulting

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