#DateForumTypeThreadPost
1115 Oct 2013 @ 08:09 PDTDatabaseReplyMinmum Time field selection - TIME(6)Thats exactly whats happening Dieter :) thanks a ton for your reply.. Really appriciate it
1011 Oct 2013 @ 01:12 PDTDatabaseReplyMinmum Time field selection - TIME(6)Here are some sample data... act_dt act_tm 2013-06-01 00:01:33 2013-06-01 00:02:33 ...
911 Oct 2013 @ 12:38 PDTDatabaseReplyMinmum Time field selection - TIME(6)Thanks for your reply Khurram, No Luck :( i am still getting '17:00:07' as my minimum
811 Oct 2013 @ 11:25 PDTDatabaseTopicMinmum Time field selection - TIME(6)Dear All, I have a Table where i have 2 fields - date_col and time_col. DATE_COL - DATE FORMAT 'YY/MM/DD' TIME_COL - TIME(6) I am trying to select the min(time_col) for a particular dat...
713 May 2013 @ 05:25 PDTDatabaseTopicStore Procedure Return Codes & Failed Query TxtHi All Just wanted to know if we can capture the actual query that failed while a stored procedure was executing. I tried capturing Activity Count, SQL State, SQL code - but just in case wanted t...
615 Apr 2013 @ 03:59 PDTDatabaseReplyTeradata Error: 3807 - Updating a ViewIts very strange... I removed the Alias name from the Select statement in the View DDL and it worked... Previously my DDL was like REPLACE VIEW <VIEWNAME> (Col1, Col2, Col3....) as SELEC...
515 Apr 2013 @ 01:06 PDTDatabaseTopicTeradata Error: 3807 - Updating a ViewHi All I am trying to update a view which is built on a table and I am receiving the following error. But my table and view is properly setup... Before updating, I am setting the database to my d...
411 Apr 2013 @ 02:53 PDTDatabaseReplyTeradata Error: 7547 - Deletes all the records from Target Volatile Table upon exitThanks a Ton for your reply Dieter...
311 Apr 2013 @ 02:29 PDTDatabaseTopicTeradata Error: 7547 - Deletes all the records from Target Volatile Table upon exitCan some one help me understand the scenario thats been happening for me I am creating a lot of Volatile Temp tables in my stored procedure. When Executing the stored procedure i am logging the Ac...
201 Mar 2013 @ 09:18 PSTDatabaseReplyDifference between Create table Statements Thanks very much for the infromation Dieter.. As you mentioned, I am going to use the CREATE tables in huge stored procedures and there are going to be atleast 50 volatile tables created and ...
127 Feb 2013 @ 04:37 PSTDatabaseTopicDifference between Create table Statements Hi All I want to understand if there will be a difference in performace or on any front between Any inputs will be of a great help. I am dealing with huge fact tables and many volatile tables to ...