#DateForumTypeThreadPost
9917 Nov 2015 @ 07:29 PSTGeneralReplyNeed Help with DBQL query to find top 10 queries with high cpu usage Hi Sangeetha, The below query gives the top 50 queries;  please modify it according to your needs;  (courtesy Akos Levoi)   select top 50 ProcID , QueryID , AMPCPUTime , ...
9816 Nov 2015 @ 08:38 PSTViewpointTopicHow to setup bteq, program, sending email on VMWare 15Greetings Experts, I have downloaded and installed the   TDExpress15.00.01_Sles10_40GB_vp  on VMware-player-7.1.0-2496824 I am trying to setup alerts for sending email.  ...
9706 Nov 2015 @ 08:31 PSTDatabaseTopicSQL Aggregation logic - Not sure Greetings Experts,   I am implementing the multiple separate logics between 2 tables by joining them in a view.  I need to have minimal number of views with all logics implemen...
9631 Aug 2015 @ 10:41 PDTDatabaseReplyColumnname on which error occurredDear Experts, Was expecting your suggestions on this.
9531 Aug 2015 @ 10:40 PDTDatabaseTopicBad argument for ** operator - POWER function Greetings Experts,   We are facing a strange situation in which the following sql skeleton is failing with the error "Bad argument for ** operator"  Please note that ...
9425 Aug 2015 @ 08:35 PDTDatabaseTopicColumnname on which error occurredGreetings Experts, We doesn't have access to our PROD and we develop scripts and test in SIT, UAT.  When promoted to PROD, occassionally the following errors occur. Invalid Date/Timestam...
9315 Aug 2015 @ 07:44 PDTDatabaseTopicAny effects of timezone on data Greetings Experts, I need a clarification on how the different timezone or relative settings effect the users on server and clients. Say, a user from Australia inserted into a table with 2 cols (...
9215 Aug 2015 @ 07:22 PDTViewpointTopicPerformance degradation - action to be takenGreetings Experts, Apologies if this post doesn't seem to be in this category and for a generic query. If the TD performance is degraded, what are the steps that are to be taken to identify t...
9115 Aug 2015 @ 07:10 PDTViewpointTopicMore sessions in delayed state - Best action to be takenGreetings Experts, I am new to Viewpoint and going through the User Guide;  Just wanted to know if there is heavy load on TD and many sessions end up in "Delayed" state, how to cope...
9014 May 2015 @ 12:38 PDTDatabaseTopicComparing 2 different datatypes giving undesired results  Greetings All,   When comparing 2 different char/varchar datatypes in TD , the comparison is returning undesired results as the hexadecimal representation of the data in col...
8922 Sep 2014 @ 12:09 PDTDatabaseReplyUTF -8 or UTF-16?Hi All,   I have seen that when using TPT, we should declare the columns which uses utf8 as size*3 and for utf16 as size*2.  Can you please explain these. So, does that mean in utf8, e...
8822 Sep 2014 @ 12:00 PDTDatabaseReplyIdentify the time zone from a timestamp columnHi Raja, The column is defined as "timestamp with time zone"  Also, is there any possibility to find the same information from only a timestamp column.  
8719 Sep 2014 @ 04:26 PDTDatabaseReplyIdentify the time zone from a timestamp columnThank you Raja, To be clear, we have a table on a server on which the records are inserted from different countries which have different time zone, I need to find what are all the records that ...
8619 Sep 2014 @ 03:01 PDTDatabaseTopicIdentify the time zone from a timestamp columnGreetings All, I have a requirement to identify the time zone of a record (from a time stamp or date column) from existing populated table.  Can you please help me on this.  
8529 Aug 2014 @ 10:43 PDTDatabaseTopicMy perception on EXPLAIN was wrongGreetings experts, We are in the testing environment, where we will not have select access to some of the tables.  When I need to run a complex query with multiple joins to other tables with ...
8429 Aug 2014 @ 10:17 PDTDatabaseTopicString contains an untranslatable characterGreetings Experts, I need to find out what are the columns that has any language characters other than english (unicode with other language characters in it - not dbc.columns.chartype=2)  Ter...
8314 Jul 2014 @ 11:37 PDTDatabaseTopicHow is SPOOL space allocated and used.Greetings Experts, In the scenario of NO MORE SPOOL SPACE, can this be attributed to any one of the AMPs (similar to the permanent space, on which one of the amp has high peak perm space).  I...
8214 Jul 2014 @ 11:21 PDTDatabaseTopicCompare DDL's of tables in 2 testing phases - find differences Greetings Experts,   I have a database in which there are around 600 tables being used in SIT.  As we are moving to UAT, I need to compare the DDL's of the tables (column n...
8110 Mar 2014 @ 11:06 PDTToolsReplyHandle records in Mload ET table in TEXT mode - A column or character expression is larger than the max sizeHi Sudhansu, That worked, thank you.  I was expecting the data to be in unreadable format due to DATA mode.  But I could see that the content is readable.  Any thoughts on this? &nb...
8010 Mar 2014 @ 12:37 PDTToolsTopicHandle records in Mload ET table in TEXT mode - A column or character expression is larger than the max sizeGreetings experts, I have fastexported a table in text mode and loaded the data in to target table using Mload in text mode (I am using 13.00 Demo version on windows 7).   source/target tabl...
7927 Feb 2014 @ 07:22 PSTToolsReplyFast export and mload in vartext mode - Data item too large for field issueHi All, Modified the input select statement (of fast export) to include TRIM there by eliminating the blanks as below 1 2 ...
7827 Feb 2014 @ 02:00 PSTToolsReplyFast export and mload in vartext mode - Data item too large for field issueHi Ivy/All, Thank you for your input. This one worked with fastload format. I am looking for some script that does export the data in delimited fashion through fast export utility and load into T...
7726 Feb 2014 @ 12:58 PSTToolsTopicFast export and mload in vartext mode - Data item too large for field issueGreetings experts, I am facing the following issue in TD Demo version 13.0 , windows 7 Scenario:  Fast exporting from a table samples.itemppi_bkp in "mode record format text" (vart...
7625 Feb 2014 @ 12:01 PSTToolsReplyfast export and mload in fastload format issue - error code 2793Perfect, thank you Dieter and Steven. 
7525 Feb 2014 @ 11:11 PSTToolsReplyfast export and mload in fastload format issue - error code 2793Hi Dieter, Yes, the rows are already present in the target table.  I have deleted them and ran the entire process again. Now data loaded into target table, but I could see mismatch in the dat...

Pages