#DateForumTypeThreadPost
10625 Feb 2016 @ 11:54 PSTViewpointReplyUnable to start ViewPoint in FirefoxBelow 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...
10525 Feb 2016 @ 11:45 PSTViewpointTopicUnable to start ViewPoint in FirefoxHello 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...
10414 Feb 2016 @ 09:02 PSTDatabaseReplyPPI Dropping/Adding PartitionsThanks for replying Dieter.. :)
10313 Feb 2016 @ 11:13 PSTDatabaseTopicPPI Dropping/Adding PartitionsHello 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...
10213 Feb 2016 @ 10:14 PSTDatabaseReplySelect Columns for UPI,NUPI,USI and NUSIThanks For replying rupert. I went throught the document gave me a better understanding on the selection criteria.
10111 Feb 2016 @ 09:42 PSTDatabaseTopicSelect Columns for UPI,NUPI,USI and NUSIHello 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 ...
10010 May 2015 @ 08:38 PDTDatabaseTopicDifferent Output When ran a macro in Teradata Sql Assistant and Studio ExpressHello 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...
9911 Dec 2014 @ 05:14 PSTDatabaseTopicNVP FunctionHi 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: ...
9826 Nov 2014 @ 05:24 PSTDatabaseTopicJOIN INDEXES WITH PRIMARY INDEXHello 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
9726 Nov 2014 @ 12:06 PSTDatabaseReplyGRAPHIC and VARGRAPHIC data typeThanks For replying David. :)
9621 Nov 2014 @ 02:57 PSTDatabaseTopicNot able Insert LOBHello 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) ); &...
9520 Nov 2014 @ 07:47 PSTDatabaseReplyGRAPHIC and VARGRAPHIC data typeI have never come across these data types. Please provide a link or an example. Which says how to use this data types.
9418 Nov 2014 @ 07:21 PSTDatabaseTopicGRAPHIC and VARGRAPHIC data typeHello All,   How to use Graphic and Vargraphic data types. What is the purpose and need of these data type.   THanks in Advance Jugal
9316 Oct 2014 @ 11:44 PDTToolsReplyBTEQ IMPORT EXPORT DATAHi Dieter, I see all the 3 rows been exported and the TIMESTAMP being exported in a correct format. Thanks Jugal.
9216 Oct 2014 @ 06:58 PDTToolsTopicBTEQ IMPORT EXPORT DATAHello 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...
9107 Oct 2014 @ 08:27 PDTToolsTopicWhich utilities to choose when compared to TPTHello 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 ...
9002 Oct 2014 @ 06:51 PDTDatabaseReplyunable to obtain data value because the teradata database indicated that the data type is ambiguousHey 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...
8902 Oct 2014 @ 03:44 PDTDatabaseReplyunable to obtain data value because the teradata database indicated that the data type is ambiguousI 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,  ...
8802 Oct 2014 @ 12:35 PDTDatabaseTopicunable to obtain data value because the teradata database indicated that the data type is ambiguousHello, 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...
8726 Sep 2014 @ 06:25 PDTDatabaseReplyData redistributionHi 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 ...
8625 Sep 2014 @ 09:23 PDTDatabaseReplySelect Statement inside a case statementHi Raghav, The above case statement looks fine. If would give the result as 'Data is Available' if the count(*) > 0.     Thanks Jugal
8524 Sep 2014 @ 08:56 PDTDatabaseReplyqualify statement with 'case' in teradataHi 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...
8424 Sep 2014 @ 06:09 PDTDatabaseReplyRows should be appended to a column in teradataHi, 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...
8324 Sep 2014 @ 05:29 PDTDatabaseReplyTimestamp formatHi 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...
8224 Sep 2014 @ 01:05 PDTDatabaseReplyTimestamp formatHi 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...

Pages