#DateForumTypeThreadPost
5127 Jun 2014 @ 03:35 PDTDatabaseTopicGet last day 3 months agoHi,   Just wanted to help out someone if you needed help on this:- 1. To find the last day's date before 3 months from today 2. To find the first day's date before 3 months from to...
5012 May 2014 @ 01:42 PDTDatabaseTopicAdding a local variable as a day interval to a timestamp columnJust wanted to give this tip as I could not find help online.... If you are struck in a situation to add a variable to a timestamp column, you have to cast that variable to that particular interva...
4903 May 2014 @ 08:59 PDTConnectivityReplySpecial Characters in Password Hi,  I have encountered this recently. Not sure about one slingshot answer, but, try doing the following:- 1. Enclose the password in double-quotes. It worked in Arcmain, not in BTEQ. 2. fo...
4831 Jan 2014 @ 01:15 PSTToolsReplyMload - sessions override by DBSYou can find the value that is set in the dbscontrol. The above is not exactly an error and can be overriden by the DBA.
4720 Dec 2013 @ 01:44 PSTDatabaseReplyNeed alternative to DBQL processingThanks Raja. I will try that approach.
4619 Dec 2013 @ 03:31 PSTDatabaseTopicNeed alternative to DBQL processingHello Friends, I have to identify tables that are/were not accessed by any user since the past 6 months or so. The access could be select, update, delete, insert, show or help. If no-one has run a...
4502 Dec 2013 @ 04:36 PSTDatabaseReplyChange DBS Language support modeOkay my friend. Thank you.!
4402 Dec 2013 @ 09:33 PSTDatabaseTopicChange DBS Language support modeHello Friends, Recently, I did a restore on my VM, but, during sysinit, I enabled Japanese support. How do we change the DBS Language support mode? Currently, it is Japanese. I want to make it St...
4326 Nov 2013 @ 08:21 PSTDatabaseReply"cnsrun" rigthsHello friends,  Does anybody have a solution to the same problem mentioned above? I am at the same situation. Apart from logging in as DBC, is there any other way to solve this? Regards,...
4220 Nov 2013 @ 06:12 PSTDatabaseReplyDBC.tvFields.CompressValue does not existThanks Dieter. I used TD- Admin. Yes, the field returns NULL now.  While the restore was happening, I did not do a DIPALL. That must have been the culprit. :( Thanks, SS
4119 Nov 2013 @ 09:22 PSTDatabaseTopicDBC.tvFields.CompressValue does not existHello Friends, I did a restore from Td12 to my TD-14 on VMWare. When I double-click on a table to list the columns inside, I am getting an error:- "Column/Parameter DBC.tvFields.CompressValue...
4015 Nov 2013 @ 01:58 PSTDatabaseReplycan change the perm of DBC?We cannot change the perm of DBC. Modify the sizes from the databases under DBC that are of no importance as per your judgement. (or) Keep using GIVE, MODIFY DATABASE and UPDATE SPACE while check...
3915 Nov 2013 @ 01:48 PSTDatabaseReplyIncrease the size of DBCYes. Thanks Dieter. Even in the 1 TB version, I found DBC to have -ve space and could not complete the post-restore steps happily. So, I set the user databases to 0 sizes and then did an updatespa...
3813 Nov 2013 @ 07:49 PSTDatabaseTopicIncrease the size of DBC Friends, I installed the 40 GB VM version of TD 14. I want to restore my existing DBC (~ 35GB) onto this VM. Is that going to be a problem? Also, how do we increase the space of DBC in V...
3712 Nov 2013 @ 02:32 PSTDatabaseReplycan change the perm of DBC?Dieter & friends, I have another question. I installed the 40 GB VM version of TD 14. I want to restore my existing DBC (~ 35GB) onto this VM. Is that going to be a problem? Also, how do we i...
3628 Sep 2011 @ 07:11 PDTDatabaseReplyTeradata IN List allowable limit Forum members, please reply with your thoughts on this one.
3527 Sep 2011 @ 07:34 PDTDatabaseReplyExtracting Data From volatile table Did you use "ON COMMIT PRESERVE ROWS" while creating the volatile table?
3426 Sep 2011 @ 08:17 PDTDatabaseTopicTeradata IN List allowable limit Hi, From the reporting side, users try to enter values into a text box. This input is then fed to the IN list. The number of values in the IN list ends up containing more than 5000 values/pa...
3322 Jul 2011 @ 03:40 PDTAnalyticsReplyneed SQL help (The Output does not contain correct number of rows)Great answer Sir. that is exactly what happened. We have excellent practices here. Our ETL is getting better day-by-day. Another item gets into the checklist now. Sree
3219 Jul 2011 @ 01:11 PDTAnalyticsReplyneed SQL help (The Output does not contain correct number of rows)The explain in the second case does the join whereas in the first case, there is no join and the output is a straight SELECT from table b. The id field in table A and the id field in table B is...
3119 Jul 2011 @ 10:24 PDTAnalyticsTopicneed SQL help (The Output does not contain correct number of rows)Hi, I need your help on this issue. I have a query between two tables A & B. I get >100 rows in the result set when I write a query as follows:- SELECT A.id, B.id FROM table_a A, t...
3013 Oct 2010 @ 12:21 PDTDatabaseReplySoft RIThanks Dieter & Karam. This helped me today.
2903 Jun 2010 @ 04:12 PDTDatabaseReplyComment string is longer than permitted Hello friends, Same situation about the COMMENT. This is during our efforts to maintain meta data. If my comments are more than 255 characters, what should I do? Is there any other type that...
2806 May 2010 @ 10:21 PDTDatabaseTopicDevising a comprehensive process for "Collect Stats" on the entire EDWHello Friends, I am struck in a wonderful situation. Suppose that I have my TD environment consisting of 720 tables. Of these tables, I have 420 tables that are populated on a periodic basis...
2706 May 2010 @ 10:11 PDTDatabaseReplyHow to compare data from tables in Teradata with tables in OracleBefore migration, collect demographic statistics on the table. We can run few GROUP BY queries and check for the number of distinct values. Examine whether the count values are different or not.

Pages