All forum activity

#DateUserForumTypeThreadPost
5841714 Jul 2016 @ 12:01 PDTjyanConnectivityTopicSQLDriverConnect works fine while SQLDriverConnectW gives mysterious error messageHi, We're building data analytics software on Linux and trying to bring in support for Teradata. We've followed everything in the ODBC Driver for Teradata User Guide(Release 15.10). Indeed...
5841613 Jul 2016 @ 11:25 PDTJohannes VinkToolsReplyTPT deadlock Issue.15.00/15.10 has several improvements around locking for TPT: dbc.accessrights has another PI and there is the partition level locking. I strongly suggest that you familiarize yourself with the new...
5841513 Jul 2016 @ 10:58 PDTRATTLESKINDatabaseReplyNeed to generate a row number like columnFor solution to youre query 1. 2nd question is not clear to me SELECT LOCATION, ORDER_ID, CLASS, DATE, ROW_NUMBER() OVER (PARTITION BY  LOCATION, ORDER_ID  ORDER BY LOCATION, ORDER_...
5841413 Jul 2016 @ 10:40 PDTsuhailmemon84ToolsReplyTPT deadlock Issue.Hi Harsh, We haven't done the TPT upgrade yet. We're scheduled to go to Teradata version: 15.10 in next few days. It appears that when we upgraded our Test system to 15.10, the # of deadlo...
5841313 Jul 2016 @ 02:22 PDTN_RaghuConnectivityReplyOLEDB Driver of TD15.10Thank You Fred... Is there any official reference that you could point me to? I would like to share this with my team.
5841213 Jul 2016 @ 02:10 PDTnagaswathi527GeneralReplyinterview helpPlease email to talk2peddi@gmail.com
5841113 Jul 2016 @ 01:46 PDTFredConnectivityReplyOLEDB Driver of TD15.10TDOLEDB has been discontinued. The final release was 15.0.
5841013 Jul 2016 @ 01:35 PDTfgrimmerTeradata StudioReplyTD Studio data transfer unexpected tokenGarrett, I will send you an email. Thanks.
5840913 Jul 2016 @ 01:17 PDTsagar_DatabaseReplyNOT IN and nested queryYour subquery is returning NULL values, causing the entire query to fail.(i.e COL11 in table11 has NULL values) The below query should return what you are expecting. Sel distinct col1 from tabl...
5840813 Jul 2016 @ 12:26 PDTAROLD001DatabaseTopicNOT IN and nested queryHi Developers, I have consistently used NOT IN on hard-coded static list of values in Teradat SQL Assistant and it has worked without any issues.   Sel distinct col1 from table1 where col...
5840713 Jul 2016 @ 12:02 PDTKoushik ChandraDatabaseTopicRegarding Teradata MigrationWe are planning to do a Teradata migration, the versions for source and target Tearadata is close (source Teradata version 15.00.02.02, though not sure about Target version yet). The migration is h...
5840613 Jul 2016 @ 11:36 PDTgarrett@data-design.comTeradata StudioReplyTD Studio data transfer unexpected tokenThere seem to be a number of issues.  I've attached 3 screen shots.  I've created a new table, xxx, to avoid confusion.  Here's my step by step: 1)  Tried the drag ...
5840513 Jul 2016 @ 11:00 PDTN_RaghuToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colorsI think I found what the issue was. On my system Tab colors are not working when the Application Style is set to "System default" in options->General. I changed it back to Windows...
5840413 Jul 2016 @ 10:36 PDTIvyuanToolsReplyFastload - Error on piom GET ROW: 64Hi, There was a similar issue and it is fixed in Dataconnector 15.00.00.003 and above. Please try to use 15.00.00.003 and above versions of Dataconnector and let us know if there is still issues. ...
5840313 Jul 2016 @ 09:37 PDTVgaDatabaseTopicNeed to generate a row number like column As per below data, I need to generate a rank or row number type column based upon the following scenarios:   1) For a Location-Order-ID combination, it should be a same number irres...
5840213 Jul 2016 @ 09:22 PDTfgrimmerTeradata StudioReplyTD Studio data transfer unexpected tokenGarrett, I created the two tables in separate Teradata Database systems, loaded the source table with 23 rows of data and left destination table empty. Then, in the Data Transfer perspective, dragg...
5840113 Jul 2016 @ 08:36 PDTfgrimmerTeradata StudioReplyNeed help on export file option in tereadata studio expressAbhilash, Make sure the extension on the Output File matches the File Type. For Excel (.xlsx) or Excel 97-2003 (.xls). There should be an error message at top of wizard indicating an error.
5840013 Jul 2016 @ 07:42 PDTToddAWalterDatabaseReply3899 Internal error in teradata SQL parserIt is really best to open a new incident with Teradata support. It is not possible to determine if this issue is the same as the one in the original thread without analysis of the details.
5839913 Jul 2016 @ 07:36 PDTToddAWalterDatabaseReplyextending MLPPI tablesBut it is not neccesary to drop and reload the table. Create the new table definition with the new partitioning, then use INSERT SELECT to move the data from the current table to the new one. INSER...
5839813 Jul 2016 @ 06:50 PDTAtardecerR0j0DatabaseReplyNeed recursive SQL code select mobile, calltime, max(calltime) over (partition by mobile order by calltime asc rows between 1 preceding and 1 preceding) calltime_previous, case wh...
5839713 Jul 2016 @ 06:41 PDTterradata.khalidpkJobsTopicTerradata developer opportunity in Toronto, CanadaHi Guys, I need Terradata developers in Toronto GTA area in Ontario, Canada. Please send me your resumes.
5839613 Jul 2016 @ 06:20 PDTArpan.RoyToolsReplyTPT output from ODBC includes Indicator Bytes?Hi Steve, The ErrorField is "AR_CTGRY_CDE_ACR". Below is the schema defination from tpt control file. SYS_ACR INTEGER, --- Column I changed from NUMBER(4) to INTEGER PRIN_ACR NUMBER(...
5839513 Jul 2016 @ 06:16 PDTdnoethDatabaseReplyextending MLPPI tablesYou can't use ALTER to add a new partitioning column, you must create a new table.
5839413 Jul 2016 @ 06:15 PDTAtardecerR0j0DatabaseReplyAny dynamic lookup concept in teradata? --For SCD-2 identifying columns are col1, col2, col4 select normalize col1, col2, col4, period( start_dt, end_dt ) from table1;  
5839313 Jul 2016 @ 05:40 PDTRATTLESKINDatabaseTopicAvoid all-row scan in driving table using NUSI Hi I am gettnig all-row scan even after using a secondary Index at the driving table. I am not sure if my approach is right , so please help me out here.   Sample snippets, we have ...

Pages