All forum activity

#DateUserForumTypeThreadPost
5959401 Sep 2016 @ 12:19 PDTfirstcaptainTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsYes I am able to launch the Teradata Studio but when after creating a Connection Profile and trying to connect to it (using Teradata) just hangs at that point.
5959301 Sep 2016 @ 12:18 PDTSNguyenWFTeradata StudioReplyTeradata preferences for new connection profile type missingFrom what I can tell, there's no way to open a new SQL (non-Teradata) file. There is no entry such as File>New Wizards>SQL File.  I can get to New Wizards, but there's no SQL Fi...
5959201 Sep 2016 @ 11:54 PDTGlassGeneralReplyConverting varchar into timestamp sel cast(substr('2016-01-07T11:52:49.113Z',1,10)||' '||substr('2016-01-07T11:52:49.113Z',12,12) as timestamp(3)) for the first,  for the second you can use substr a...
5959101 Sep 2016 @ 11:25 PDTfeinholzToolsReplyTPT attributes SkipRows and SkipRowsEveryFileIn your data file, is the EOF on the same line as the last header record?  
5959001 Sep 2016 @ 11:22 PDTSubbu99DatabaseReplyHow to identify tables that have been Block-level compressed using SQLIn TD15.10, below SQL will reveal if there is BLC on the table. show stats values on <databasename.tablename>;   BLCPctCompressed > 0 in the answerset will indicate BLC is on.
5958901 Sep 2016 @ 11:17 PDTfeinholzToolsReplyfastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500."The delimiter must be a printable character. FastLoad does not support hex values.  
5958801 Sep 2016 @ 11:05 PDTfgrimmerTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsChristopher, Are you able to launch Teradata Studio or Teradata Studio Express and create the Connection Profile? If so, I don't think it is a JRE issue. What database are you trying to connect...
5958701 Sep 2016 @ 11:00 PDTfgrimmerTeradata StudioReplyTeradata preferences for new connection profile type missingSteven The JIRA is still open. We hope to have this resolved soon but I don't have a commit date. Make sure you open as a SQL File Editor for Oracle.  If you already have the SQL file...
5958601 Sep 2016 @ 10:46 PDTToddAWalterDatabaseReplybetween condition make bad execution planWhat is the result of select count(*) from  tbla where TheDay < '2014-08-01'?  Trying to exclude the rows in tbla that cannot match from the product join.   Is the desir...
5958501 Sep 2016 @ 10:36 PDTknowledgeDatabaseReplybetween condition make bad execution plan sel * from tbla a inner join tblb b on a.TheDay between b.SDay and b.EDay;   Hi Todd, there are no outer conditions to apply on the tbla, 450000000 rows, or...
5958401 Sep 2016 @ 10:32 PDTSNguyenWFTeradata StudioReplyTeradata preferences for new connection profile type missingFrancine, wondering what's the status of the JIRA? Also, I just set up a connection to an Oracle database for the first time.  I got the connection to work, and I can connect and run a sa...
5958301 Sep 2016 @ 09:38 PDT31_resuToolsTopicSQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter KeyHi TD Forum, I am running on TD Ver 14, and have SQL Assistant 15.00, and when I run a query that has a prompt for two dates to be inout bythe user, the paramter promts of something like: where d...
5958201 Sep 2016 @ 09:15 PDTaaibinderToolsReplyTPT Script - Import from TD into HDFS.Thanks, I got it. Just gotta put HadoopHost = 'default' in the target attributes and use the HDFS:://server in the FileName!
5958101 Sep 2016 @ 09:05 PDTfeinholzToolsReplyTPT and Windows PowerShellFrom the Powershell documentation, it looks like that would be the best solution to running TPT under Powershell. Even typing just tbuildexe.exe indicates the environment (and environment variable...
5958001 Sep 2016 @ 09:04 PDTToddAWalterDatabaseReplybetween condition make bad execution planWhat described above requires the product join, every row of b compared to every row of a. This is going to be expensive for a medium table joined to a large table.  Are you sure the...
5957901 Sep 2016 @ 08:41 PDTfeinholzToolsReplyTPT Script - Import from TD into HDFS.TPT provides samples in a "samples" directory where TPT is installed. Look in the directory called "userguide" inside "samples".  PTS00029 shows an example of r...
5957801 Sep 2016 @ 08:08 PDTknowledgeDatabaseReplybetween condition make bad execution plan Hi Dieter,   for every row in table b i have to check if the values of the field TheDay, this field have the dates continuous, is content between the fields SDay (Start Day) and EDa...
5957701 Sep 2016 @ 07:56 PDTaaibinderToolsReplyTPT Script - Import from TD into HDFS.Is it possible to ask for an example of this code? I am not finding it in the documentation anywhere and I've been looking. Please and thank you!
5957601 Sep 2016 @ 07:36 PDTkthumm11DatabaseTopicCreating a Dynamic YoY Date Range in Case Statement for Current Quarter QTDLet's say I want to find YoY QTD Q3 unique customers and today is 9/1/2016.  How do I make it so I do not need to manually need to update the bolded date ranges in the case when statement....
5957501 Sep 2016 @ 06:31 PDTkenwill77ConnectivityReplyExcel 2016 VBA ConnectionI found out that Microsoft is working on a patch that they expect to release Mid-September.
5957401 Sep 2016 @ 04:05 PDTjuanalfonsoDatabaseTopicI can't execute an SP that calls another SP inside Hello, I'm trying to execute a procedure (F_SEPARA_LETRAS_Y_NUMEROS) with another procedure called inside (F_QUITA_REPES) but I get the following error: CALL Failed. [3523] F_NOT...
5957301 Sep 2016 @ 03:07 PDTDinesh1975DatabaseReplyMAX SPOOL BY AMPThank you. Update space utility did the trick.
5957201 Sep 2016 @ 03:06 PDTDinesh1975ToolsReplybteq help neededThank you..
5957101 Sep 2016 @ 02:38 PDTdnoethDatabaseReplyUsing WITH Statement Modifier instead of Temp Tables?AFAIK it will be resolved in TD16.
5957001 Sep 2016 @ 02:20 PDTdnoethDatabaseReplyInsert taking longSET Table plus bad Primary Index ('3PCL','3PDM','3POR')?

Pages