#DateForumTypeThreadPost
28709 Apr 2013 @ 01:06 PDTDatabaseReplyVaried result with DBC.TableSize & DBC.DiskSpaceYou are comparing apples and oranges. 1: the max currentperm for an amp for a table in the database 'financial' 2: the max currentperm for an amp for the database 'financial'. HT...
28603 Apr 2013 @ 09:03 PDTGeneralReplyCEIL and FLOOR functionsThis functions are two of the new ones in TD14, (the all-new "Embedded Services System Functions") AFAIK there is no CEIL or FLOOR functions in TD13 (unless you code them in C as UDFs) C...
28502 Apr 2013 @ 11:52 PDTDatabaseReply"Replace" in Teradata - Only SQL statements ?"SQL Functions, Operators, Expressions, and Predicates". OREPLACE() Pag 720. Before you can use the embedded services functions, you must run the Database Initialization Program (D...
28402 Apr 2013 @ 06:41 PDTDatabaseReply"Replace" in Teradata - Only SQL statements ?TD 14 implements oReplace() as a native Teradata Function. HTH. Cheers. Carlos.
28327 Mar 2013 @ 09:24 PDTToolsReplyTPUMP for Active Ware housing Nishant: Since Version 14 TPUMP has access modules for JMS (libjmsam.so) and MQ's. Previous to that (v14) I only know about using TPT to read from queues... HTH. Cheers. Carlos.  
28227 Mar 2013 @ 01:53 PDTDatabaseReplyTIME (0) field converted to INTEGERUsing SQLA through ODBC perhaps? If so, check options DateTime Format. HTH. Cheers. Carlos.
28106 Mar 2013 @ 07:12 PSTDatabaseReplyRounding down decimalsAlso, if you are in Teradata 14, you can use TRUNC() and ROUND() (Oracle heritage, I'm afraid ;-) ) Cheers. Carlos.
28027 Feb 2013 @ 12:28 PSTTeradata ApplicationsReplyinserting string value in to tableSeenu: You'll have to escape the single quote between the '9' an the '-' : '...9'-"...' Cheers. Carlos.    
27925 Feb 2013 @ 01:33 PSTDatabaseReplyCalculating the actual query run timeRajeev:   DelayTime = The time a query was delayed by Teradata DWM.   Cheers. Carlos.
27818 Feb 2013 @ 04:07 PSTDatabaseReplyCalculating the actual query run timeRajeev:   FirstRespTime - StartTime = Total SQL Execution Time. FirstStepTime - StartTime = Parsing & DD Access Time (locks in DD can be shown here). HTH. Cheers. Carlos.
27715 Feb 2013 @ 05:15 PSTToolsReplyFAILURE 2673 SOURCE PARCEL LENGTH DOES NOT MATCH DATA THAT WAS DEFINEDYou might consider to change the oracle export strategy to someting like:   CONNECT usr_id/pwd set echo off set feedback off set heading off set linesize 32767 (or whatever fits your ...
27614 Feb 2013 @ 06:19 PSTDatabaseReplyProblem With High PJIPJI is CPU intensive operations indicator. As you say, you have a lot of CASEs, which may be at the botom of your problems. Complex operations may also be CPU intensive and show as high PJI. Oth...
27513 Feb 2013 @ 01:57 PSTGeneralReplyUsing Length Function ...LENGTH() is a function of the ODBC layer, not Teradata native. BTEQ uses CliV2, which is not ODBC, and hasn't these functions. Cheers. Carlos.  
27408 Feb 2013 @ 12:28 PSTDatabaseReplyDatabase access issueLionel: Check the VMware virtual network configuration. You should have chosen 'bridged' connections in order to allow other machines access the VM (and thus the database). HTH. Cheers.
27307 Feb 2013 @ 02:25 PSTDatabaseReplyhow to find the start dates from history Sunny: Maybe this approach will help you:   BTEQ -- Enter your SQL request or BTEQ command: SELECT * FROM YOUR_TABLE ORDER BY 1,2; *** Query completed. 8 rows found. 4 columns...
27206 Feb 2013 @ 08:05 PSTDatabaseReplyETL Process results in contention on Teradata table"Doesn't Teradata have row-level locks??" Teradata uses rowhash locks (whenever can be applied), which can be 'row-level' locks depending primarily on the Primary Index. The ...
27106 Feb 2013 @ 12:53 PSTAnalyticsReplyHow to not to skip a RANK ?Hi. You could try something like:   SELECT a.Store_Item, a.Sales, b.The_rank FROM YOUR_TABLE a, ( SELECT c.Sales , row_number() OVER (ORDER BY c.Sales DESC) The_Rank FROM ( SELE...
27004 Feb 2013 @ 03:04 PSTThird Party SoftwareReplyNumber Data type - Teradata 14 with Microstrategy 9.2.1 / 9.3Leandro: Check the compatibility matr¡ix. I'm not sure that MS 9.2.1 & 9.3 is certified to work with TD 14 yet. Cheers. Carlos.
26901 Feb 2013 @ 05:47 PSTTeradata ApplicationsReplyPlease help me suggesting a query to find 1.the scale of the column in teradata 2.the foreign keys of a table in teradata 3. ...1: SELECT DBC.COLUMNS. 2 & 3: SELECT  DBC.ALL_RI_PARENTS AND / OR  DBC.ALL_RI_CHILDREN. HTH. Cheers. Carlos.
26829 Jan 2013 @ 03:02 PSTToolsReplyDuplicate rows in MLoad?That's not totally correct. Fastload allows duplicate rows if loading into NOPI tables. Cheers. Carlos.
26717 Dec 2012 @ 01:01 PSTToolsReplyHow to convert Ordinal (Julian) Date to Calendar DateSorry for jumping in. Been tehre, done that. Wrote about the whole thing here: http://carlosal.wordpress.com/2009/07/14/importando-fechas-julianas-a-teradata/ (in spanish, as usual). HTH. Che...
26605 Dec 2012 @ 02:38 PSTDatabaseReplyDo not insert a record into a table with a foreign key.>>"How can we fix error on Teradata?"   Not using reserved words as column names?   Cheers. Carlos.  
26505 Dec 2012 @ 02:27 PSTDatabaseReplyEntity-Relation Model for Teradata QuerySrividhya You must define both the PK and the PI on the 'Indexes' window for the table. You can define the PK and uncheck the 'generate' check box (forward engineering won't c...
26426 Nov 2012 @ 07:33 PSTAnalyticsReplyFailure 2805 Maximum row length exceeded in table in abc in BTEQ when using SET operator.Sudeep: Can you post the result of EXPLAIN with VERBOSEEXPLAIN? Cheers. Carlos.  
26321 Nov 2012 @ 08:48 PSTDatabaseReplyReturning Values from Procedures>>"Is it possible to return values using Stored Procedures in Teradata?" Yes, with OUT IN/OUT parameters. HTH. Cheers. Carlos.

Pages