#DateForumTypeThreadPost
728 Dec 2009 @ 04:47 PSTDatabaseReplyHow to use decision logic in Macro?Hi,I would like to explore the advanced features in teradata 12.0 especially in stored procedures.Could you please let me know where you got the material for Teradata 12.0 stored procedure?Regards,...
625 Sep 2009 @ 03:17 PDTDatabaseReplySQLSTATE vs. SQLCODE, exception handlingLookup on DBC.ErrorMsgs table to get the description of a error code (SQLCODE) you get.Regards,Dinesh
501 Sep 2009 @ 01:52 PDTDatabaseReplyTeradata stored proceduresKumar,I was able to compile the proc and run it. But i wasnt getting the desired output as i mentioned in this post.As far as i know, to run dynamic SQL, you need to have a user id for which u hav ...
420 Aug 2009 @ 09:56 PDTDatabaseReplyhow to use Primary index efficientlyhi satish,You can add one more columns in your WHERE clause in this fashion.1. SELECT * FROM TABLE1 WHERE (COL1,COL2,COL3..etc) in (select distinct (COLX1, COLX2, COLX3...etc) from table2)or2.SELEC...
320 Aug 2009 @ 09:13 PDTDatabaseReplyTeradata stored proceduresThis is the script that i used./* ***************************************************************** */REPLACE PROCEDURE tempcnt()BEGINDECLARE SQL_STRING VARCHAR(4000); FOR v_cur AS hdcursor CURSOR...
220 Aug 2009 @ 08:35 PDTDatabaseReplyTeradata stored proceduresHi raja,could u please provide me a sample script that uses "EXECUTE" or "EXECUTE IMMEDIATE".?
120 Aug 2009 @ 03:05 PDTDatabaseTopicTeradata stored proceduresHi all,I have a requirement of passing tables names dynamically to a stored procedure. I have my table names, date fields stored in another table say XYZ. table XYZ---------------------------------...