#DateForumTypeThreadPost
4310 Jul 2016 @ 11:32 PDTDatabaseTopicFind the minimum alignment date query based on alignment numberHi Frinds, Need your help. I need to find the minimum alignment date of alignment numbers. Alignment No Alignment_Date 30 20...
4224 Jun 2016 @ 08:09 PDTDatabaseTopicNOT NULL still retrieves NULLHi Friends, Can somebody help me on the below issue that am facing while executing it. The result of the below query retrieves NULL value even when specified the filter IS NOT NULL.   SELEC...
4114 Apr 2016 @ 10:58 PDTDatabaseTopicUpdate StatementHi Friends, Caould you please help me with an update statement query?   I have the data in the table as below: Territory   Sysid a               &n...
4014 Oct 2015 @ 06:47 PDTDatabaseTopicPassword change logHi, Need an immediate help from you my dear friends. I happened to change my Tearadata password both for the PROD & QA environment.I was getting the password expiry alert and hance changed. E...
3901 Sep 2015 @ 11:36 PDTDatabaseTopicTearadata Stored procedure problem Hi Friends, I executed the below 3 querys pertaining to stored procedure and it worked well in my TD version 13. The same query while i executed in TD 14 it threw me with Error 3706 Invalid ...
3801 Sep 2015 @ 11:33 PDTDatabaseReplyFind which logon id locked the userBrilliant diater...Thank you so much..
3701 Sep 2015 @ 11:32 PDTDatabaseTopicTearadata ProcedureHi There, Need your help in stored procedure as am wuite new to this.   I needa stored procedure, in which the column that i pass should always fetch first letter as a character and then it...
3621 Aug 2015 @ 03:26 PDTDatabaseTopicFind which logon id locked the userHi there, We have a teradata user name READQ using which we connect to the QA environment. Recently someone locked this user. Any query to  trace from any of the system tables avaiable as to...
3510 Aug 2015 @ 09:53 PDTDatabaseTopicView creation.Hi, In one of our project it is been told to create a view for a table even if we are not accessing the view. It is just a simple view as "Relace view as Select *from Table" Is creatin...
3424 May 2015 @ 09:52 PDTDatabaseReplyVIEW CREATION QUERYAnil Thanks. So u say the below is enough to create the view, without Locking row for acess? REPLACE VIEW VDDVD.PRODUCT AS SELECT *FROM VWD.PRODUCT Any performnace or other issues if i place...
3323 May 2015 @ 10:05 PDTDatabaseReplyVIEW CREATION QUERYHi , Any suggestions??   Regards John
3222 May 2015 @ 06:44 PDTDatabaseTopicDROP COLUMNHi , Does drop column command delete the entire data from the table or just that column and its corresponding data?   Regards John
3122 May 2015 @ 06:42 PDTDatabaseTopicVIEW CREATION QUERYHi there,   I have a question regarding view. I have created 2 views as follows.     REPLACE VIEW VWD.PRODUCT AS LOCKING ROW FOR ACCESS SELECT *FROM DDD.PRODUCT; ---...
3022 Mar 2015 @ 10:33 PDTDatabaseReplyNon duplicate row selection queryHi Dieter, Thanks. Just executed and it throws out with the error 3706. Expected something between ( and  the Trim keyword.   select * from CONSUMER_TABLE WHERE DIRCT_ID IN ...
2919 Mar 2015 @ 12:51 PDTDatabaseReplyNon duplicate row selection queryHi All, I have executed  the querie below to get the distinct records , butt quite unluckily as it throws me out with spool space error. Even with group by also its the same. Except the Dire...
2818 Mar 2015 @ 01:12 PDTDatabaseReplyNon duplicate row selection queryNo Worries Yuva.. Any other ways? I have tried using Partition and group by but both are taking too long..Any help?   Regards John
2717 Mar 2015 @ 11:22 PDTDatabaseReplyNon duplicate row selection queryHi Dnoeth, Unfortunately there is no there key which differentiates the record and which i admit is poor design. Now living wih what we have, we are trying to do a one time activity of loading dis...
2617 Mar 2015 @ 11:20 PDTDatabaseReplyNon duplicate row selection queryHi Ravimans, We do not have any other column that differentiates the records apart from the DIRECT_ID column. Yes we want to select all the distinct records from consumer table and will be a one ...
2517 Mar 2015 @ 04:40 PDTDatabaseReplyNon duplicate row selection queryHi Smarak, Thanks. Not much improvement. I ran the query for almost 15 minutes and then aborted it:( Regards John
2416 Mar 2015 @ 11:30 PDTDatabaseTopicNon duplicate row selection queryHi there, Have a table with 1 billion records in which almost close to half the records are of exact row duplicates. I need to select one record from the set of duplicates and load into another ta...
2316 Mar 2015 @ 09:50 PDTDatabaseReplyBest criteria for selecting NUPIHi Dieter,  I see except the SEQID field there are none other fields which have unique values and hence no primary key. Except this SEQID being defined as Primary Index, there is no other In...
2216 Mar 2015 @ 01:11 PDTDatabaseReplyBest criteria for selecting NUPIHi Dieter, Thanks a lot for your response. So you say, the NUPI defined on the id column is ok, as long as there are no too many rows for that NUPI defined correct? Example below is ok right thou...
2115 Mar 2015 @ 09:56 PDTDatabaseTopicBest criteria for selecting NUPIHi, We have a SET table with NUPI defined on it.I understand this is bad, as it needs to check for the duplicates by scannning the entire row set while data is loaded into the table. The column w...
2014 Mar 2015 @ 02:14 PDTDatabaseReplyChoosing Primary Index for a tableHi Friends, Can you comment on the above? Thanks   Regards John
1913 Mar 2015 @ 07:44 PDTDatabaseTopicChoosing Primary Index for a table     1) The table is a SET table.Product id and Brand is same for both the records, it should still insert into the table as the Active_Dt is different correct? CREATE SET T...

Pages