We are currently deploying a new user interface and navigational structure on our Community. These design changes align with our new Teradata Access portal and provide a more cohesive experience for our users.
the purpose of the sql, is first ask if tabla2 exist (in the first run it should not exist, because this will be a backup table that i will create in the last line of the code), then the show table should send some answer like 0 or not 0 values, instead of that the show table says "error 3807 table doesnt exist statement=1 info=0;" and that error just damage the all process because i can't get the condition i want.
i just want to get a value after i validate if the table exist.. but I don't know how to do that.. that's why I use the "".IF ERRORCODE = 0 " and the "".IF ERRORCODE <> 0 " question to get the values.. but it doesnt work just how I want.
please contact me at any time.. i will be connected.