All forum activity

#DateUserForumTypeThreadPost
5944525 Aug 2016 @ 05:05 PDTFredAnalyticsReplyRelease Lock from a TableIf you ROLLBACK / ABORT or COMMIT the transaction, then the locks are released. And in Teradata mode, a database error causes an automatic rollback before returning the error status to the client.
5944425 Aug 2016 @ 05:01 PDTFredToolsReplyTeradata 14.10 History Window GoneUnder Tools / Options / File paths tab, be sure the history file path exists, is writeable, and has space.  
5944325 Aug 2016 @ 04:51 PDTFredDatabaseReplyHow to grant all required privileges retained by DBC to my new admin user?WITH ADMIN OPTION means you can grant role membership to or revoke role membership from other users (or roles), or DROP the role. But a role initially conveys no database rights, you have...
5944225 Aug 2016 @ 04:49 PDTagnit.chatterjee1988DatabaseReplyWhen to use Join Index Thanks Samir for your reply.
5944125 Aug 2016 @ 04:17 PDTsiddarthyGeneralReplyinterview helpsiddarthy8@gmail.com mrsuryatej@gmail.com   can you please forward the document. Thanks
5944025 Aug 2016 @ 03:39 PDTfranceszhuDatabaseTopicHow to grant all required privileges retained by DBC to my new admin user?I created an administrative user "DBADMIN" from user DBC by following the standard best practice. The admin user will manager all the subsequent users and databases. However, I am not cle...
5943925 Aug 2016 @ 02:49 PDTSureshKTAnalyticsReplyQuery_Discussion_HELPHi All, I have a question on similar lines. I am trying to understand from Architecture presepctive how Teradata will behave for the below scenario. Any help would be appreciated. Especially expec...
5943825 Aug 2016 @ 02:27 PDTimgregduhToolsTopicSchemaLoader results? Views via EF to EDMX?Is there a way to get the SchemaLoader results? The cmd prompt it opens closes immediately and I cant seem to pause it to read what it output.  I cant tell what went wrong or what went right...
5943725 Aug 2016 @ 12:49 PDTfeinholzToolsReplyTPT Script - Import from TD into HDFS.As with any other TD-to-flat-file TPT scenario, you can use the Export-operator-to-DC-operator scenario. This will export data from Teradata and write to HDFS. Just provide the information for th...
5943625 Aug 2016 @ 12:22 PDTaaibinderToolsTopicTPT Script - Import from TD into HDFS.I've been searching for this in documentation all day, maybe someone knows this already. I have read that since version 15.0, it's possible to go from a TPT script directly into HDFS. Righ...
5943525 Aug 2016 @ 11:09 PDTteradatauser2DatabaseReplyWhen to use Join Index Hi, Different JI has different use. If you have a table and you want to join to another table on some other column (than current PI), then you should create a Single table JI on the column you joi...
5943425 Aug 2016 @ 09:50 PDTdnoethDatabaseReplyCase statement syntax change?There's no YEAR or MONTH function in Teradata, this is (deprecated) ODBC-syntax, which might be automatically replaced with valid SQL by the ODBC driver. In older releases of SQL Assistant...
5943325 Aug 2016 @ 09:38 PDTsiddarthyDatabaseReplyBest way to generate the Sequential numbers : CSUM or IDENTITY columns?Also do use ASC or DESC with the ORDER BY ;)
5943225 Aug 2016 @ 09:32 PDTagnit.chatterjee1988DatabaseReplyWhen to use Join Index Can anyone please help?
5943125 Aug 2016 @ 07:49 PDTcqhollonDatabaseTopicCase statement syntax change?I recently upgraded to Teradata SQL assistant v15.10 and teh database is version 14.00. All of a sudden I get a syntax error on this statement the error is  Failed 3706 Syntax error: expected...
5943025 Aug 2016 @ 07:22 PDTJonManGo42ToolsReplyTeradata 14.10 History Window GoneI have the same problem with SQLA 15.0. I have had access to the History window for as long as I have had SQLA installed. The other day, I closed the History window, and "Show History" is...
5942925 Aug 2016 @ 06:07 PDTanil_athalyeDatabaseReplyALTER TABLE on UNICODE character type issueThanks, It worked when I included all the attributes/constraints in the ALTER Table statement. Ani.
5942825 Aug 2016 @ 04:03 PDTjuanalfonsoDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBThanks! I downloaded and installed the Teradata Express 15.10 VM and It seems to be possible to install SAP DS here :) But on the other hand, I've fount that UltraVNC (to make a remote deskto...
5942725 Aug 2016 @ 03:12 PDTbhushan.koliConnectivityTopicTeradata performance mointoring for each querry Jmeter testplanHi, I am connecting teradata db (located on remote location) from my local machin through  jmeter 3.0 ,and my testplan contains 20 querries and i want to measure performance (cpu,memory) fo...
5942625 Aug 2016 @ 02:01 PDTGhaliaToolsReplyZero records are fetching when using where statement in TPTHi,   After using LOCK TABLE MY_TABLE EXCLUSIVE I have an update request Then , I want to add something like RELASE LOCK from MY_TABLE after the update, in case of fail. Is it possible...
5942525 Aug 2016 @ 12:13 PDTkrishna1985ToolsTopicMULTILOAD BUFFER ERROR!!! urgentHi All,   I am trying to load the 8 mil rows into the target table and when I try to insert into target table then I get the below issue   * 16:46:18 UTY1802 Processing Import Sequ...
5942424 Aug 2016 @ 11:33 PDTG787010GeneralReplyinterview helpHi, Could you please share the questions related to FSLDM?   Thanks in Advance, Suwarna S Mail:swarna.apr13@gmail.com
5942324 Aug 2016 @ 10:03 PDTkamlesh114DatabaseReplyPPI  CREATE MULTISET TABLE SUPPORTDB.TABLE1 (EMPNO INT,E_NAME VARCHAR(100),JOIN_DATE DATE ) UNIQUE PRIMARY INDEX (EMPNO) PARTITION BY RANGE_N (JOIN_DATE BETWEEN '2015-01-01' AND ...
5942224 Aug 2016 @ 06:36 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityI can see why it would be important to preserve existing behaviour, and I think the approach of using a connection parameter as you've described would work well.
5942124 Aug 2016 @ 02:17 PDTdnoethDatabaseReplyODBC TimeStamp See if this works. On a session level set the timezone to your local daylight saving timezone: SET TIME ZONE 'America Brazil'; and then remove the '-00:00' and cast like this...

Pages