#DateForumTypeThreadPost
320 Feb 2015 @ 11:31 PSTGeneralTopiccreate a view using WITHThe Teradata 14.0 DDL manual shows that you can do the following, using a common table create view rdptest as ( with test1 (clnt_cd,clnt_id) as (select clnt_cd,clnt_id from dbat...
212 Mar 2014 @ 03:38 PDTDatabaseTopicDetermining group by columns from DBQLObjTblI am working on desiging a summary table and need to determine the grouping columns.  I was looking at DBQLObjTbl TypeofUse, but it doesn't show a group by use.  Is there another way ...
115 Nov 2013 @ 01:53 PSTToolsTopicgenerating sequention number during mloadI would like to generate a sequential number during an mload.  I don't want an identity column, but would like each row inserted during the mload to have a sequential number.  Is this...