All forum activity

#DateUserForumTypeThreadPost
5881928 Jul 2016 @ 10:16 PDTindra91ToolsTopicQueries for Teradata Fast Export Utility We need to offload huge volume of data from a Teradata table to a network attached filesystem using the FastExport Utility. The database will be a standalone server while the Fastexport scri...
5881828 Jul 2016 @ 07:17 PDTshekar.srDatabaseTopicThe search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT I am trying to use Push down optimization on teradata database. while informatica is creating a merge sql, getting the error (The search condition must fully specify the Target table primary index...
5881728 Jul 2016 @ 06:47 PDTAVOTViewpointTopicCache database Replication has stopped working.Hi Techos, I enounter an issue in the dcs.log as "Cache database replication has stopped working".  Please read the little story behind what I have done. 1. I set up a cluster in ...
5881628 Jul 2016 @ 02:00 PDTmark123ConnectivityTopicQuerying teradata with UDF from Excel I have problem executing query accessing Teradata UDF from Excel. Query executes fine from SQL Assistant but when executed from Excel 2010 it fails and DBQL logs an error message. Query looks ...
5881528 Jul 2016 @ 11:27 PDTnaresh236Teradata ApplicationsTopicFast load failure with return code 12Hi All,   Recently we have upgraded from Teradata 14 to 15 since when we have started encountering an error in one of our fastloads. The issue is we have a variable length file which is del...
5881428 Jul 2016 @ 11:20 PDTmissgateDatabaseReplySet unix variable inside bteq Hi Srinivas,   There is possible use environment variables and have a "clean" script (bteq, tpt, or whatever.), perl are very useful.   Firs...
5881328 Jul 2016 @ 11:12 PDTabhishek.jadhavDatabaseReplyFind the list of active running queries through SQL I believe you can't directly get the list of sessions querying a particular database using MonitorSQLText,MonitorSession.  You will have to complete all the 3 steps mentioned above ...
5881228 Jul 2016 @ 09:01 PDTkvzDatabaseReplyFind the list of active running queries through SQLHi Abhishek, I want to get list of sessions which are doing query on particular database(xyz) How can we achieve this using MonitorSQLText , MonitorSession ??   Regards, kvz
5881128 Jul 2016 @ 08:57 PDTmullasciCloud ComputingTopicTD express 15.10 halting CPUs on ESXi 6 boxFor my convenience I converted the player/workstation image to an ESXi image. Everything works fine with one exception: from time to time I find theimage frozen and ESXi logs reports that the OS h...
5881028 Jul 2016 @ 08:33 PDTmullasciTeradata Database on VMWareReplyConfused over which VM to download@Fred: do you think it is doable to slightly revise the forum names? The way they are now can be fairly confusing.
5880928 Jul 2016 @ 08:24 PDTAtardecerR0j0DatabaseTopicROW_NUMBER - TIE-BREAKERHow row_number function gets tie-breaker when there are the same value for diferent rows of the order by list?
5880828 Jul 2016 @ 07:18 PDTssavoyeDatabaseReplySet unix variable inside bteqI meant to mention that the ". param_file_path" results in a error of " *** Error: Unrecognized command.".  I do believe this would be a much more elegant solution if ...
5880728 Jul 2016 @ 06:07 PDTArpan.RoyToolsReplyNeed Help regarding TPT ODBC OperatorHi Steve, Are there any other tuning technique we meed to apply apart from those mentioned above.   Thanks & Regards, Arpan.
5880628 Jul 2016 @ 05:57 PDTssavoyeDatabaseReplySet unix variable inside bteqI have seen a similar post here a couple times as to using this parameter file, yet I can't find any mention of it in the BTEQ manual, nor can I get anything like it to work.  Is this some...
5880528 Jul 2016 @ 05:34 PDTGlassToolsReplyHELP cannot display long field namesUse Column Dictionary Name or Column SQL name in the Help results.   Rglas
5880428 Jul 2016 @ 04:40 PDTac255034DatabaseTopicCursor select * with Fetch Next statementI am working on FETCH STATEMENT inside CURSOR. I need to convert a SQL server script into Teradata. -----------------------------------------------------------------------------------------------...
5880328 Jul 2016 @ 03:19 PDTSasi474GeneralTopicSelecting XML data (converting xml data to rows and columns)Hi, Trying to extract all the colums from below table  CREATE SET TABLE A,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,   &nb...
5880228 Jul 2016 @ 12:31 PDTabdul99UDAReplyCREATE NEW TABLE with COLUMNS FROM four QUERIES + CONSTANT FieldsHi am trying to create a simple table in teradata. my table has 4 colums and 2 rows  column1=No column2=Name column3=science column4=maths row1=1,Abdul,50,49 row2=2,Kumar,49,50 could a...
5880127 Jul 2016 @ 10:36 PDTadjrockConnectivityReplyConnectivity issues for SQL Assistant 15I am finding it impossible to install (or unistall) any working version of Teradata at this point on my Win7 64bit. I made the mistake to installing multiple versions and now I keep getting: &qu...
5880027 Jul 2016 @ 09:05 PDTzakywAnalyticsReplyQUERY IN ASTER Thanks a lot saeed :) 
5879927 Jul 2016 @ 08:59 PDTMZhangHadoopReplyTeradata connector points to old lib when runing TPT TDCH to import from Teradata to HadoopOK, further investigation shows that the pre-existing TDCH 1.3.4 i.e. /opt/teradata/client/15.00/tbuild/jar/teradata- connector-hdp2.1.jar is part of installation of TPT release 15.00.00.05.  ...
5879827 Jul 2016 @ 07:04 PDTAhnMijuAsterTopicDownload Visualization of App Center - Multi Character setHi, In porject, I use the Table visualizer and like to download the data. Our customer data is Han-gule and it is multi character set. If the data is english character then ok. But Han-gule ...
5879727 Jul 2016 @ 06:20 PDTsamirparmar79GeneralTopicSimilar Names SQL SQL to Extract Records Based on Approximate String Matching Hi We are on version TD 14 and I come from Netezza / Postgre(Redshift) background. I have been asked to extract a lo...
5879627 Jul 2016 @ 05:22 PDTauatospwToolsTopicHELP cannot display long field namesDoes anyone know how to let HELP in SQL Assistant to display field names longer than 30 char? I use Teradata 15 so the field names can be up to 128 chars long. However when I use HELP to list the ...
5879527 Jul 2016 @ 05:00 PDTthebizymanDatabaseReplyCOUNT () OVER (PARTITION BY) and DISTINCTI see alot of these posts are similar to what I need yet a bit different.  I'm trying to get a distinct PE_ID_ID and count the number of times date_created with the same hour, in this case...

Pages