#DateForumTypeThreadPost
4319 Feb 2015 @ 04:25 PSTDatabaseReplyPerformance : ROWID join after JI hitJust FYI that Similar behaviour is observed if i hit a SI. The rowid join takes a long time to complete.
4219 Feb 2015 @ 01:10 PSTDatabaseReplyPerformance : ROWID join after JI hitHi , The statistics are updated on participating objects.    
4116 Feb 2015 @ 12:59 PSTDatabaseTopicPerformance : ROWID join after JI hitHi All, I am trying to debug a query which is taking a lot of time. Following objects are involved in the query :   person_mst table : person_id , first_name , last_name , age , a...
4015 Oct 2014 @ 08:33 PDTConnectivityTopicPerl Script : Fetching CLOB ColumnsHi All,   I have a perl script that calls a sp in TD. The SP returns rows where each row has 4 clob columns. I am using the following code scrippet to fetch the row and facing issue. my ...
3907 Oct 2014 @ 08:59 PDTDatabaseReplyVariables In Custom SQL BlockFollowing approach to pull variables in perl and substitute to prepare next statement and execute. Couldn't find any other option here. Afraid that TD was unable to resolve PPI in such cases.
3803 Oct 2014 @ 07:47 PDTDatabaseReplyVariables In Custom SQL BlockHi, 1. I tried the volatile table and then joining it in my query. Doesn't leverage PPI. 2. doing back and forth in perl/bash. Certainly do able. Concern with that is i have around 150-200 sq...
3703 Oct 2014 @ 10:22 PDTDatabaseReplyVariables In Custom SQL BlockHi, 1. The PPI gets leveraged if the same variables are hard coded. 2. Even when i put my sql statements in a stored procedure and "declare variables and set them" , PPI is leveraged. ...
3602 Oct 2014 @ 08:13 PDTDatabaseReplyVariables In Custom SQL BlockHi, Thanks for your response. 1. I cannot declare a new variable because i am not in a stored procedure. It is a series of SQL statements called from perl script. 2. The derived tables concept a...
3502 Oct 2014 @ 04:02 PDTDatabaseTopicVariables In Custom SQL BlockHi All, I am working on a application that prepares a dynamic sql blocks for execution. The application is written in perl which prepares the set of sql statements. Here is an example : inser...
3426 Jul 2014 @ 07:18 PDTToolsReplyTPT : Suppress or Redirect stdout/stderr logsPeople, thanks for the inputs.
3325 Jul 2014 @ 09:32 PDTToolsReplyTPT : Suppress or Redirect stdout/stderr logsNopes, Jokes aside here. :) I am loading 550+ tables and this was just a snapshot of some logs that are written by TPT. 50+ lines for every job, It seems wasteful at times and i am more keen to k...
3225 Jul 2014 @ 05:41 PDTToolsReplyTPT : Suppress or Redirect stdout/stderr logsHi, I was able to redirect to a log file using a standard redirect unix operator tbuild > xyz.log However, just wondering if TPT has some log tracel level implementation to prevent this level...
3125 Jul 2014 @ 03:50 PDTToolsTopicTPT : Suppress or Redirect stdout/stderr logsHi, I am using TPT to load an extract. The job is running fine but it prints a lot of statements to the stdout of unix. Example : Job end: Mon Jul 14 10:08:43 2014 Job start: Mon Jul 14 10:...
3009 Apr 2014 @ 08:59 PDTToolsReplyBTEQ Import Invalid Date IssueHi, Thanks for the comments. I considered the following approach : 1. Get all data exported from source table to a play table where all columns are in varchar format. 2. Then transform the requ...
2928 Mar 2014 @ 11:28 PDTToolsTopicTPT : Infrastructure Setup ErrorsHi All, I am trying to run a TPT script and facing the following series of errors : TPT_INFRA: TPT01155: Error: Infrastructure setup for the Parallel Task Manager failed TPT_INFRA: TPT02057:...
2828 Mar 2014 @ 11:21 PDTToolsTopicBTEQ Import Invalid Date IssueHi All, I am trying to port data from a flat file to TD via BTEQ. The table definition is : CREATE MULTISET TABLE _module_execution_log ( system_id INTEGER, process_id INT...
2708 Mar 2014 @ 09:34 PSTDatabaseReplyTeradata Express for WIN 32 BITHi All, After reading this discussion and all support from the posts; i was able to setup TD on my personal laptop. Wrote a post of my experience here :  http://allzhere.in/2014/03/09/terad...
2628 Feb 2014 @ 09:27 PSTDatabaseReplyChange One Row Data To Multiple Rows.You can try to iterate through rows from first table and split the rows by ## and insert them in a separate table. I did this in Sybase. The ready made functions should be doing something on simila...
2505 Feb 2014 @ 10:51 PSTTeradata StudioReplyTeradata Eclipse Plugin : Error With LDAP ConnectivityHi, The escape character suggestion worked for me. I was able to login. Thanks....
2403 Feb 2014 @ 11:44 PSTTeradata StudioReplyTeradata Eclipse Plugin : Error With LDAP ConnectivityHi, Thanks for your inputs. I had already tried that before posting. However, it gave below mentioned error: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.0...
2303 Feb 2014 @ 07:11 PSTTeradata StudioTopicTeradata Eclipse Plugin : Error With LDAP ConnectivityHi All, I am trying to setup teradata eclipse plugin on Eclipse Juno. Connection is successful when i am setting up without using LDAP connectivity option. However, ping fails for the same serve...
2206 Oct 2013 @ 08:28 PDTToolsReplySQL Assistant Preferences & DSN entries locationPosted about my learning and experience on backup/restore SQL assistant on the following linke: http://allzhere.in/2013/10/06/teradata-sql-assistant-backuprestore-guide/ I hope it helps.
2103 Oct 2013 @ 02:36 PDTDatabaseReply3932: Only an ET or null statement is legal after a DDL Statement. Saeed, i got the error in TD mode. But, i got the point. Thanks.
2002 Oct 2013 @ 10:33 PDTDatabaseTopic3932: Only an ET or null statement is legal after a DDL Statement. Hi All, I am writing a code to change PI of an existing table. I am creating a backup table with new PI. Copying data from existing table Drop Old Table Rename backup tab...
1901 Oct 2013 @ 05:00 PDTDatabaseReplyVolatile Table In View ??Hi, Thanks for the inputs. It helped me resolve the issue. However, i would like to add the following: I tried the  SELECT * FROM _person QUALIFY RANK() OVER (PARTITION BY perso...

Pages