#DateForumTypeThreadPost
51604 Sep 2012 @ 11:35 PDTDatabaseReplyDo macros only support ANSI sql? try select * from t_1 outer join t_2 on t_1.some_id = t_2.some_id;
51504 Sep 2012 @ 10:57 PDTDatabaseReplyDo macros only support ANSI sql? No - can you share the code? And what is the error code you get?
51404 Sep 2012 @ 08:16 PDTTeradata ApplicationsReplyBteq script required to validate record count of Source and target table. Sounds like a good idea. What is your issue?
51304 Sep 2012 @ 01:22 PDTGeneralTopicWish list for forum development   Following the latest comment on http://forums.teradata.com/forum/database/problems- with-dynamic-creation... lol I also like to address some wishes for further forum developme...
51203 Sep 2012 @ 07:14 PDTDatabaseReplyProblems with dynamic creation of Volatile tables Forgot the GT for the drop index statements... CREATE GLOBAL TEMPORARY TABLE gt_drop_index_stmt ( txt VARCHAR(1000)) ON COMMIT PRESERVE ROWS;
51103 Sep 2012 @ 07:13 PDTDatabaseReplyProblems with dynamic creation of Volatile tables just to play arround - not fully tested, no exception handling etc. maybe more index types to consider but a SP might become handy for this... REPLACE PROCEDURE test_db_uli.p_create_tb_copy ...
51003 Sep 2012 @ 01:58 PDTAnalyticsReplyNeed to calculate days X0.EVENT_START_DATE > ((X2.processing_date as date) as bs_date, add_months (bs_date+1,-26)) assume X0.EVENT_START_DATE is a date  > would require that the right hand side...
50903 Sep 2012 @ 01:51 PDTAnalyticsReplyCounting working days How do you define "working days"? Always Mo - Fr, Mo-Sa, exclude Holidays? If you need to consider Holidays you would need a kalendar table to maintain these.
50802 Sep 2012 @ 11:03 PDTDatabaseReplyCompress text value NULL compress('NULL') will compress the String 'NULL' and any NULL as well as NULL is compressed in any case if a compress statement is given.
50731 Aug 2012 @ 10:54 PDTDatabaseReplyWould the results differ if the last condition was: WHERE employee.last_name = 'Brown' ? Read the manuals on basic SQL
50631 Aug 2012 @ 10:53 PDTDatabaseReplyCan some one provide the solution for the below scenario? Saikandimalla, I am not doing your job. Did you try to understand what this SQL does? If it does not meet your needs try to adopt it to your requirements.
50531 Aug 2012 @ 07:52 PDTAnalyticsReplyNeed to calculate days don't you have access to a TD DB? Just try - at least it worked for me
50431 Aug 2012 @ 06:03 PDTDatabaseReplyhow to get the sqltext from queries that ran during an time interval without enabling logging? funny question - you don't want to enable a loggiing but you want the logging info. no - that the purpose of DBQL which you need to enable.
50331 Aug 2012 @ 05:55 PDTDatabaseReplyfloat data type in teradata From the manual   Decimal Results and Rounding When computing an expression, decimal results that are not exact are rounded, not truncated. For more information on roundin...
50231 Aug 2012 @ 05:53 PDTAnalyticsReplyNeed to calculate days Why do you expect 7/1/2010 if you go back 26 month from 8/31/2012? I would expect 6/30/2012 which you get via   select cast('2012-08-30' as date) as base_dt,  ...
50130 Aug 2012 @ 06:59 PDTDatabaseReplyBetween Times not working case when cast(ASKME_CREAT_TM as time) between cast('08:00:00' as time) and cast('12:00:00' as time) then 'AM' else 'unkown' end, should work as well, so no ne...
50030 Aug 2012 @ 03:11 PDTDatabaseReplyParent Child Relationship Flattening Your DDL seems not to be matching the inserts.   Below SQLs should do CREATE SET TABLE TEST123 ( PARENT VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, CHILD VARCHAR(20) CHAR...
49929 Aug 2012 @ 03:52 PDTDatabaseReplyParent Child Relationship Flattening But  WS WG1 WG2 WA W1 B1 W2 B2 is not  WS- WG1-W1-B1- WG22-W2-B2-WA So, what is the final call on this?
49829 Aug 2012 @ 03:45 PDTDatabaseReplyBetween Times not working Select current_timestamp(0) cts, cast(cts as time) as ctime, case when ctime between cast('08:00:00' as time) and cast('12:00:00' as time) then 'AM' else &...
49729 Aug 2012 @ 02:14 PDTDatabaseReplyBetween Times not working Your case is odd as you mix two syntax types, so it will not work. What data type is ASKME_CREAT_TM?  
49629 Aug 2012 @ 01:08 PDTDatabaseReplyCan some one provide the solution for the below scenario? I think you are looking for something like this...   select base.cust_id, base.src_id, base.branch, base.month_end_date, coalesce(amt,0) as MTD, ...
49528 Aug 2012 @ 11:33 PDTGeneralReplyUpdate select optimizationdrop all NUSI, USI, JI? which contain columns which are going to be updated and recreate them after the update.
49428 Aug 2012 @ 11:31 PDTToolsReplyTPT script: error while executing TPT scriptIn this case it is as feinholz stated "If you would like further help on this you are going to have to provide the script, or at least portions of the script. Just remove all sensitive informatio...
49328 Aug 2012 @ 07:29 PDTGeneralReplyUpdate select optimizationwhy do you set A.col = B.col when you already request where A.col = B.col??? Try to avoid to update the PI...
49227 Aug 2012 @ 11:33 PDTDatabaseReplyCan some one provide the solution for the below scenario?No, as long as you are not providing a DDL and insert statements to create your test data.

Pages