#DateForumTypeThreadPost
22507 Sep 2016 @ 05:31 PDTToolsReplyArcmainYou can find all TTU downloads at T@YS   Rglass
22401 Sep 2016 @ 11:54 PDTGeneralReplyConverting varchar into timestamp sel cast(substr('2016-01-07T11:52:49.113Z',1,10)||' '||substr('2016-01-07T11:52:49.113Z',12,12) as timestamp(3)) for the first,  for the second you can use substr a...
22330 Aug 2016 @ 02:41 PDTDatabaseReplyReplacing tableIf emp exists your query will fail. To replace , drop old first.   Rlgass
22227 Aug 2016 @ 09:05 PDTDatabaseReplyCursors in stored proceduresUse: Dynamic Result sets 2, Declare and open a second cursor.   Rglass
22109 Aug 2016 @ 08:14 PDTDatabaseReplyHow to do a random sample?Random sample will return different results each time. You could insert  results into a work table and join to that each additional time.   Rglass
22005 Aug 2016 @ 06:38 PDTDatabaseReplyUser's DDLsel * from dbc.users where username = 'youruser';   logon status from dbc.logonrules.   Rglass
21929 Jul 2016 @ 11:21 PDTPrivate Forum
21828 Jul 2016 @ 05:34 PDTToolsReplyHELP cannot display long field namesUse Column Dictionary Name or Column SQL name in the Help results.   Rglas
21718 Jul 2016 @ 12:25 PDTGeneralReplyUse of TABLE Keyword select statement Check out manual  on SQL functions. This is syntax for using Table UDF.   Rglass
21608 Jul 2016 @ 12:03 PDTGeneralReplyHOW TO GET ODD NUMBER ROWS IN A TABLE IN TERADATAWhat application are you using and what RDBMS version are you on? I'm curious why Carlos' solution did not work for you.   Rglass
21508 Jul 2016 @ 11:50 PDTViewpointReplyViewpoint SUSE CompatibilityAvot, It is, I've been there. Your CSR should provide you with a matrix, or find on T@YS.   Rglass
21423 May 2016 @ 10:59 PDTGeneralReplyHow to run BTEQ in Windows machinYou can type Bteq at the command prompt after you have installed the software or start from a batch file     Rglass
21316 May 2016 @ 11:13 PDTViewpointReplyVP 15.10 :: How to get email alert for long running active queries.You can set up a session alert with email action for active time.   Rglass 
21216 May 2016 @ 06:13 PDTViewpointReplyIs there a way to control RESPONDING STATE of large extracts using TASM Exceptions?Harsha, when you say control what do you mean? Since the query execution has completed you can only let it finsh responding or abort. You can abort using a session alert if your versions supports...
21126 Jan 2016 @ 07:43 PSTGeneralReplyFETCH TABLE NAMES WITH INDEX COLUMN NAMES You can find your info in dbc.indicesv     Rglass
21015 Jan 2016 @ 08:53 PSTGeneralReplyRemoving decimals from datetime in TeradataYou can just select what you want.   SELECT CURRENT_TIMEstamp(0)(FORMAT 'MM/DD/YYbHH:MI:SSBT') ; SELECT CURRENT_TIMEstamp(DATE) (Format 'MM/DD/YY'); SELECT CURRENT_TIME...
20911 Jan 2016 @ 06:22 PSTDatabaseReplySpool Space Issue on More Projected Columns Than Lesser Projected ColumnsAre your statistics current and complete?   Rglass
20830 Dec 2015 @ 10:44 PSTDatabaseReplyCreate Table & VARCHARDave, please share the DDL of the table you have created on Teradata.   Rglass
20725 Nov 2015 @ 12:17 PSTGeneralReplyUnassigned Work Load Definition For properly Configured User in TASM !!!!This may help explain. I log K's/ day , all have 0 ampcputime, many do have small parsercputime.   teradataforum.com/teradata/20101110_074343.htm   Rglass
20624 Nov 2015 @ 05:58 PSTDatabaseReplydrop/create table no volatilCristina, If your question is can I check if a table exists, if not then create it, then this will work.   Bteq:   sel * from dbc.tablesv where databasename = 'YourDB'...
20520 Nov 2015 @ 06:03 PSTDatabaseReplyDerived table efficiencyConsider the primary index of your derived table ( first column of Table1 because of Sel *) Is it the same as the primary index of Table1? Rglass    
20418 Nov 2015 @ 06:49 PSTDatabaseReplyFind User who dropped table in teradata DB You can use your DBC DBQL tables providing logging is enable for the user,  dbqlogtbl, dbqlsqltbl   Rglass
20315 Nov 2015 @ 06:40 PSTViewpointReplyData Collector Status AlertSwetha, there is a data collector alert type, I don't have any set up but that may do what you are looking for.   Rglass
20229 Oct 2015 @ 06:34 PDTToolsReplycomparing 2 Teradata tables with different structureA minus will work for comparing the data in the columns from table1 to table2 on columns that exist on both.   For extra columns you can also use minus. Sel columnname from dbc.columnsv whe...
20128 Oct 2015 @ 06:20 PDTDatabaseReplyStep by step SQL execution Subash, Providing Stepinfo is being logged you can use DBC.DBQLStepTbl.     Rglass

Pages