#DateForumTypeThreadPost
1607 Jan 2016 @ 11:47 PSTDatabaseTopicConflicting Timestamp values in Start_ts and End_tsHi All, Below is the ipnut data and desired output    create table table1 ( Store_id char(3), emp_id demical(18,0), store_segment Varchar(40), Shift_start_ts Timestamp(0), Sh...
1530 Oct 2015 @ 03:42 PDTDatabaseReply12 hour time(AM/PM) to 24 hour time conversionGot it. cast(cast(LPAD(START_TM,7,'0') as timestamp(0) format 'HH:MIT') as timestamp(0) format 'HH:MI:SS') START_TM   Works fine !! Cheers :)
1430 Oct 2015 @ 12:16 PDTDatabaseReply12 hour time(AM/PM) to 24 hour time conversion sel cast(cast('09/08/1989 11:46:29PM'  as timestamp(0) format 'MM-DD-YYYYBhh:mi:sst' ) as time(0))   The above query works fine but when tried the below its giv...
1329 Oct 2015 @ 11:40 PDTDatabaseTopic12 hour time(AM/PM) to 24 hour time conversionHi All, I am trying to convert 12 hour time (AM/PM) format to 24 hour time format and getting Invalid Time error. Source data - 2:26PM Requirement - 14:43:00 When I am running the below query i...
1209 Oct 2014 @ 09:07 PDTDatabaseTopicRow level Duplicate Record eliminationHi All, I want to remove the complete row level duplicates from multiple source while inserting to the target table. I cant do UNION or I can create a SET target table. Which approach will have ...
1103 Sep 2014 @ 11:36 PDTToolsReplyCustom Message in Bteqall the 3 approaches work perfectly. Thanks Dieter and Raja
1002 Sep 2014 @ 02:36 PDTToolsReplyCustom Message in BteqI also tried with .REMARK but the custom message is not getting populated in the logfile.
902 Sep 2014 @ 02:14 PDTToolsTopicCustom Message in BteqHi All, I want a customized error output message for each statement failure in bteq. I tried with the below code but getting error *** Error: Illegal value "MSG" specified. Notify ignor...
828 Aug 2014 @ 02:05 PDTToolsReplyFast load Vs Mload when AMP is downwhat if the target table is created with no fallback option ?
728 Aug 2014 @ 02:58 PDTToolsReplyTeradata Bteq OptimizationIn this case if the insert statement fails, does the delete transaction get rolled back ?
627 Aug 2014 @ 11:54 PDTToolsReplyTeradata Bteq OptimizationRaja, Could you please explain more on SSR and MSR. Can we pack the delete table and insert to table in a single transaction as below ? What is the advantage and disadvantage of this ? Delete ...
527 Aug 2014 @ 02:18 PDTToolsTopicTeradata Bteq OptimizationHi All, We have a requirement to apply optimization to the exting Bteq Scripts. What are all possible scope of optimization in a Bteq ? Is there any best practices document or coding standard gu...
426 Aug 2014 @ 10:14 PDTDatabaseReplyDefining two derived tables using WITH clause ??Thank you so mcuh Dieter.
326 Aug 2014 @ 07:21 PDTDatabaseReplyDefining two derived tables using WITH clause ??Hi Dieter, Tried the below syntaz but it's not working WITH TEMP_TAB(a,b,c) AS (Select a,b,c from table) WITH TEMP_TAB2(a,x,y) AS (Select a,x,y from table)   Sel derived_...
223 Aug 2014 @ 11:51 PDTToolsReplyExporting to Multiple files in Fast Exportthanks Steve
121 Aug 2014 @ 11:09 PDTToolsTopicExporting to Multiple files in Fast ExportHi  All, Can we export the output of multiple select statements specified with in .begin export and .end export to multiple outfiles ? If we create multiple .begin export and .end export...