#DateForumTypeThreadPost
813 Jan 2015 @ 07:47 PSTDatabaseTopicHelp coding on count historical event within a fix time period, greatly thanks! Hi all, I have a teradata sql coding question need your help. Any idea is welcome. My data looks like below, sort by user_id and eventtime. user_id  &nb...
709 May 2014 @ 08:28 PDTTeradata ApplicationsReplyprotect table from being deletedthanks Dieter. Could you explain more how to grand only the CREATE TABLE right? Is this something datalab admin people need do for us?
608 May 2014 @ 10:21 PDTTeradata ApplicationsTopicprotect table from being deletedHi all, we are using data lab to store some tables. so accedentally people can drop other people's table. Is there any solution that prevent that from happening? Can i create a table that only...
523 Sep 2013 @ 11:30 PDTGeneralTopicHow to reference loop index i in SP?Hi please help on below question: Table2 has structureas v_1, v_2, v_3 each time I only want to select one variable so want to reference loop index i in a stored procedure. Is this possible in T...
421 Sep 2013 @ 10:57 PDTGeneralReplyhow to select multiple variables with same prefixanyone can help on this post please?
320 Sep 2013 @ 01:18 PDTGeneralTopichow to select multiple variables with same prefixAnyone happened to know how to write in SQLA to select v_1, v_2, v_3, ...., v_100 from... in a shortcut way? Will select v_1 - v_100 from ... work? thanks!
220 Sep 2013 @ 11:58 PDTGeneralReplyCREATE MULTISET VOLATILE TABLE 0 row processed with ON COMMIT PRESERVE ROWSYes, i'm using SQLA.  Just checked, and yes, 0 row is returned in SQLA but tmp is existing with many rows.  This forum is very helpfu! thanks!
119 Sep 2013 @ 10:00 PDTGeneralTopicCREATE MULTISET VOLATILE TABLE 0 row processed with ON COMMIT PRESERVE ROWSso here is a newbie question: I'm trying to create volatile table from an existing table, I checked some info in the forum, so yes, I added ON COMMIT PRESERVE ROWS, but still I got 0 row proces...