#DateForumTypeThreadPost
29310 May 2013 @ 12:15 PDTData ModelingReplyCan Teradata display the Quarter value of a date?Mark: You can calculate the quarter from dates as ((CAST(EXTRACT(MONTH FROM fecha) AS BYTEINT)-1)/4)+1    BTEQ -- Enter your SQL request or BTEQ command: SELECT DATE, ((CAST(EXTRACT...
29226 Apr 2013 @ 03:40 PDTAsterReplyTeradata Aster: Transfer files from local host to VMYou ought to check the virtual network configuration for your VM. The NAT/BRIDGED/HOST ONLY, ipconfig / ifconfig , masks... It seems to be a VMware issue, not a Teradata one. Cheers. Carlos. &n...
29125 Apr 2013 @ 11:53 PDTAsterReplyTeradata Aster: Transfer files from local host to VMYou can use FTP/SFTP or (maybe better for your needs) enable the 'Shared Folder' option in VMware player. HTH. Cheers. Carlos.
29011 Apr 2013 @ 12:17 PDTDatabaseReplyTeradata DBLinkHi joe. TD14.10 is expected to bring dblinks (sort of). Also, there are some C-written UDFs that can mimic the dblink functionality. Cheers. Carlos.
28911 Apr 2013 @ 12:13 PDTDatabaseReplySession to Node MappingHi again. Adding to the excellent explanation by mr. Nolan, you can have more than one PE per node (as a matter of fact, this is the usual case). Same with gateways. Both are vprocs (software impl...
28810 Apr 2013 @ 07:40 PDTDatabaseReplySession to Node MappingPrakash. You may take a look at Laddered Concurrent Connect (LCC). This seems to be what you are after... HTH. Cheers. Carlos.
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.

Pages