Not able to access table after Macro Fails

General

Not able to access table after Macro Fails

Hi All, 

I have created an Temp table with Unique primary index on 2 columns, i have written an macro to insert rows from another table to this Temp table. When i ran that marco it got failed with Unique constraint error. 

After the macro got failed i am not able to access the table,  means not able run select or delete or drop commands on the temp table. 

Teradata is neither throwing errors nor executing these sel or del or drop statments on the temp table. 

Please help..

Thanks 

Harish

4 REPLIES
Junior Supporter

Re: Not able to access table after Macro Fails

Harish:

Please post the DDL, the macro code and the especific error, because my cristal ball is malfunctioning these days...

Funny how posters still think we can figure out the solution for such questions "my code does not work and there is an error... please help"

Cheers.

Carlos.

Teradata Employee

Re: Not able to access table after Macro Fails

Hi,

While executing SELECT/INSERT/DELETE/DROP on the table, can you login PMON and check if your request is blocked by another session?

Regards, Adeel

Enthusiast

Re: Not able to access table after Macro Fails

I dont think it will show up the SQL in PMON as well..

Wonder why u r not able to even drop the table..

Can u plse. put up the SQL's here.

Teradata Employee

Re: Not able to access table after Macro Fails

Curious .... what makes you believe blocking session will not show up in PMON?