#DateForumTypeThreadPost
1006 May 2016 @ 11:08 PDTDatabaseReplyQuery :: Find tables which are accessed by usersYou need to look for objecttype = 'tab' rather than 'DB', you can define the statementtypes you are looking for select A.LOGDATE, A.PROCID, A.QUERYID, OBJECTDATABASENAME, OBJ...
903 Nov 2014 @ 12:15 PSTDatabaseReplyError : A column or character expression is larger than the max size. Ah, I was hoping there was a way to do it in SQL itself, I guess I will probably export the results in BTEQ, replace them using shell, and import them back in . But shouldn't there be a simpler...
803 Nov 2014 @ 12:09 PSTDatabaseReplyPerformance Tips for Group by on all columnsThank you Raja & Ulrich for your suggestions, It definitely was helpful.   --Karthik
702 Nov 2014 @ 07:54 PSTDatabaseReplyPerformance Tips for Group by on all columnsHi Ravi,  Yes I did take a look at the explain, the issue is not in the join step, as the steps leading to join completes in 5 mins, but the group by step takes about 13 mins to complete. &...
602 Nov 2014 @ 05:38 PSTDatabaseReplyError : A column or character expression is larger than the max size. Thank you Vikas, that explains why I am getting the error, but what is the alternative If I want to perform string manipulations in columns greater than varchar 8000 ? --Karthik
501 Nov 2014 @ 02:35 PDTDatabaseReplyError : A column or character expression is larger than the max size. Thank you Ravi, Its not specific to this, I tried creating a view and comment at the end of the view which has about 32000 characters. I then tried to user REGEXP_REPLACE & OREPLACE function , ...
401 Nov 2014 @ 02:27 PDTDatabaseReplySelect with grant and dbc.users - some questionsI will try to answer what I know from my understanding , someone correct me if I am wrong.   1  Select with grant option works exactly as it sounds, a user who has a select with grant o...
301 Nov 2014 @ 02:11 PDTDatabaseTopicPerformance Tips for Group by on all columnsHi,  I was working on tuning a query and I saw that the code was doing a group by on all columns being selected ( about 20 ). Even if i remove the group by condition, the select is not return...
224 Oct 2014 @ 12:11 PDTDatabaseTopicError : A column or character expression is larger than the max size. Hi,   I am running this code, but I keep on getting this error , if I do not cast it to CLOB , I get data row length exceeded, any suggestions ?   REPLACE PROCEDURE PROCDB.SWAP_TEST...
124 Oct 2014 @ 01:29 PDTDatabaseReplyUrgent help- Need to check unique items from table1 and get dimension data from table 2 for those itemsI am going to assume that you want to get the corresponding information present in both the tables, you need to do an inner join select columns from tablea A, tableb B where A.commoncolumn = B.com...