#DateForumTypeThreadPost
3221 May 2015 @ 01:02 PDTGeneralReplyDifference between REPLACE VIEW and CREATE VIEWAny luck in getting answer?
3115 May 2015 @ 12:50 PDTGeneralTopicDifference between REPLACE VIEW and CREATE VIEWCan anyone assist me on the performance difference between REPLACE VIEW and CREATE VIEW? We always preferred to go for a REPLACE VIEW considering the usability but I am curious if it has any impact...
3019 Sep 2012 @ 11:58 PDTToolsReplySql Assistant 13 doesn't allow more than 1 Show Table statementYes, I too faced the same issue... but I don't think it is specific to version 13.11 ... like Show table we also have issues with EXPLAIN. There is an work around for this.... Instead of view...
2923 Nov 2011 @ 02:44 PSTDatabaseReplyHelp required to tune the Sub query in WHERE Clause to access the lookup table yes, you are right.... we need to include the where condition and we will apply the filter condition based on the business rule we fetched from teh business rule table... otherthan sysexecsql, d...
2814 Nov 2011 @ 02:41 PSTDatabaseTopicHelp required to tune the Sub query in WHERE Clause to access the lookup table Hi, I have a base table and a lookup table. I need to generate the product code based on the business conditions stated in the lookup table. However I do not have a  column to join the ...
2714 Nov 2011 @ 02:21 PSTDatabaseReplyRows to column | SQL looping | reccursion Fld_LEVEL is the temp column to track the depth of the process. In the seed query, it has been intialized with 0  ( SELECT  country, CAST(state_nm  AS VARCHAR(200) ) , 0 AS Fl...
2625 Nov 2010 @ 12:32 PSTTrainingReplyNeed help to find out Teradata certification materialHi Bommireddy, can you please send me TEO-121 to my id umakathir@hotmail.com?
2525 Nov 2010 @ 12:17 PSTTrainingReplyTeradata certification materialJanaki, did you register as a Teradata Partner and bought the book? Please let me know how did you get the material.
2419 Aug 2010 @ 10:22 PDTDatabaseReplyto change the titlehey, Did you try ADD option as Carlos said? Try that out it would work. If the named column already exists, ADD indicates that its attributes are to be changed.
2312 Nov 2009 @ 11:07 PSTUDAReplyBTEQ Signon problem CLI: 224While you install demo version of TD, default data source names would also be created such as DEMOTDAT, FINANCIAL, etc. Verify your Data sources (ODBC).For DemoTDat, financial is the user id and pa...
2215 May 2009 @ 11:49 PDTToolsReplyHow to find a primary key in teradata tables?If you show the definition of the table either by right clicking on the table listed in the tree view or type SHOW TABLE dbname.tablename;it will display the definition of the table with all indice...
2115 May 2009 @ 11:28 PDTUDAReplyStoring TD Stored ProceduresI hope you would have connected to database before creating the procedure. If so, place the definition in Teradata SQL Assistant and Press F5. It will check the syntax.REPLACE PROCEDURE TEST()BEGIN...
2005 Jan 2009 @ 01:38 PSTToolsTopicData upload thru OLE DB Provder from SQL 2005 to Teradata-Issue with special charsWe are using OLE DB Provider for uploading the data from SQL server 2005 to Teradata using AMJ files, etc. While uploading the data which has some junk chars but that was accepted by SQL server 200...
1928 Dec 2007 @ 06:50 PSTToolsTopicSELECT INTO Class in BTEQI have a following query written in BTEQ script file. Also i have command file which invokes the script file. I want to return the record count results from the belwo select query to command file a...
1829 Aug 2007 @ 08:55 PDTToolsReply2631-Transaction ABORTed due to %VSTR.Thank you. As you said, I'll try to the analysis on other apps which was running at that time.
1729 Aug 2007 @ 08:17 PDTToolsTopic2631-Transaction ABORTed due to %VSTR.Hi,I am getting the sqlcode 2631 which is "Transaction ABORTed due to %VSTR." when i execute my stored procedure.My stored procedure is basically fetches the data from multiple tables and do some c...
1613 Nov 2006 @ 04:31 PSTDatabaseReplyHow to use/enable Parsing Engine?Thanks, Sarathi & Gokul.
1513 Nov 2006 @ 04:07 PSTDatabaseReplyIs there any way to write extract job from Teradata?We need to write a JCL (mainframe job) for extracting the data from Teradata and generate the reports using that data. This might be scheduled daily job. so, if some one provide some sample job or ...
1410 Nov 2006 @ 06:02 PSTDatabaseTopicHow to use/enable Parsing Engine?Hi,I want to optimize my query and would like to use optimizer. Please if anyone knows about how to enable Parsing engine/query optimizer, please help me.I know about the usage of Parsing engine (P...
1310 Nov 2006 @ 04:36 PSTDatabaseTopicIs there any way to write extract job from Teradata?If any one knows about the extract job from Tradata, please help me.Thanks,Uma Kathir
1210 Nov 2006 @ 04:28 PSTDatabaseReplyException Handling in Teradata SP?I am all set now and handles as below:-----------DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET mTT = mTT || 'ERR-' || SQLSTATE -----------where mTT is the output variable.
1109 Nov 2006 @ 10:32 PSTDatabaseReplyA constant value in a query is not valid for column A_TKN_PTC_WKI am all set now.Actually, my table field 'A_TKN_PTK_WK' has the data type of Decimal (2,0) and it was trying to store 119.0 and throws the error.
1009 Nov 2006 @ 07:33 PSTDatabaseTopicA constant value in a query is not valid for column A_TKN_PTC_WKI am getting run time error while executing my SP named as MainLeavecal "Failure 3520 MainLeaveCal:A constant value in a query is not valid for column A_TKN_PTC_WK"I am using dynamic sql for the up...
909 Nov 2006 @ 04:22 PSTDatabaseReply2616 : Numeric overflow error during computationOkay...Thank you.
808 Nov 2006 @ 07:52 PSTDatabaseReplyTeradata - Stored ProceduresHope the below book will be useful for you.Chapter 21 - Stored Procedures Teradata SQL: Unleash the Power by Michael Larkins and Tom Coffing Coffing Data Warehousing © 2001 Thanks,Uma Kathir

Pages