All forum activity

#DateUserForumTypeThreadPost
1403603 Dec 2009 @ 11:14 PSTandrew_jmdataDatabaseTopicMacros - Create tableHi - I have a very large chunk of code that accumulates data from relational tables over the past 25 months worth of data. I wrote the code to test against 6 months data which works fine. When I ...
1403503 Dec 2009 @ 10:53 PSTmwardenDatabaseReplyMultiple DDL statements receives syntax errorThank you. I was assuming it was a syntax problem, because that's what the error sounded like, so I would have never figured this out. There is no serial vs. parallel execution option that I can f...
1403403 Dec 2009 @ 08:26 PSTMohana GopalDatabaseReplyCreate Table Primary key & Primary IndexThanks for your reply..I have to mention explicitly the primary key is not null.when I use your code it shows the following error:Failure 3706 Syntax error: PRIMARY KEY Column(s) must be NOT NULL. ...
1403303 Dec 2009 @ 06:39 PSTpawan0608DatabaseReplyAdd minutes to timestampjust change thisset v1 = current_timestamp + CAST(v_in AS interval minute) ;
1403203 Dec 2009 @ 06:33 PSTrahulsiDatabaseReplyAdd minutes to timestampi was using the Integer input variable initially, but was getting the same syntax error.I assume teradata expects minutes in ' '
1403103 Dec 2009 @ 05:42 PSTpawan0608DatabaseReplyAdd minutes to timestampwhy you are declaring v_in1 as varchar(10); you simply need to cast input paramete v_in as INTERVAL MINUTE in your expression
1403003 Dec 2009 @ 05:38 PSTjayashreeAnalyticsReplyquery that provides hierarchyWe are using with recursive to display the metric hierarchy but its not showing up in correct sequence. Plz let us know if you have found any solution.
1402903 Dec 2009 @ 05:34 PSTrahulsiDatabaseReplyAdd minutes to timestampThanks , it is working fine when run on bteq , but when i try to put it into procedure .. it fails to get compile. pl advise***************************SPL1027:E(L12), Missing/Invalid SQL statement'...
1402803 Dec 2009 @ 04:37 PSTpawan0608DatabaseReplyAdd minutes to timestampSEL CURRENT_TIMESTAMP + INTERVAL '10' MINUTE
1402703 Dec 2009 @ 04:32 PSTrahulsiDatabaseTopicAdd minutes to timestampQuite new to Teradata and finding a bit difficulty handling date/timestamp.i know it would we quite simple but unable to find relevant links over netHow to add 10 minutes to current timestamp in TD...
1402603 Dec 2009 @ 02:31 PSTThiruToolsReplyBTEQ Related queryHi,Have you use the REPEAT statement in between your IMPORT AND USING statements? Sample BTEQ is given below.LOGON demotdat/thiru,thiru;.IMPORT VARTEXT ',' FILE=C:\ABC.TXT;.REPEAT *USINGemp_no (VAR...
1402503 Dec 2009 @ 02:12 PSTAbhisekUDATopicRaise Error and Return value with in a stored procedureHi,I am trying to convert Stored procedure from Sybase to Teradata. Sybase has the option to raise error as well as return 0 or 1 for (success or failure).The scenario is as follows,1) SP1 2) SP2C...
1402403 Dec 2009 @ 12:38 PSTpawan0608DatabaseReplyCreate Table Primary key & Primary Indexyou don't need to specify UNIQUE PRIMARY INDEX clause in CREATE TABLE statement, it'll automatically create UPI on PK Column(s).CREATE SET TABLE TDUSER.contact ,NO FALLBACK ,NO BEFORE JOURNAL,NO AF...
1402303 Dec 2009 @ 12:18 PSTrahulsiDatabaseReplyEquivalent for db2 Chr function to handle line feed and tabI tried this , but it teradata for chr(10) and (9) , its just converting it as blank spcae ' '******* DB2 **********db2 " select cast(replace ('rahul','h',chr(10)) as char(20))||cast(replace ('rahu...
1402202 Dec 2009 @ 11:04 PSTsunitha_cvToolsTopicBTEQ related queryHi,Please let me know if you need any clarification regarding my yeterdays post.Regards,Savitha C V
1402102 Dec 2009 @ 09:16 PSTrajivgupta1107ConnectivityReplyTeradata JNDI connectivitythanks a lot, it worked :)
1402002 Dec 2009 @ 07:19 PSTlins314159DatabaseReplyMultiple DDL statements receives syntax errorI'm not familiar with Teradata Administrator, but I can reproduce your error in Teradata SQL Assistant. This is happening because you're executing the statements in parallel.Try running this in SQL...
1401902 Dec 2009 @ 06:30 PSTChinaGuyCloud ComputingReplyTD Express on MacBook Pro I think VM cannot work with bridged mode and wireless together because a security specification in 802.11 protocol says that a wireless adapter cannot send packets with a different MAC address tha...
1401802 Dec 2009 @ 05:23 PSTmwardenDatabaseTopicMultiple DDL statements receives syntax errorHello,I have whittled my example down to the following case that produces an error:DATABASE test;CREATE TABLE BUSINESS_UNIT_DIMENSION( BUSINESS_UNIT_KEY NUMERIC(22,0) NOT NULL, PRIMARY KEY (B...
1401702 Dec 2009 @ 01:56 PSTtomnolanConnectivityReplyTeradata JNDI connectivityYour URL is not correct. It has 2 problems.stag/url=jdbc:teradata://10.20.26.212:1025/dbcThe first problem is the colon and port number. Do not put a colon and port number after the Teradata Databa...
1401602 Dec 2009 @ 01:30 PSTbobwilmesCloud ComputingReplyTD Express on MacBook Pro I'm using a wireless connection from my MacBook Pro to the Internet. The wireless security keys are working great from the Mac, but when I start the Suse Linux I am getting DHCP errors about the V...
1401502 Dec 2009 @ 08:16 PSTJimmDatabaseReplyEquivalent for db2 Chr function to handle line feed and tabset V_TEXT = oreplace (V_TEXT, 'abc;', '0a'XC) ;set V_TEXT = oreplace (V_TEXT, 'def9;', '09'XC);XC is hexadecimal value as a character
1401402 Dec 2009 @ 07:46 PSTMohana GopalDatabaseTopicCreate Table Primary key & Primary IndexHi,I am new to TeradataI have used the following code for creating new tableCREATE SET TABLE TDUSER.contact ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ...
1401302 Dec 2009 @ 06:15 PSTrajivgupta1107ConnectivityTopicTeradata JNDI connectivityHi,We have teradata12 installed on my machine. I am trying to connect to teradata from a java application. When i try to connect through JDBC, i can connect. But when we try to connect using jndi, ...
1401202 Dec 2009 @ 04:53 PSTrahulsiDatabaseTopicEquivalent for db2 Chr function to handle line feed and tabWe have code in db2 where it is replace particular pattern with line feed and tab using chr function. How to acheive the same in Teradata. In teradata i know we have oreplace function, but how to h...

Pages