#DateForumTypeThreadPost
1223 Nov 2009 @ 08:41 PSTDatabaseTopicProblem with Global Temp tableHi,I have a set of global temp tables. I have views built on top of it. When i tried to use them in my stored procedure. I got a error message Error 3523: An owner referenced by user does not have ...
1107 Oct 2009 @ 08:06 PDTDatabaseTopicimplicit cursors in TeradataHi,Does Teradata implicit cursors in any SQL execution. I remember reading this in the net somewhere that every database uses cursors for any query execution. And usage of the cursor would make the...
1006 May 2009 @ 08:21 PDTDatabaseReplyPE and AMP setupThanks for the reply...So the 2 PEs will be sending across the requests to all the amps in the node. Am i right...Arun
903 May 2009 @ 07:42 PDTDatabaseTopicPE and AMP setupHi,During the Teradata setup, how do we set up PE and AMP. In a ideal scenario, what is the number of PEs are setup and how many AMPs does PE is set to serve. To be clear...Is there a ratio between...
818 Feb 2009 @ 02:38 PSTAnalyticsTopicProblem in finding the latest recordHi,We are facing this problem in our project :There are 2 tables tableA and tableB. We need to fetch the code value from the latest row in the tableA which satisfies the join conditions between tab...
713 Feb 2009 @ 05:23 PSTAnalyticsTopicFinding the number of records in a derived tableshi,We have the following situation :We need to use a derived table to get the code values based on some conditions. If the derived table has some rows, we need to insert into the table. if not we n...
606 Nov 2008 @ 01:14 PSTDatabaseTopicAccessing teradata tables from shell scriptsHi,Is there a way to access the teradata tables from shell scripts. Lets say we have to run a script in case of a load failure, Is it possible to access the error tables in the script and then mail...
526 Sep 2008 @ 06:43 PDTAnalyticsReplyhow to find record having 5th highest salary in a table?Hi Preeti,Try using Rank on your salary field to get that. You can try the following query :SELECT EMP_NO,SALARY,RANK(SALARY)FROMEMPQUALIFY RANK(SALARY) = 5;Try this and let me know if this works.....
417 Sep 2008 @ 06:36 PDTToolsReplyBTEQ Job ShedulingPlease check your IBM Maestro Scheduler manual...There should be an option to make your job a File Triggered one...I have seen this option in mainframe schedulers..So i am guessing that it would be...
317 Sep 2008 @ 06:19 PDTToolsReplyexists and not existsHi,If i am right..NOT EXISTS works like this...The subquery is executed first...in your case..1 will be returned from the subquery if at all there exists a row that satisfies the condition..none of...
217 Sep 2008 @ 05:01 PDTAnalyticsReplyPlease help me in optimizing the below queryHi,Would there be a better performance if we select the required fields from the table to the derived tables instead of the whole table being used for joins. This would reduce the SPOOL size. Pleas...
115 May 2008 @ 03:02 PDTAnalyticsTopicBranching in stored proceduresAll,Is there any way to perform branching to a specific label in stored procedure. Based on my input value i have to execute one part of my code and stop my execution. Please let me know how this c...