#DateForumTypeThreadPost
2215 Feb 2010 @ 09:05 PSTDatabaseReplyCapturing ERRORCODE in BTEQ from stored Procedureif no error capturing routine specified in the store procedure, the error code will be returned by default in store procedure.
2105 Feb 2010 @ 06:54 PSTDatabaseReplybteq script and password policyuse some creative scripting, you can get around such issue. Basically, the idea is simple, since .run command requires a file, you can provide the command with a named pipe, and the script will fee...
2004 Feb 2010 @ 08:30 PSTDatabaseReplyOptimizer expert, please correct my under standing hereStep 22.1 redistribute by TMP.puap1.fam_frnd_ind_nbr generated the spool #24 Step 23, spool #24 and #23 joined row hash match scan merge join condition ("prepd_srv_loc_cd =LOC_IND_CD") Notice tha...
1903 Feb 2010 @ 10:53 PSTDatabaseTopicOptimizer expert, please correct my under standing hereThe way I thought Teradata always work is trying to keep things "local" to amp. Therefore, if A Join B on column C , the table A and Table B will be retrieved with not null on C and redistribute on...
1810 Dec 2009 @ 09:53 PSTDatabaseTopicwhere would I find information about PDCRPDCR seems going to be the new replacement for PMCP. Where would I find information for the schema/content/document for this topic? any suggestion is helpful.
1722 Oct 2009 @ 04:13 PDTTeradata ApplicationsReplyexception handling in Store ProcedureDavid, thanks a lot, actually I found the problem, the error message I saw was not mapped right. I was only using sqlstate to map message, actually I should use sqlcode to look for details of infor...
1608 Oct 2009 @ 11:01 PDTTeradata ApplicationsTopicexception handling in Store ProcedureHow to handle exceptions raised within the cursor iteration? Basically what I have here is a For cursor and I want to handle the exception and exit the for loop. The exception handling are MULTIPLE...
1530 Sep 2009 @ 08:24 PDTDatabaseReplyDBQLSQLTbl's logging timenah.. forum is not dead.. it is just dbql logging timestamp are nortorius for this issue and teradata might be embarassed to confirm it:) LOL...
1408 Aug 2009 @ 08:24 PDTDatabaseReplySql to delete duplicates in Teradatadelete from table a where row_Number() over (partition by col1 col2 col3....coln) > 1
1305 Aug 2009 @ 08:55 PDTToolsReplyMLOAD with secondary indexI will use fastload and ANSI MERGE statement to handle the update/insert/upsert operation. this can help you avoid the index maintenance. Well, with that said, if the update operation involves larg...
1205 Aug 2009 @ 08:48 PDTToolsReplyTeradata Eclipse Plugin problemGreat, thanks for prompt response, It works fine now.
1105 Aug 2009 @ 01:55 PDTToolsReplyTeradata Eclipse Plugin problemAnother bug: when click crate user from the pop up menu, here is the error shows in the log org.eclipse.core.databinding.BindingException: converter does not convert to type class org.eclipse.swt....
1005 Aug 2009 @ 01:41 PDTConnectivityReplySSO Integration through site minder or LDAPCheck the Teradata Security Administration pdf in documentation set, TeraGSS package on Teradata node can be configured to accept LDAP/Kerbros/TD2 authentications. Once enabled LDAP authentication ...
905 Aug 2009 @ 01:18 PDTToolsTopicTeradata Eclipse Plugin problemOpenning SQL Scrapbook triggered the following error: Eclipse: 20090621-0832 Data Tools: 1.6.2 TD Plugin : 13.0.0.1 ava.lang.NoClassDefFoundError: org/eclipse/datatools/sqltools/routinee...
805 Jun 2009 @ 09:43 PDTUDAReplyuse teradata table field values in shell script?#/bin/kshVAR1=tableabteq<< EOD.logon ...select * from $VAR1;EOD
720 May 2009 @ 10:23 PDTUDAReplyPerformance issue with the querychange primary index to those columns in group by
612 May 2009 @ 09:54 PDTUDAReplyTeradata SQL Assistant / Database Explorer Treegrant select on dbc.databases;grant select on dbc.columns(x)grant select on dbc.tables(x)
509 Feb 2009 @ 03:53 PSTJobsReplyTeradata DBA Needed - Can work in MD, FL, GA, COhow about Texas>?
422 Apr 2008 @ 11:39 PDTUDAReplyCascading Rolesno such thing in teradata, however, you can generate grant statement by using SELECT 'GRANT BASE_USER_ROLE TO ' ||TRIM(DATABASENAME) ||';' FROM DBC.DATABASES WHERE OWNER = 'A';
327 Mar 2008 @ 09:57 PDTUDAReplyPerformance Tuningtry to cheat the optimizer using left join and push the rightside col is not null in the where clause to mimic a inner join. Using this approach you can "pin-down" the join order and try to elimin...
224 Mar 2008 @ 11:11 PDTUDAReplyC program interface for Teradatait is always a good idea to use a well know technology to build your application, especially when you have requirement to distribute your apps to a lot of users. ODBC is a well established technolo...
115 Dec 2007 @ 03:53 PSTToolsReplyUpdating Teradata Compiler and Linker Paths (cufconfig -f ) - HELP REQUIREDwhat about visual studio express 2008?After setting the registry value cufconfig returns correct value, but the create procedure returns error 5863: Problem encountered during linking phase of OBJ...

Pages