#DateForumTypeThreadPost
7205 Mar 2014 @ 07:27 PSTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problem CREATE VOLATILE TABLE T ( SHOP INT, ITEM INT ) UNIQUE PRIMARY INDEX(SHOP,ITEM) ON COMMIT PRESERVE ROWS; INSERT INTO T VALUES (1,100); INSERT INTO T VALUES (1,101); INSERT INTO T V...
7124 Sep 2013 @ 09:01 PDTConnectivityReplyODBC Connectivity Problem Open C:\Windows\SysWOW64, locate file odbcad32.exe ---  configure your odbc32 connection string there. 
7024 Sep 2013 @ 08:56 PDTConnectivityReplyODBC DRIVER COULDN'T BE LOADED check the bit version of data direct (64/32),  download the correct bit version of Teradata odbc/gss/icu   show your odbcini file.   
6924 Sep 2013 @ 08:51 PDTConnectivityReplyInformatica 9.1.0 64 bit AIX and TPT 14the simpler solution is to build a shell script called tbuild and put it in /usr/bin basically the tbuild shell script will do the following: 1. set the library path  2. pass the #@ to the ...
6824 Sep 2013 @ 08:46 PDTConnectivityReplyNo suitable driver found for jdbc issue even after downloading the teradata v 14 jdbc driversLOGMECH=LDAP Here is a code I developed.    public class TeraConTT { private String tdp; private String username; private String password; private String conMech = "LDAP...
6724 Sep 2013 @ 08:39 PDTDatabaseReplyI'm trying to automate a process in Teradata, if the count is greater than 5 then do not execute the below statementcheck Teradata BTEQ in the product manual. 
6621 Sep 2013 @ 12:52 PDTExtensibilityReplyXML Service version 13 error and XML service 14 installation failgot it... the 14.0.0.0 package still has that typo on the file name _U /_u.    I think pcl -send is not documented well. the file is under lib/TD12 and these shared libraries should be...
6503 Jul 2013 @ 12:06 PDTExtensibilityTopicXML Service version 13 error and XML service 14 installation failI noticed this error for long time for version 13.0 and surprisingly nobody complained or try to fix. . When you try to install the XML service , you will see an error complaining verify_as_shred_u...
6420 Feb 2013 @ 08:13 PSTToolsReplyUsing FastExport with Teradata JDBC DriverTomnolan,  about the fast export jdbc connectivity. is there any detailed instructions how to get the row count before fetch by not using select count(*)? When using native Fastexpoprt utilit...
6304 Dec 2012 @ 07:41 PSTDatabaseReplyHow to install external UDF libraries on Hot Standby Node (HSN)?Refer to the orange book of UDF (search Teradata database user defined function User's guide) section 2.2.3.3 Registration process for Packages.  You can compile your code to .so (sahred...
6209 Mar 2012 @ 01:48 PSTDatabaseReply13.10 upgrade...CPU hog? one thing do need to pay attention is the Stats version. You may need to refresh all stats on the table so that the optimizer will be able use the stats info.   
6121 Feb 2012 @ 11:12 PSTToolsReplyProblem using RowErrFileName   RowErrFileName not quite working as it is explained int he documentation. the file reader quit right after hitting the error row  (row #2 with extra delimiter)   ...
6014 Jun 2011 @ 08:01 PDTDatabaseReplyPT API versus Fastloadcheck out the link here with very detailed discussion and my comments http://developer.teradata.com/tools/articles/use-tpt-to-move-data-without-landing-the-data-to-disk#comment-14221
5903 Jun 2011 @ 08:56 PDTDatabaseReplyNeed help in Optimizing query to fix spool space issuetry this: DIAGNOSTIC HASHSTATSPART ON FOR SESSION; then run your query within the same session
5822 Feb 2011 @ 11:13 PSTUDAReplyExclusive Lockyou can use this approach: bring your data into an empty staging using fastload Then MERGE INTO TARGETTABLE USING FASTLOADSTAGING ON () WHEN MATCHED THEN INSERT.. .WHEN NOT MATCHED THEN UPDATE .....
5722 Feb 2011 @ 11:09 PSTDatabaseReplyInner join on multiple Columns best way?(It's a bit urgent)Benefit of approach I adopted is to have ONE redistribute step and one join step instead of potential 20 redistribution steps and 20 joins,. and you can compare the performance by testing both ...
5622 Feb 2011 @ 11:07 PSTDatabaseReplyInner join on multiple Columns best way?(It's a bit urgent)SELECT ... FROM TABLE A INNER JOIN (SELECT COL1 AS JOIN_COL, B.* FROM TABLEB B UNION SEL COL2 AS JOIN COL, B.* FROM TABLEB B ..... SEL COL20, B.* FROM TABLEB B ) ON A.COL1 = B.JOINCOL
5518 Feb 2011 @ 12:01 PSTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentgive it a try, if it blows out... LOL... at your own risk. typically this type of operation is not relational and I would not use SQL to do it. .
5418 Feb 2011 @ 12:00 PSTAnalyticsReplyrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentCREATE RECURSVIE VIEW REC_VIEW AS (CONSOLIDATE, ROLLUP, PLAN) AS( SELECT CONSOLIDATE, MIN(PLAN) , MIN(PLAN) FROM MYTABLE UNION ALL SELECT B.CONSOLIDATE, B.ROLLUP||','||A.PLAN, A.PLAN FROM MY...
5318 Feb 2011 @ 11:28 PSTToolsReplyWho can explain TPT instance count and its detailsfor those who are intersted to find the answer, please refer to here: http://developer.teradata.com/tools/articles/use-tpt-to-move-data-without-landing-the-data-to-disk#comment-14221
5218 Feb 2011 @ 07:57 PSTToolsTopicWho can explain TPT instance count and its detailsIn TPT apply clause, you can specify number of instances used for each operator. For example APPLY ('INSERT INTO TARGET TABLE (COL1, COL2) VALUES (:COL1, :COL2);') IGNORE DUPLICATE ROWS TO OPER...
5117 Feb 2011 @ 07:45 PSTGeneralReplyUse queue table to manage asynchronous process correction.. in the wait.bteq .LABEL iamdone .REMARK "SELECT AND CONSUME THE ROW AFTER PROCESS COMPLETE" -- dong nothing here, just a place holder .LABEL ENDSCRIPT This endscript label exists...
5017 Feb 2011 @ 07:36 PSTGeneralTopicUse queue table to manage asynchronous process Earlier last year, there was a post on this forum asking loop function in BTEQ, this post will also show a trick how to "mimic" a loop using BTEQ. Recently, I encountered a particular issue in ...
4914 Feb 2011 @ 02:15 PSTToolsReplyhow to load multiple files in fastloadTPT multiple reader and apply to the same writer. try that out.
4814 Feb 2011 @ 12:43 PSTUDAReplyI need assistance on modify tableCREATE NEW_TABLE (IDENTIY COLUMN, REST OF COLUMNS) PRIMARY INDEX (...); INSERT INTO NEW_TABLE (COLUMN NAMES NOT INCLUDING ID COL) SELECT COL1, COL2 COL3....; then you are done.

Pages