#DateForumTypeThreadPost
6806 May 2016 @ 01:53 PDTDatabaseReplyBad character in format or data REGEXP_SIMILAR('2A','^[0-9+]$',i') returns 0 REGEXP_SIMILAR('2121121','^[0-9+]$',i') returns 1   Works in >= TD 14 
6706 May 2016 @ 01:47 PDTDatabaseReplyQuery :: Find tables which are accessed by usersDBQLOGTBL - Contains the query and the queryid,username DBQLOBJTBL - Contains the querid and the objects  Join based on QUERYID and get the info of the tables accessed by the users.
6606 May 2016 @ 01:30 PDTDatabaseReplyBad data in table , need suggestion to isolate the problemTimestamp columns have invalid timestamp values?...
6504 May 2016 @ 04:13 PDTDatabaseReplySort a cell value what is the volume of the table?
6426 Apr 2016 @ 01:49 PDTDatabaseReplyRollup subtotal as percent of grand totalIF you are trying to group by  p.product_name, then use only that column in the GROUP BY clause
6326 Apr 2016 @ 12:30 PDTDatabaseReplyPassing parameters into a subqueryThe reason I gave that suggestion is..you can plug in your entire query inside the chunk.But if it is just the select...Try this..Just the SQL needs to be modified according to your needs..  ...
6225 Apr 2016 @ 11:14 PDTDatabaseReplyPassing parameters into a subquerySince the table name is dynamical...Try the procedure...as shown below.   REPLACE PROCEDURE dbname.TEST1( ) BEGIN DECLARE SQL1 VARCHAR(1000); SET SQL1='INSERT INTO...
6125 Apr 2016 @ 03:23 PDTDatabaseReplyQuery that requires optional promptsI think SP would be a better option. Check the input, If the input is only one, then execute the dynamic SQL based on only one input. If its two, execute the dynamic SQL based on two inputs. &n...
6024 Apr 2016 @ 11:23 PDTDatabaseReplyPassing parameters into a subquerySEL 'CUSTRATING_'||CAST((TD_FRIDAY(DATE,NULL,NULL)(FORMAT 'YYYYMMDD')) AS VARCHAR(10))||'_REF';  
5924 Apr 2016 @ 10:39 PDTDatabaseReplyRank or Sum Until Value ReachedWhat is the volume of the tables?
5824 Apr 2016 @ 10:26 PDTDatabaseReplyFINDING INVALID DATASEL  CASE  WHEN REGEXP_SIMILAR('2Q','^[0-9]*$','i')=1 THEN CAST('2Q' AS DECIMAL(9,0)) ELSE '2Q' END -----In >= TD 14
5721 Apr 2016 @ 05:26 PDTDatabaseReplyload Zip file using Fastloadafaik, in think..fastload would not support in 14.10..TPT may support..
5621 Apr 2016 @ 05:04 PDTDatabaseReplyTerradata : Terradata not taking table-name for query.Its searching in the table...thats the reason the error is 5628: Column smallname not found in domain.a or domain2.b... In table a or table b, the column name should be present...
5521 Apr 2016 @ 05:01 PDTDatabaseReplyCOUNT () OVER (PARTITION BY) and DISTINCTThat should work...shavyani....
5421 Apr 2016 @ 03:54 PDTDatabaseReplyQuery that requires optional promptsWhat do you mean by optional?...user's option or can it be null...
5321 Apr 2016 @ 03:51 PDTDatabaseReplyTerradata : Terradata not taking table-name for query.Check for the column name
5219 Apr 2016 @ 01:26 PDTDatabaseReplySelecting duplicate records from a table - Complete record and not just the duplicate keys SEL A.* FROM  (SEL A.* FROM  (SEL TBL.*  FROM TABLE TBL QUALIFY (COUNT(*) OVER(PARTITION BY NAME,YOJ,NCD ORDER BY PY_DT DESC) >1)) A  QUALIFY COUNT(*) OVER...
5107 Apr 2016 @ 02:49 PDTDatabaseReplyHow to Add IDENTITY_COLUMN into existing table ?Add a BIGINT column. Generate  surrogate keys  and update the column for each row in that table.    
5007 Apr 2016 @ 02:12 PDTDatabaseReplyHow to Add IDENTITY_COLUMN into existing table ?Identity column cannot be added to an existing table..
4906 Apr 2016 @ 03:43 PDTDatabaseReplyCOUNT () OVER (PARTITION BY) and DISTINCTSame reply as the other one...
4806 Apr 2016 @ 03:42 PDTDatabaseReplyCumulative Sum by distinct customer ID by year SEL  CUST, DT1, DT2, CASE   WHEN DIFF >=1 AND DIFF <=10 THEN DIFF ELSE 0 END AS SUM_1TO10, CASE   WHEN DIFF >=11 AND DIFF <=20 THEN DIFF ELSE 0 END...
4706 Apr 2016 @ 02:25 PDTDatabaseReplySQL for Deleting Data Older than n Years + current YearShouldn't it be -24 for the calc?
4606 Apr 2016 @ 02:05 PDTDatabaseReplyFiltering on dates - Explain plan looks right but it returns 0 rows. Its working for me.... SEL ADD_MONTHS (date '2014-04-01' - (EXTRACT(DAY FROM DATE '2014-04-01') - 1), -1), date '2014-04-01' - EXTRACT(DAY FROM date '2014-04-...
4511 Mar 2016 @ 04:14 PSTDatabaseReply calling bteq in unix shell scriptUse export option of BTEQ to export the data, if the no of records is less. The output file can be directed to the desired location.
4411 Mar 2016 @ 04:06 PSTDatabaseReplyneed to test a query using three diff datesIf its a simple query, put it in a macro and parameterize the input date.

Pages