106 | 25 Feb 2016 @ 11:54 PST | Viewpoint | Reply | Unable to start ViewPoint in Firefox | Below is data logged in the Log File when i tried opening viewpoint.
/opt/teradata/viewpoint/portal/logs/viewpoint.log:
TD-EXPRESS:~ # view /opt/teradata/viewpoint/portal/logs/viewpoint.l... |
105 | 25 Feb 2016 @ 11:45 PST | Viewpoint | Topic | Unable to start ViewPoint in Firefox | Hello All,
This is the 1st time i am using the viewpoint portel.
In the firefox browser i tried both http:localhost:9080 and http:127.0.0.1:9080. But i was unable to view the point.
When... |
104 | 14 Feb 2016 @ 09:02 PST | Database | Reply | PPI Dropping/Adding Partitions | Thanks for replying Dieter.. :)
|
103 | 13 Feb 2016 @ 11:13 PST | Database | Topic | PPI Dropping/Adding Partitions | Hello All,
What is the query to drop and add CASE_N and KEY for PPI?.
I was able to drop and add range_n whereas when i tried for CASE_N and KEY i was not able to either add or drop the P... |
102 | 13 Feb 2016 @ 10:14 PST | Database | Reply | Select Columns for UPI,NUPI,USI and NUSI | Thanks For replying rupert. I went throught the document gave me a better understanding on the selection criteria.
|
101 | 11 Feb 2016 @ 09:42 PST | Database | Topic | Select Columns for UPI,NUPI,USI and NUSI | Hello All,
Can someone explain on what basis we select indexes for the columns in the field.
Following is my understand:
UPI -> When we have Unique value, which is evenly distributed ... |
100 | 10 May 2015 @ 08:38 PDT | Database | Topic | Different Output When ran a macro in Teradata Sql Assistant and Studio Express | Hello All,
When i ran a macro in Teradata Express studio i got a proper output(Connection Type JDBC), whereas when i ran the same macro in Sql Assistant i am not able to get the complete o... |
99 | 11 Dec 2014 @ 05:14 PST | Database | Topic | NVP Function | Hi Below is the query:
I am trying to understand how NVP Function works. I tried the below simple query
SEL NVP('100:Jugal#9004','100','#',':',1)
Output:
... |
98 | 26 Nov 2014 @ 05:24 PST | Database | Topic | JOIN INDEXES WITH PRIMARY INDEX | Hello All,
Why we cannot have JOIN INDEXES with UPI/USI. If there is a option to create a Join Indexes with UPI/USI, how can it be done.
Thanks
Jugal
|
97 | 26 Nov 2014 @ 12:06 PST | Database | Reply | GRAPHIC and VARGRAPHIC data type | Thanks For replying David. :)
|
96 | 21 Nov 2014 @ 02:57 PST | Database | Topic | Not able Insert LOB | Hello All,
I am trying to insert a image in the DB. Follow is the DDL:
CREATE TABLE DB.Sample3
(
ID INT GENERATED ALWAYS AS IDENTITY(START WITH 1 INCREMENT BY 1),
Image BLOB(9000)
);
&... |
95 | 20 Nov 2014 @ 07:47 PST | Database | Reply | GRAPHIC and VARGRAPHIC data type | I have never come across these data types. Please provide a link or an example. Which says how to use this data types.
|
94 | 18 Nov 2014 @ 07:21 PST | Database | Topic | GRAPHIC and VARGRAPHIC data type | Hello All,
How to use Graphic and Vargraphic data types. What is the purpose and need of these data type.
THanks in Advance
Jugal
|
93 | 16 Oct 2014 @ 11:44 PDT | Tools | Reply | BTEQ IMPORT EXPORT DATA | Hi Dieter,
I see all the 3 rows been exported and the TIMESTAMP being exported in a correct format.
Thanks
Jugal. |
92 | 16 Oct 2014 @ 06:58 PDT | Tools | Topic | BTEQ IMPORT EXPORT DATA | Hello All,
When i ran the below code, all the 3 rows got exported to a text file. From there on, im importing it in the same script. When i do so the 1st record of the exported data is not getting... |
91 | 07 Oct 2014 @ 08:27 PDT | Tools | Topic | Which utilities to choose when compared to TPT | Hello All,
On what basis does should a developer opt for TPT when compared to the other utilities
From the following which is the best to use in which situation:
TPT LOAD vs FASTLOAD
... |
90 | 02 Oct 2014 @ 06:51 PDT | Database | Reply | unable to obtain data value because the teradata database indicated that the data type is ambiguous | Hey Raja/Carlos,
I would have missed it, while copying the code.
Hey Tom,
I am using the TDExpress14.0.3_Sles10_4GB VMware Developer Version. N i am not aware of the Driver been us... |
89 | 02 Oct 2014 @ 03:44 PDT | Database | Reply | unable to obtain data value because the teradata database indicated that the data type is ambiguous | I am using 14.0.3 the VM developer version. I tried the below sample DDL:
CREATE MULTISET TABLE jugal.Employee,
FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
 ... |
88 | 02 Oct 2014 @ 12:35 PDT | Database | Topic | unable to obtain data value because the teradata database indicated that the data type is ambiguous | Hello,
1)I created a table with NUMBER(10) datatype.
When i ran sel * from table;
I got the following error:
unable to obtain data value because the teradata database indicated that the data ty... |
87 | 26 Sep 2014 @ 06:25 PDT | Database | Reply | Data redistribution | Hi Sennet,
Check the difference in the type of operation your performing. Ur creating a SET table with just the schema for which u could see the EXPLAIN PLAIN.
Whereas when u create the volatile ... |
86 | 25 Sep 2014 @ 09:23 PDT | Database | Reply | Select Statement inside a case statement | Hi Raghav,
The above case statement looks fine. If would give the result as 'Data is Available' if the count(*) > 0.
Thanks
Jugal
|
85 | 24 Sep 2014 @ 08:56 PDT | Database | Reply | qualify statement with 'case' in teradata | Hi Anoop,
Performance tuning or issues relating to performance are better understood when applied. Run the query as u ve suggested above check the explain plain,DBQLogTbl which would give u a bett... |
84 | 24 Sep 2014 @ 06:09 PDT | Database | Reply | Rows should be appended to a column in teradata | Hi,
I hope the below query serve's ur purpose:
SEL name,DESCRIP r FROM(select a.name name,
(CASE WHEN SUBSTR(a.desc1,0,length(a.desc1)+1)<>SUBSTR(b.desc1,0,length(b.desc1)+1) THEN trim... |
83 | 24 Sep 2014 @ 05:29 PDT | Database | Reply | Timestamp format | Hi Shardul,
You could also try the below query,
SEL CAST(CAST(CURRENT_TIMESTAMP AS FORMAT 'YYYY-MM-DD b HH:MI:SS') AS TIMESTAMP(6)) - INTERVAL '1' MINUTE * (EXTRACT(MINUTE... |
82 | 24 Sep 2014 @ 01:05 PDT | Database | Reply | Timestamp format | Hi Shardul,
what i understand from ur question is, u want to display a timestamp like 2011-09-08 15:10:00.000000.
You could simply run the query as given in below format.
SEL TIM... |