22 | 23 May 2007 @ 07:52 PDT | Database | Reply | Difference 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... |
21 | 18 May 2007 @ 12:19 PDT | Database | Reply | Executing SQL Statements through ADO | I hope the below link will help you:http://www.codeguru.com/cpp/data/mfc_database/ado/article.php/c1141/#more |
20 | 17 May 2007 @ 05:36 PDT | Database | Reply | Executing SQL Statements through ADO | I 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+... |
19 | 17 May 2007 @ 12:10 PDT | Database | Reply | Joining on multiple columns | YES~vinod |
18 | 16 May 2007 @ 09:59 PDT | Database | Reply | Joining on multiple columns | Hi,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 ... |
17 | 05 Dec 2006 @ 10:20 PST | Database | Reply | joint account issue | Can 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... |
16 | 05 Dec 2006 @ 05:32 PST | Database | Reply | Getting 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... |
15 | 05 Dec 2006 @ 05:12 PST | Database | Reply | joint account issue | Hi,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... |
14 | 21 Nov 2006 @ 11:31 PST | Database | Reply | teradata function | Hi,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 ... |
13 | 17 Nov 2006 @ 02:03 PST | Database | Reply | SQL Question | The 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... |
12 | 28 Aug 2006 @ 02:43 PDT | Database | Reply | CONNECT 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... |
11 | 04 Aug 2006 @ 08:04 PDT | Database | Reply | Top Function | Hi Aravind,I hope you are working on V2R6. |
10 | 03 Aug 2006 @ 05:32 PDT | Analytics | Reply | Failure 7453 Interval field overflow | I 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... |
9 | 02 Aug 2006 @ 12:58 PDT | Database | Reply | ceil 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 ... |
8 | 01 Aug 2006 @ 02:18 PDT | Database | Reply | Top Function | There 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) |
7 | 28 Jul 2006 @ 04:19 PDT | Database | Reply | How to fetch chunks of data in Teradata | I 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... |
6 | 19 Jul 2006 @ 01:35 PDT | Database | Reply | Date 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... |
5 | 14 Jul 2006 @ 02:32 PDT | Database | Reply | operation on current_Timstamp | Hi,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 ... |
4 | 15 May 2006 @ 05:23 PDT | Database | Topic | PPI explain | Below 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... |
3 | 01 Mar 2006 @ 09:11 PST | Database | Reply | Secondary Index | if 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 |
2 | 28 Feb 2006 @ 11:12 PST | Database | Topic | Secondary Index | IS 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... |
1 | 02 Jan 2006 @ 12:06 PST | Database | Topic | Union query 2616 error | select 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... |