#DateForumTypeThreadPost
1029 Jan 2014 @ 07:33 PSTToolsReplyonline archive feature in Teradata 13 Hey, I'm facing an issue in copying data from one machine to another using arcmain copy command ARCHIVE DATA TABLES (UT_TAB.EVENT) (PARTITIONS WHERE (!EVENT_START_DT BETWEEN '2013-...
929 Jan 2014 @ 06:46 PSTToolsReplyCopy tables between two different systemsHey, I'm facing an issue in copying data from one machine to another using arcmain copy command ARCHIVE DATA TABLES (UT_TAB.EVENT) (PARTITIONS WHERE (!EVENT_START_DT BETWEEN '2013-10-01&...
820 Nov 2013 @ 01:54 PSTDatabaseReplyARCMAIN giving Error 3802:Database '$ARC' does not exist.I'm unable to find my archived file in my system can anyone please help me how to locate the file following is the script  LOGON IP/dbc,dbc; ARCHIVE DATA TABLES (UT_TAB.ACCOUNT_FEATU...
723 Oct 2013 @ 12:21 PDTDatabaseReplyExtracting Domain Names from EMAIL_TXT FieldI Have another issue again i have 2 ids & i need to join then id 1 = 10126409.1 another example of id 1 is  10126409.13   and  ID 2 = 10037765.1.   ...
626 Sep 2013 @ 12:11 PDTDatabaseReply3707 Syntax error,expected something like a '"||"'or a 'FROM' keyword between a string or a Unicode character literalThe following query is thorwing an error 3707 Syntax error,expected something like a name or a unicode delimited identifier or an UDFCALLNAME Keyword between ) and ; SELECT CASE WHEN N...
501 Sep 2013 @ 10:50 PDTDatabaseReplyExtracting Domain Names from EMAIL_TXT FieldTD 14 thanx alot it worked (Y)
429 Aug 2013 @ 11:07 PDTDatabaseReplyCombine Multiple Select StatementsUNION ALL between every query will solve this issue.
329 Aug 2013 @ 10:39 PDTDatabaseReplyExtracting Domain Names from EMAIL_TXT FieldDneoth i have one question I have 2 strings 10371676.2.1 10374263.14.1  I need to substr it from first position till the second dot if i substr(id,1,11) then its going wrong coz i...
221 Aug 2013 @ 05:57 PDTDatabaseReplyCollecting statisticsI am taking a join on a index column & its taking time to execute the following query  SELECT A.ACCOUNT_NUM AS ACCOUNT_ID, A.Limit_Type_Cd, A.Acct_Limit_Amt, A.Acct_Limit_Expiry_Dt, ...
121 Aug 2013 @ 04:25 PDTDatabaseReplyCollect StatisticsI am taking a join on a index column & its taking time to execute the following query  SELECT A.ACCOUNT_NUM AS ACCOUNT_ID, A.Limit_Type_Cd, A.Acct_Limit_Amt, A.Acct_Lim...