#DateForumTypeThreadPost
3522 Aug 2013 @ 03:42 PDTDatabaseReplyQUERY REWRITEHi, Can you try this and check if this helps.   select  TABLE1.* from    work_db.TABLE11 XLA   left join work_db.TABLE2 A on TABLE1.COLUMN1 = A.COLUMN...
3422 Jul 2012 @ 07:56 PDTToolsReplyCan we use where clause in TPT Export selector Thanks Ulrich,   Yes, I tried before I posted.. actuall issue was there was some junk value in between where condition.   Thanks, Karthik. N
3320 Jul 2012 @ 02:48 PDTToolsTopicCan we use where clause in TPT Export selector can we use the WHERE clause in the sql used to extract data using TPT.   Thanks, Karthik. N
3201 Jul 2012 @ 10:16 PDTGeneralTopicModifying the partition with case_n Hi, I have a tableA with partition given below,   PARTITION BY ( CASE_N( sys =  1, sys=   2, sys=   3 NO CASE OR UNKNOWN),CASE_N( cyc =  ...
3116 May 2012 @ 11:07 PDTDatabaseReplyQuery to select only quater data based on column value. Hi, This is the data i tried, ed_dt 01/17/2012 02/17/2012 03/17/2012 04/17/2012 05/07/2012 05/16/2012   SEL a.* FROM dat  a JOIN Sys_Calendar.calendar b ON ...
3002 May 2012 @ 12:32 PDTDatabaseReplyAvoid prdct join Hi,  Try this,     UPDATE H1 FROM (SELECT  trim(INV_SRC_ID)||'|'||trim(INV_PRD__ID) ||'|'||trim(ARGM_NBR)  as src_ky , END_DT from View.T...
2902 May 2012 @ 11:58 PDTDatabaseReplyQUERY TUNING Hi,   Try to do collect stats on the columns used in the join. If you are using SQA [sql assistant] try this, Diagnostic Helpstats on for session; execute the above sql ...
2816 Apr 2012 @ 08:49 PDTGeneralReplyVolatile table issue yes, It is showing Temp.TMP_TEXT_CONSOLIDATED. Temp is one of the Databasename. But default database is BASE in the env which we are working.   Thanks, Karthik. N
2716 Apr 2012 @ 08:28 PDTGeneralTopicVolatile table issue Hi, A query having a  join with volatile table TMP_TEXT_CONSOLIDATED  TEXT1, query is not throwing any error if volatile table  doesn’t exist. any idea which tab...
2616 Apr 2012 @ 07:33 PDTDatabaseReplySum column values based on date range Can you share all the columns in both the tables product p1, promotions p2. If possible sample data.
2516 Apr 2012 @ 05:55 PDTGeneralReply Target row updated by multiple source rows Hi,   There might be more than one value trying to update the Surcharge/Restocking_Fee because, T1.invoice_id=IPI.invoice_id AND T1.Invoice_Item_Nr = IPI.item_nr &nb...
2414 Mar 2012 @ 01:31 PDTGeneralReplyError 3149 Thanks Ulrich. These is point I noticed. There was a distinct in the select clause. Optimizer is taking time, when there is distinct in the select on the columns used in the join.
2313 Mar 2012 @ 11:43 PDTGeneralReplyError 3149 Yes I verified the explain plan, they are same. steps and order:  both has 26 steps and in same order.   without the field used in join: to be 148,374,004 rows (247,932...
2213 Mar 2012 @ 02:18 PDTGeneralReplyError 3149 There is not much change in explain plan. other than the new field added.   before  the query is like SEL col8,col9,col10 FROM tableA a JOIN tableB b ON a.col1=b.col...
2113 Mar 2012 @ 01:30 PDTGeneralReplyError 3149 Thnaks Ulrich, one more doubt I have is , when I select the column used in the join in the select part explain plan is showing more time.  ex: SEL col1,col2,col3,col4 FROM ...
2012 Mar 2012 @ 10:08 PDTGeneralTopicError 3149 Hi, when we execute a query with many left joins in SQL assistant, we are facing 3149 error code : TDWM filter violation for query request: For rule name '3HR_Alert' Any sugg...
1901 Mar 2012 @ 11:13 PSTDatabaseReplyperformance issue with update query update sandbox.MS_TEST_EMAILCOOKIERANKPBJAN1 from sandbox.MS_TEST_EMAILCOOKIERANKPBJAN1 set datediff= Web_Registration_Start_Dt - Xref_Create_Dt where Web_Registration_Start_Dt bet...
1801 Mar 2012 @ 10:44 PSTDatabaseReplyCounts and total count in one query ? CREATE VOLATILE TABLE main (catg VARCHAR(6), code INT) ON COMMIT PRESERVE ROWS; CREATE VOLATILE TABLE  details (id INT, date_d DATE, cat_code INT, comme VARCHAR(8)) ON COMMIT PRES...
1701 Mar 2012 @ 10:43 PSTDatabaseReplyCounts and total count in one query ? add a new field in select with catg1+catg2+cat3 as Total_count
1628 Feb 2012 @ 09:47 PSTGeneralReply3760:String not terminated before end of text Hi Ulrich, Issue is due to the field TRIM(BOTH' ' FROM minval), it gives the value 'C ' CHAR2HEXINT of the value gives me 004300200020002000200020  as the field is o...
1528 Feb 2012 @ 08:46 PSTGeneralReply3760:String not terminated before end of text insert into results values('PRCS STAT CODE','metadata','prcs', 1, 6720,'C ','X'); This sql from log table derived from dsql.
1428 Feb 2012 @ 07:00 PSTGeneralTopic3760:String not terminated before end of text Hi, In a procedure we get all the values passed to insert command using the cursor, when i execute using dsql facing 3760 error. insert into results values('PRCS STAT CODE',&...
1314 Feb 2012 @ 07:32 PSTGeneralReplyPerformance comparision between two teradata DBs Hi Shashank,   Check the DDL of the tables in DEV and Prod, check whether the primary index is same on both the tables. Check any collect stats applied on Dev tables and not in ...
1218 Jan 2012 @ 02:22 PSTGeneralReplyTD Multi language support Thanks Dieter! Is it possible to convert existing column with CHARACTER SET LATIN to  CHARACTER SET UNICODE?   Thanks, Karthik. N
1117 Jan 2012 @ 05:01 PSTGeneralTopicTD Multi language support Hi, we have a flat file with comments column having multiple languages like [greek,french,chineese]. Is it possible to store different formats in a varchar field? If I select the dat...

Pages