#DateForumTypeThreadPost
8124 Sep 2014 @ 12:58 PDTDatabaseReplyOverlap Function Purpose in ProjectsThanks Raja.. :)
8018 Sep 2014 @ 10:24 PDTDatabaseTopicOverlap Function Purpose in ProjectsHello All, How is the OVERLAP function used in the real time projects. I understand the functionality, not the purpose of its use. Can anyone give a small example which explains the process? &nb...
7916 Sep 2014 @ 07:36 PDTDatabaseReplyTIme Difference Thanks Dieter.. :).. 
7816 Sep 2014 @ 09:41 PDTDatabaseTopicTIme Difference Hello All, THe below query is to find the difference between Previous Hour Time - Minutes to get the beginning of the previous hour. SEL CAST(CAST(CURRENT_TIME AS FORMAT 'HH:MI') AS CHAR(...
7730 Aug 2014 @ 12:27 PDTDatabaseReplyTERADATA Regular Expression FunctionThanks Raja.. :-)
7627 Aug 2014 @ 09:32 PDTDatabaseTopicTERADATA Regular Expression FunctionHello All, In the info.teradata.com, which document can i find regular expression Function.     Thanks Jugal
7527 Aug 2014 @ 02:42 PDTToolsReplyFASTEXPORT LoopingHello All, After lot of R&D i understood how the IF ELSE statement can be applied.   .LOGTABLE LOG; .BEGIN EXPORT; .EXPORT OUTFILE exported; SEL * FROM TABLENAME; .END EXPORT; .IF ...
7412 Aug 2014 @ 05:23 PDTToolsReplyFASTEXPORT LoopingHi Raja, Your right. It is a conditional statement, i was wrong to call it looping. What i dont understand in the example or i don see a section which explains the way, conditional statement ...
7308 Aug 2014 @ 01:27 PDTToolsReplyFASTEXPORT LoopingHi Steve, I tried a simple running a simple script using BTEQ using Looping Condtion. Script:   .Logon username/pwd, .IF 'TRUE'='TRUE' THEN; .RUN FILE FastExport.txt...
7207 Aug 2014 @ 08:24 PDTToolsReplyTeradata SQL Assistant 13.11 - Where can I download?Hi, You can download from the following link: http://downloads.teradata.com/download/database/teradata-express/vmware load it thru VMWARE. It is a complete pack. No need of installations. If u ...
7107 Aug 2014 @ 06:36 PDTToolsTopicFASTEXPORT LoopingHi All, Can somebody write a simple FastExport script with IF ELSE condition. THe example given in info.teradata.com. I am not able to understand it.   THanks in Advance Jugal
7004 Aug 2014 @ 03:21 PDTToolsReplyBTEQ REPORT EXPORT AND IMPORT Hi Dieter, I applied the changes as suggested. Which reduced the spaces. And i had included SKIP 1 in the script.   Thanks for the Help Jugal.
6902 Aug 2014 @ 10:51 PDTToolsReplyBTEQ REPORT EXPORT AND IMPORT Hi Dnoeth, I had oversighted it b4. I later applied the changes to the query. CAST(EmpId AS CHAR(3)),EmpName,CAST(DeptId AS CHAR(10)),CAST(DeptId AS CHAR(3)). When i export in the output i could...
6802 Aug 2014 @ 10:38 PDTToolsReplyBTEQ REPORT EXPORT AND IMPORT Hi Dnoeth, I had oversighted it b4. I later applied the changes to the query. CAST(EmpId AS CHAR(3)),EmpName,CAST(DeptId AS CHAR(10)),CAST(DeptId AS CHAR(3)). When i export in the output i could...
6702 Aug 2014 @ 10:33 PDTToolsReplyBTEQ REPORT EXPORT AND IMPORT Hi Dnoeth, I had oversighted it b4. I later applied the changes to the query. CAST(EmpId AS CHAR(3)),EmpName,CAST(DeptId AS CHAR(10)),CAST(DeptId AS CHAR(3)). When i export in the output i could...
6601 Aug 2014 @ 06:28 PDTToolsTopicBTEQ REPORT EXPORT AND IMPORT Hello All, I create a BTEQ Report file. While exporting i converted it to CHAR data type. When importing the exported file. I am getting a BAD CHARACTER ERROR for EmpId. I passing a Fixed Length D...
6501 Jul 2014 @ 01:20 PDTDatabaseTopicJoin Indexes on Complex QueriesHello All, How can i apply join index for the below query SEL EmpId, DeptId, EmpName, TotalDeptSalary FROM ( Sel EmpId, DeptId, EmpName, SUM (Salary) over (partition by dept...
6401 Jul 2014 @ 01:07 PDTTrainingReplyTeradata 14 Basis certificationThanks Raja.. :). I got the docs to refer for basics certification. Intro to Teradata database is the only doc to refer for TE0-141 - Teradata 14 Basics.
6325 Jun 2014 @ 04:39 PDTTrainingTopicTeradata 14 Basis certificationHello All,   I am want to write teradata 14 basics certification. Which docs  should i refer in info.teradata.com. Thanks Jugal  
6225 Jun 2014 @ 04:35 PDTDatabaseReplyGroup By an Partition by in a single queryThanks for the reply. I do not have any query. I want to understand the logic as to how to apply both together.   Jugal
6107 Jun 2014 @ 10:07 PDTDatabaseReplyGroup By an Partition by in a single queryHi Santanu,   I had included the group by clause in my query. Still i was getting the above error i mentioned.
6005 Jun 2014 @ 11:28 PDTDatabaseTopicGroup By an Partition by in a single queryHello All, I know the functionality of group by function and partition by function. But when i use both the queries in the same query i get an error as Selected non-aggregate must be part of the g...
5905 Jun 2014 @ 11:21 PDTDatabaseReplyHow to Choose Columns for JI,CS and PPIThanks Santanu... :)
5827 May 2014 @ 03:13 PDTDatabaseTopicHow to Choose Columns for JI,CS and PPIHello All, How to determine columns, for which we like to create JOIN INDEX,Collect Statistics or PPI?. Plz Help.
5712 May 2014 @ 07:33 PDTToolsTopicFastLoad ErrorHello All, In the below scripts FILE, i have exported the data using TEXT format converting the DEFINE To CHAR.   FastLoad Script:   .LOGTABLE DB.Logs; .LOGON 127.0.0.1/jugal,jugal;...

Pages