#DateForumTypeThreadPost
1512 Jun 2015 @ 12:41 PDTDatabaseReplyConvert string into datehow to convert string like Wed Jun 10 10:43:14 2015 to Date or timestamp format?
1412 Jun 2015 @ 12:40 PDTDatabaseReplyConverions of timestamp to FORMAT 'MM/DD/YYYYBHH:MI:SS'how to convert string like Wed Jun 10 10:43:14 2015 to Date or timestamp format?
1324 Nov 2014 @ 10:47 PSTDatabaseReplyConnecting Multiple Teradata Serversit is very simple you need to just write down TPT script which can fetch data from one table for server - A and then dump data on other server.  or you can write down fast export script and e...
1209 Nov 2014 @ 12:28 PSTDatabaseTopicSuggestion to use ALL or MAX function I want your suggestion to on using ALL / MAX function in this case.   ​DROP TABLE STUDENT_VT; CREATE VOLATILE TABLE STUDENT_VT , NO LOG ( NAME CHAR...
1108 Nov 2014 @ 07:07 PSTDatabaseReplyString Functions Hi  you can try this with TD14.0 version:   SEL  CASE  WHEN COL_1 = 'goodbye'  THEN COL_1 WHEN COL_2 = 'goodbye'  ...
1028 Feb 2014 @ 11:53 PSTGeneralTopicunwanted space is coming in resulted export file Hi All,   I have used TRIM ( BOTH FROM string_name) command to remove extra character / space coming in export file but it is not working. could you please help to resolve this issu...
927 Nov 2012 @ 08:05 PSTDatabaseReplyDetermine which database is up and running or active?     I think I got answer from my friend's help, what i tried is setting to DATABASE qa0; and it ran successful and then I tried to set database with this query DATABASE qa9 ; and wh...
827 Nov 2012 @ 07:47 PSTDatabaseTopicDetermine which database is up and running or active?   Do you know how to determine which DB is up on Teradata?    there is one common  system test server and there are two different database on same server.   Database n...
728 Aug 2011 @ 05:42 PDTDatabaseReplyHow to limit the number of rows returnedCould you please tell nature of data in your table?
624 Aug 2011 @ 07:07 PDTToolsReplyBTEQ scriptRajeev, you can use activity count select * From temp_table; .IF ACTIVITYCOUNT = 0 THEN .QUIT 1 .IF ACTIVITYCOUNT > 0 THEN .QUIT 0 so if you don't get data then it will quit with C...
531 Jul 2011 @ 04:51 PDTGeneralReplyRename Tables - Fallback Table, Non-back table sorry , It was so silly question... I checked and read table alter topics in TD manual... now doubt is clear.... CREATE SET TABLE ONE_DAY_TABLES.t1 ,FALLBACK , NO BEFORE JOURNAL, ...
431 Jul 2011 @ 10:46 PDTGeneralTopicRename Tables - Fallback Table, Non-back table Hi All, I have read in SQL Reference - Data Manipulation Statements that UPDATE Processing Time for an UPDATE operation is longer under the following conditions: "When the FALLBACK option ...
320 Jun 2011 @ 03:55 PDTGeneralTopicUpdate MERGE when matched is referenced on non - PI value Hi All, I am following below topic http://www.teradatamagazine.com/v10n01/Tech2Tech/Another-option-on-the-table/ I have some questions , 1. How I can use MERGE for update query whe...
209 Jun 2011 @ 03:45 PDTToolsReplyHow to make use of ARCMAIN utility to take DB backup.You can also use DUMP in place of ARCHIVE ------------------------------- logon ZZZZ/YYYY,XXXX; DUMP DATA TABLES (DATABASENAME.TABLENAME1), (DATABASENAME.TABLENAME2), (DATABASENAME.TA...
126 Apr 2011 @ 06:12 PDTDatabaseTopicRequire Help to understand session count into ARCMIN utilityCould you please help to understand what is criteria or method to determine number of session required for any archiving job into MVS? it is syntax is //ARCHIVE EXEC PGM=ARCMAIN,PARM='SESSIO...