#DateForumTypeThreadPost
10121 Jun 2013 @ 04:56 PDTDatabaseReplyUnable to log on minimum number of fastload sessionsCan you please share exact error code and FL script and more detials like how many AMPs on the system, what are the value of DBS control parameter, TASM is enabled or not etc.
10020 Jun 2013 @ 06:20 PDTDatabaseReplyCompression on Indexesyou can't use MVC to compress Partitioning column
9923 May 2013 @ 02:45 PDTUDAReplyTDM vs Other Load UtilitiesI don't think you can use TDM as stand alone utility like other TTU, I guess, it comes as a part managed server. Better is to check with your Teradata account manager
9822 May 2013 @ 02:40 PDTDatabaseReplyPPIPlease don't post any marketing stuff in any techinal disucssion thread or tehnical forum.. it waste other's time ...
9710 May 2013 @ 07:18 PDTDatabaseReplyPPIi m not clear what exactly is your doubt. 1) you can define NUPI with PPI as well 2) order_date and customer_number both can have duplicate values, but there combination should be unique.
9603 May 2013 @ 05:59 PDTDatabaseReplyData Transfer using TPTI am not sure, but I think that Teradata Database Server and Client Utilities licenses are sold separately and all the utilities are not mandatory for any customer to buy. TPT is basicall...
9503 May 2013 @ 04:46 PDTDatabaseReplyTeradata basicsDownload the Book "Introduction to Teradata"  for understaning basic conepts architecture of teradata and  from Below link http://www.info.teradata.com/templates/eSrchResults.c...
9402 May 2013 @ 07:48 PDTGeneralReplyError while replying to a PostYes, I too had a problem with single post, but now it is working. If it happens with others also some time, we should report it to Neil, so that he can report it ...
9302 May 2013 @ 06:52 PDTDatabaseReplyDrop Temporary TablesI guess, we can't use TEMPORARY keyword with ALL
9202 May 2013 @ 04:25 PDTDatabaseReply Arcmain I have used ARCMAIN and TARA and usually they run smoothly. I am not sure what type of objects you are trying to restore. If possible, try copy instead of restore to see if it is successful or not
9102 May 2013 @ 03:49 PDTGeneralTopicError while replying to a PostIt seems that there is some error with below post as when I try to reply to this post it doesn't work. As a database person, I can guess, it is may be because of some locking issue or may be an...
9002 May 2013 @ 03:36 PDTDatabaseReplyCreating a new secondary index on tableIs it a custom table or a system defined DBQL table in DBC ?
8922 Apr 2013 @ 02:46 PDTDatabaseReplyDBQLOBJTBL - unknown valuesI have responed to your original post
8822 Apr 2013 @ 02:45 PDTDatabaseReplyCreating a new secondary index on tableYou Can use SQL like this   SEL * FROM dbc.DBQLObjTbl WHERE ObjectType = 'Idx' AND ObjectNum = 4 /* or whatever is your secondary index number 8, 12, 16 ... */ AND ObjectDatabaseN...
8719 Apr 2013 @ 06:35 PDTDatabaseReplyDBQLOBJTBL - unknown valuesin simple words, the values which are not in the list mentioned in TD14 manual, but you see in your table are actully the sum of any of those values from the list ike 3 = 2 + 1, 6 = 2+ 4 etc. So, ...
8618 Oct 2012 @ 02:10 PDTDatabaseReplyDate ConversionInternally, Teradata does not store Date as in any speicifc Date format, it stores Date value as a four-byte signed integer value dervied based on (YEAR - 1900) * 10000 + (MONTH * 100) + DAY &nb...
8518 Oct 2012 @ 12:27 PDTDatabaseReplyHow to identify tables that have been Block-level compressed using SQLI guess, DBC tables don't store that information.
8417 Oct 2012 @ 11:53 PDTDatabaseReplyRoles - Profiles Best Practices Both serve the different purposes, but they are generally used to help manage Group of common users. Roles are used to manage access rights. You should have at least one role defined for&nbs...
8328 Sep 2012 @ 02:40 PDTGeneralReplyHow to know AMPs and Nodes list from teradata database from working applicationDieter, Is it exact answer: 42 or you want to say  exact answer: 2   I m not clear
8228 Sep 2012 @ 02:37 PDTTrainingReplyTeradata 12 CertificationGo to Teradata Certification home page http://www.teradata.com/tcpp/teradata-12-certification-exams/ and click on Exam Objectives
8128 Sep 2012 @ 01:59 PDTGeneralReplyEmail notifications now availablei am not able to see e-mail icon, i m using IE 8  
8028 Sep 2012 @ 01:13 PDTUDAReplyThe input table can't be compressedhave you been successful to compress any table, if not first check your DBS Control setting. Few parameters needs to set before using BLC. If you are getting error for any particular table. Please...
7927 Sep 2012 @ 02:37 PDTDatabaseReplyHow to check if data is in upper case or notThis will tell you only wheather your first char is in uppercase or not
7827 Sep 2012 @ 02:21 PDTDatabaseReplyStrange(?) error creating FK constraints I have explored several dbc tables/view, but couldn't find any table/column which store this information    
7726 Sep 2012 @ 10:24 PDTDatabaseReplyHelp required in querying dbc tables I don't think, you can get this info through any of the DBC tables. I am not sure if any of the databse utilities have any such command, but I'll check. There is one way through whic...

Pages