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 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"
While executing SELECT/INSERT/DELETE/DROP on the table, can you login PMON and check if your request is blocked by another session?
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.