#DateForumTypeThreadPost
416 Mar 2010 @ 05:55 PDTDatabaseReplyDynamic CursorPlease find the Sample code: which uses the Query from the IN Parameter: REPLACE PROCEDURE spSample2(IN S2 VARCHAR(1000),OUT Pcount DECIMAL(18,0)) --READS SQL DATA DYNAMIC RESULT SETS 1 BEG...
316 Mar 2010 @ 05:39 PDTAnalyticsTopichow to fetch rows from a teradata cursor when i am not sure about no of columnsNormally we do this : DECLARE EmpCur CURSOR FOR SELECT employee_number , department_number FROM employee WHERE employee_number < 1005 ORDER BY 1 ; OPEN EmpCur; SET newcount = ACTIVITY_CO...
215 Mar 2010 @ 06:12 PDTTeradata ApplicationsTopicDynamic Cursors i have couple of questions: how to pass queries in the procedure ( i would be passing different queries at different times) execute them as cursors how to find out the no of coulmns in the cur...
115 Mar 2010 @ 06:00 PDTAnalyticsReplyDynamic Cursor Forwhat if i am passing different queries at different times and i am not sure about the column no's, how can i know the column no's while fetching the records from the dynamic cursor