#DateForumTypeThreadPost
2722 May 2008 @ 07:44 PDTDatabaseReplyTransient Journalthanks AdeelI agree with your points.I am just concerned with INSERT operation only. and HOW TJ mechanism works there?when we discuss abput TJ we speak about BEFORE IMAGE. how will that work in INS...
2622 May 2008 @ 07:21 PDTDatabaseReplyTransient JournalBut in some cases like INSERT/SELECT , DELETE ALL and also in case of MULTILOAD and FASTLOAD transient journal will nor come into picture, right?so to my knowledge it depends whether the table is a...
2522 May 2008 @ 07:09 PDTDatabaseTopicTransient JournalHiI would like to know whether TRANSIENT JOURNAL comes into picture when we INSERT rows into a table. The table can be an EMPTY one or can be ALREADY POPULATED.Can anyone help me know this.ThanksMa...
2421 Feb 2008 @ 12:54 PSTToolsReplyFastExport - Unloading and matching with Cobol datatypesCan any one guide me how can i load the S9(13)V9(02) COMP variable into Teradata table.How can i CAST that into DECIMAL variable so that i wont miss any data.Thank youMadhavi.
2307 Dec 2007 @ 10:38 PSTDatabaseReplyPerformance tuning-2Thats the unfortunate thing here that we cant modify/edit the where clause of the query.
2207 Dec 2007 @ 06:34 PSTDatabaseReplyPerformance tuning-2Thanks Annal.The actual select clause was happening against a view. and the base table is really very big and is used for various other purposes also, like joins etc.And the actual query used IN cl...
2106 Dec 2007 @ 10:12 PSTDatabaseReplyPerformance tuning-2Yes.. I understand your point that when we are using NON-EQUALITY in the where clause, the SI is not used effectively, and Full table scan will take place. But in this case we are not able to get r...
2004 Dec 2007 @ 05:51 PSTDatabaseTopicPerformance tuning-2How can i increase the performance for the following querywhere the EXPLAIN commend give the following result:Explanation 1) First, we lock GPW_DATA.B01_BKP1 for access. 2) Next, we do an all-AM...
1904 Dec 2007 @ 05:40 PSTDatabaseTopicPerformance tuningHi allI would like to know what are all steps involved in performance tuning.Can any one help.ThanksMadhavi
1807 Aug 2007 @ 04:55 PDTDatabaseTopicsum of counts on 2 different tablesThere are 2 tables lets say A and B available and i need to findout the sum of count(*) from both the tables A&B together as the answer.Please help me.
1720 Jul 2007 @ 12:18 PDTDatabaseReplyVery UrgentThank you very much.
1620 Jul 2007 @ 11:34 PDTDatabaseTopicVery UrgentCan any one tell me how to find the Teradata Version number being used in application by using Teradata SQL Assistant(Queryman).I think there will be a query to run.Very Urgent.
1512 Mar 2007 @ 12:41 PDTDatabaseTopicASCIIhi alli am using TERADATA SQL assistant and IBM Mainframes. using that i wanted to update a column value to '['.the query liiks like:UPDATE ABC_TABLE SET COULMN_C = '[' WHERE COLUMN_A = '07' AND CO...
1416 Feb 2007 @ 10:21 PSTDatabaseReplyPPIto add another question for Fred, when we are not mentioning PARTITION by on PI column, how can it apply on it?we are specifically mentioning on which we column we need the partition/group.
1316 Feb 2007 @ 10:14 PSTDatabaseReplyPPIthanks for all that information that you provided.and can i get the book available online?if its so... can i have that link please......
1215 Feb 2007 @ 08:03 PSTDatabaseReplyPPIjoedsilvai have a single question for you.are you aware of the situation that we can use partition by clause on other column which is not a part of PI?ex:Create set table database1.employee_table(e...
1115 Feb 2007 @ 06:11 PSTDatabaseReplyPPIHi joedsilvaThanks for your responses.I understand the concept of PPI and NON-PPI in a table.But my question was different.What I am concerned about is… we have PARTITION used in our table, but n...
1014 Feb 2007 @ 09:31 PSTDatabaseReplyPPIthats a good start actually.ok.. i can explain like this here the PI is empno and the value that we are trying to insert is 409.so the PE will finalyse the AMP depending on the row-id thats obtaine...
914 Feb 2007 @ 07:45 PSTDatabaseReplyPPIthanks for your information joedsilva.but i still have some points to say.1) as you already said.. that was a weird example. when its defined as UPI, we can just forget updating the primary column....
814 Feb 2007 @ 06:45 PSTDatabaseReplyPPI"to avaoid TD from probing every partition" in the sence?can you explain more detailed on this sentence.
714 Feb 2007 @ 05:51 PSTDatabaseTopicPPIhi alli read a statement saying " if a PARTITION BY is defined on a column other than a Primary Index column, then that table cannot have Unique Primary index defined on it. we can only have NON_UN...
612 Feb 2007 @ 08:58 PSTDatabaseTopicPartitioned Primary Indexhican any one provide some information/material regarding PPI in Teradata.Thanks Madhavi
512 Oct 2006 @ 06:17 PDTToolsReplyBTQMAINthanks Daniel
412 Oct 2006 @ 05:45 PDTToolsTopicBTQMAINwhat is the significance of "SET QUIET ON" and " .REPEAT *" in BTQMAIN?the code was looking like this .SET QUIET ON .IMPORT DATA DDNAME=INFILE .REPEAT * ...
312 Oct 2006 @ 05:34 PDTToolsReplyerror message UTY0805 RDBMS failure, 2583Thanks AravindI dropped all the working, error tables and the Mload table too. After that i again created the same table and rerun the jcl. Its working.Thankyou once again.

Pages