43 | 19 Feb 2015 @ 04:25 PST | Database | Reply | Performance : ROWID join after JI hit | Just FYI that Similar behaviour is observed if i hit a SI.
The rowid join takes a long time to complete.
|
42 | 19 Feb 2015 @ 01:10 PST | Database | Reply | Performance : ROWID join after JI hit | Hi ,
The statistics are updated on participating objects.
|
41 | 16 Feb 2015 @ 12:59 PST | Database | Topic | Performance : ROWID join after JI hit | Hi 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... |
40 | 15 Oct 2014 @ 08:33 PDT | Connectivity | Topic | Perl Script : Fetching CLOB Columns | Hi 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 ... |
39 | 07 Oct 2014 @ 08:59 PDT | Database | Reply | Variables In Custom SQL Block | Following 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.
|
38 | 03 Oct 2014 @ 07:47 PDT | Database | Reply | Variables In Custom SQL Block | Hi,
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... |
37 | 03 Oct 2014 @ 10:22 PDT | Database | Reply | Variables In Custom SQL Block | Hi,
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.
... |
36 | 02 Oct 2014 @ 08:13 PDT | Database | Reply | Variables In Custom SQL Block | Hi,
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... |
35 | 02 Oct 2014 @ 04:02 PDT | Database | Topic | Variables In Custom SQL Block | Hi 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... |
34 | 26 Jul 2014 @ 07:18 PDT | Tools | Reply | TPT : Suppress or Redirect stdout/stderr logs | People, thanks for the inputs.
|
33 | 25 Jul 2014 @ 09:32 PDT | Tools | Reply | TPT : Suppress or Redirect stdout/stderr logs | Nopes, 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... |
32 | 25 Jul 2014 @ 05:41 PDT | Tools | Reply | TPT : Suppress or Redirect stdout/stderr logs | Hi,
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... |
31 | 25 Jul 2014 @ 03:50 PDT | Tools | Topic | TPT : Suppress or Redirect stdout/stderr logs | Hi,
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:... |
30 | 09 Apr 2014 @ 08:59 PDT | Tools | Reply | BTEQ Import Invalid Date Issue | Hi,
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... |
29 | 28 Mar 2014 @ 11:28 PDT | Tools | Topic | TPT : Infrastructure Setup Errors | Hi 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:... |
28 | 28 Mar 2014 @ 11:21 PDT | Tools | Topic | BTEQ Import Invalid Date Issue | Hi 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... |
27 | 08 Mar 2014 @ 09:34 PST | Database | Reply | Teradata Express for WIN 32 BIT | Hi 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... |
26 | 28 Feb 2014 @ 09:27 PST | Database | Reply | Change 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... |
25 | 05 Feb 2014 @ 10:51 PST | Teradata Studio | Reply | Teradata Eclipse Plugin : Error With LDAP Connectivity | Hi,
The escape character suggestion worked for me.
I was able to login.
Thanks....
|
24 | 03 Feb 2014 @ 11:44 PST | Teradata Studio | Reply | Teradata Eclipse Plugin : Error With LDAP Connectivity | Hi,
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... |
23 | 03 Feb 2014 @ 07:11 PST | Teradata Studio | Topic | Teradata Eclipse Plugin : Error With LDAP Connectivity | Hi 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... |
22 | 06 Oct 2013 @ 08:28 PDT | Tools | Reply | SQL Assistant Preferences & DSN entries location | Posted 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. |
21 | 03 Oct 2013 @ 02:36 PDT | Database | Reply | 3932: 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.
|
20 | 02 Oct 2013 @ 10:33 PDT | Database | Topic | 3932: 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... |
19 | 01 Oct 2013 @ 05:00 PDT | Database | Reply | Volatile 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... |