All Forums General
Harish4u_me 1 post Joined 07/11
14 Oct 2011
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

 

 

 

 

 

CarlosAL 512 posts Joined 04/08
15 Oct 2011

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.

Adeel Chaudhry 773 posts Joined 04/08
17 Oct 2011

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

-- If you are stuck at something .... consider it an opportunity to think anew.

18 Oct 2011

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 NooB.

Adeel Chaudhry 773 posts Joined 04/08
18 Oct 2011

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

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.