#DateForumTypeThreadPost
2223 May 2007 @ 07:52 PDTDatabaseReplyDifference between GTT and Volatile tables..!!Global Temporary table definition persist across session and Volatile table are session specific tables.Index can be created on Global Temporary table and not on Volatile table.Global temporary tab...
2118 May 2007 @ 12:19 PDTDatabaseReplyExecuting SQL Statements through ADOI hope the below link will help you:http://www.codeguru.com/cpp/data/mfc_database/ado/article.php/c1141/#more
2017 May 2007 @ 05:36 PDTDatabaseReplyExecuting SQL Statements through ADOI am not familiar with C++ ADO application i would suggest you to go with following way:Check by executing the select statement SELECT count(*) FROM XYZ;IF the count is zero i your C+...
1917 May 2007 @ 12:10 PDTDatabaseReplyJoining on multiple columnsYES~vinod
1816 May 2007 @ 09:59 PDTDatabaseReplyJoining on multiple columnsHi,There is a DIFFERENCE check for the below given analysis:The concept of Full Outer join is to show data from both tables if matching row found and display NULL if no rows are found.Bb1 b2 b31 ...
1705 Dec 2006 @ 10:20 PSTDatabaseReplyjoint account issueCan you answer my question based on the answer it would be easy to reply to your question?1. What result are you expecting?2. What are the Primary Index of the above mentioned three tables?3. Do we...
1605 Dec 2006 @ 05:32 PSTDatabaseReplyGetting Table names and COlumns names from a Query (Reverse Engineering)Hi,I am not sure about the tool. But to fetch the columns from the query you can built a view on that query and fetch the column name from dbc.columns. Other than that i don't think any help we can...
1505 Dec 2006 @ 05:12 PSTDatabaseReplyjoint account issueHi,I hope my example below will help you understand the difference.Create Table A(I Integer, J integer, K integer,L Integer);Insert into A values(1,22,22,2);Insert into A values(1,11,11,1);The belo...
1421 Nov 2006 @ 11:31 PSTDatabaseReplyteradata functionHi,We can write some sql by Code as per our requirement by using SQL in-built function but it is not function. We are using this inline in the sql statement. If we cannot achieve our functionality ...
1317 Nov 2006 @ 02:03 PSTDatabaseReplySQL QuestionThe below is best way to execute the query:select *from sys_calendar.calendarwhere not(calendar_date between '2006-10-01' and '2006-10-31');Explain plan's of two queries: 1) First, we lock a dist...
1228 Aug 2006 @ 02:43 PDTDatabaseReplyCONNECT BY.. PRIOR Equivalent in Teradata?Hi,I am sorry i could not test the below query as i don't have the V2R6 box avaliable in my environment.Create Table Test_Recursive(I Integer);INSERT INTO Test_RecursiveValues(1);INSERT INTO Test_R...
1104 Aug 2006 @ 08:04 PDTDatabaseReplyTop FunctionHi Aravind,I hope you are working on V2R6.
1003 Aug 2006 @ 05:32 PDTAnalyticsReplyFailure 7453 Interval field overflowI am able to re-produce the error with the below example:Table vinod_12 has column ts of type timestamp with following records:ts=================2006-05-01 02:14:262006-05-03 02:14:262006-08-03 02...
902 Aug 2006 @ 12:58 PDTDatabaseReplyceil function in oracle!There is no ceil function in teradata but the results can be achieved easily by the below query:select CASE WHEN NUM > 0 THEN CAST(NUM AS INTEGER) +1 ...
801 Aug 2006 @ 02:18 PDTDatabaseReplyTop FunctionThere is an Top function in V2R6, but if you want to try out in V2R5 you need to go by analytical function.Select *From vinod_1Qualify Row_number() OVER(Order by empno)
728 Jul 2006 @ 04:19 PDTDatabaseReplyHow to fetch chunks of data in TeradataI would suggest to fetch the rows by using analytical function i.e Row_Number() Select *From (select Row_number() OVER(Order by day_of_calendar) val, day_of_calendar, calendar_date from sys_calend...
619 Jul 2006 @ 01:35 PDTDatabaseReplyDate format - FMDD?The query helps in getting the desired output but the string format not able to convert back to date.select CASEWHEN SUBSTRING(CAST(DATE -11 AS FORMAT 'DD') FROM 1 FOR 1 ) = 0 THEN SUBSTRING(CA...
514 Jul 2006 @ 02:32 PDTDatabaseReplyoperation on current_TimstampHi,select ((CAST('2006-07-12 00:00:00' AS TIMESTAMP(0) FORMAT 'YYYY-MM-DDBHH:MI:SSBZ')) - (CURRENT_TIMESTAMP(0))) DAY(2) TO SECOND;We can't directly subtract two timestamp if we need difference we ...
415 May 2006 @ 05:23 PDTDatabaseTopicPPI explainBelow are the two tables created vinod_5 and vinod_6, the problem is of those two queries where if all the PI are considered and only four columns specified in the (2nd ) query then the explain pla...
301 Mar 2006 @ 09:11 PSTDatabaseReplySecondary Indexif the query which we fire reminas the same always with only where clause equlaity changes so still we need to collect the statistics.Regards,Vinod
228 Feb 2006 @ 11:12 PSTDatabaseTopicSecondary IndexIS it necessary to always collect statistics on NUSI? At my end the table is frequently accessed and due to some reason we can't collect statitics so does this means that the NUSI on the table will...
102 Jan 2006 @ 12:06 PSTDatabaseTopicUnion query 2616 errorselect 127 from customerunionselect 131 from customerThe above query generates the subject mentioned the qorkaround is typecast the value 127 to Integer. the reason for the error is the value 127 i...