#DateForumTypeThreadPost
1202 Dec 2013 @ 08:01 PSTUDAReplyDifference between key and index? Here are some differences.   • A PK is a relational modeling convention which allows each row to be uniquely identified. • A PI is a Teradata convention which determin...
1102 Dec 2013 @ 07:52 PSTDatabaseReplysum of amout for the date falling in the respective month i.e months wise sum amount is requiredPeiter, Are you looking for something similar to following? Select cast((order_date(FORMAT 'MM-YYYY')) as char(7)) as Cal_Month, Sum(OPP.Expected_Amount) From Opportunity OPP Inner Jo...
1002 Dec 2013 @ 07:29 PSTTrainingReplyError 3802Mohammad, did you include IP and cop information in Host file? An entry is required in Host file to resolve this error. i.e.: 127.0.0.1   DemoTDATcop1 Host file can be found at %windir...
926 Nov 2013 @ 02:50 PSTGeneralReplyMVC ToolDid you try to find  tool called "WinMVC" (developed by GCC folks)? This was Teradata GCC Pakistan development effort and it is internal asset. So this won't be available for ext...
826 Nov 2013 @ 02:38 PSTUDAReplySupressing Titles on .EXPORT commandCan you check if nulls or blank records are in table?
726 Nov 2013 @ 02:27 PSTDatabaseReplyrequired to get the records for last 6 monthsAre you looking something like this:   What I could understand from question is, you have two seperate tables and want to sum a column value based on Order_Date filter (last six months...
618 Nov 2013 @ 12:57 PSTDatabaseReplyStart from specific sql in Stored ProcedureFollowing might help you Replace Procedure ABC (IN STEP_ID INTEGER) Declare RESUME_NEXT Varchar(10) BEGIN SET RESUME_NEXT = 'false'; IF (RESUME_NEXT = 'true' OR STEP_ID ...
518 Nov 2013 @ 12:16 PSTDatabaseTopicBest way and datatype to store E-Notation in Teradata during Migration processHi, I have a some data which I need to store in Teradata as E-notation. Values can be between 1.17549E-38 to 3.40282E+38. It would be great if best suitable data type and loading metho...
429 Jul 2013 @ 11:32 PDTToolsReplyMVC TOOLHi Hardik,  If I am not too late, can you please send me this tool to test at kawish.siddiqui@gmail.com I am waiting for your response.   BR, Kawish Siddiqui -  
326 Mar 2013 @ 12:29 PDTToolsReplySQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.11.0.04Have you tried connecting SQLA using Teradata .Net Provider? Is that working? I remember I faced similar issue and the only workaround at that I found was to use .Net Provider connection instead of...
226 Mar 2013 @ 12:22 PDTToolsReplyHow can I automate copying Teradata tables to MS Access?One way could be to use ODBC Link Tables in MS Access MDB file. Link Teradata tables in MS Access Create a query in MS Access for Insert/Select using Teradata table as sources and MS Access Tabl...
107 Jun 2007 @ 12:15 PDTToolsTopic.OLE DB for TeradataCan any one tell me on which port OLE DB Provider for Teradata communicates?We have servers behind firewall and will need to open specific ports to make possible communication between SQL SERVER an...

Pages