#DateForumTypeThreadPost
621 Jun 2016 @ 04:43 PDTDatabaseReplyError handling from DBC.SysExecSQL in my own procedureHi Dieter. I can't drop the database first. I tried that but the procedure is used by many users and sometimes the user don't have access to drop the database. That's why the better so...
517 Jun 2016 @ 01:52 PDTDatabaseReplyError handling from DBC.SysExecSQL in my own procedureI've also tried using  DECLARE EXIT HANDLER FOR SQLSTATE 'T5612' or DECLARE EXIT HANDLER FOR SQLEXCEPTION But it doesn't work.
417 Jun 2016 @ 01:46 PDTDatabaseTopicError handling from DBC.SysExecSQL in my own procedureHi! I've got issue with error handling in my procedure Here's some of my code: DECLARE EXIT HANDLER FOR SQLSTATE '52004' BEGIN drop database TDADMIN_MV_SPC END; SET L_SQL_...
314 Oct 2015 @ 02:44 PDTDatabaseReply"The string contains an untranslatable character" in table nameThanks, Dave I didn't try your idea, because I guessed the character and dropped the table. I'm sure I'll use it in the future.
206 Oct 2015 @ 01:58 PDTDatabaseTopic"The string contains an untranslatable character" in table nameHi. When I tried to drop the table I got the error "The string contains an untranslatable character" The table name looks like "sth_wro->s" in Teradata Administator. I ...
114 Aug 2015 @ 01:34 PDTDatabaseTopicHow can I check if user is locked using query?Hi.   How can I check if user is locked using query? I tried that query: SELECT * FROM DBC.USERS WHERE lockedCount>1;   Is this ok? I do not have access to other users so I ...