#DateForumTypeThreadPost
520 Aug 2009 @ 11:40 PDTDatabaseReplyHow to read a variable in bteqwill this do?.SET varName TO %Val1%;In bteq use &varname to refer val1.Where tbl1.col1=&varname;
417 Aug 2009 @ 07:47 PDTToolsReplyMload issuevalues(:ENT_USER_ID , :EMPL_LST_NM, :EMPL_FRST_NM, :EMAIL_ADR, :LEVEL_DESC, 'Non-Associate', :MGR_LST_NM, :MGR_FRST_NM, );
314 Aug 2009 @ 03:53 PDTUDAReplyOne to ManyWill this do? substring(c.Lists_Name,1,1) = m.Lst_Lists_Name Union Substring(c.Lists_Name,2,2) = m.Lst_Lists_NameSELECT c.policy_code, c.policy_rsk_no, c.product_class, c.effective_dt, c.trans_seq...
211 Aug 2009 @ 02:45 PDTUDAReplyShow Table View Key(s)In teradata views just store sql and runs it against the base whenever you access that view. I feel like you need materialized views, if it is correct then create join/aggregrate index which will ...
111 Aug 2009 @ 02:34 PDTUDAReplySyntax neededThis might help youhttp://www.xaprb.com/blog/2005/09/25/insert-if-not-exists-queries-in-mysql/