#DateForumTypeThreadPost
4611 Jul 2013 @ 05:04 PDTDatabaseTopicInformation about Inverted list databaseHi, I have heard that this database can do both set and row processing. Is it true? Where I can get a document on this? Also, I feel that Teradata can also do both. Tpump has serialize option to ...
4505 Jul 2013 @ 02:41 PDTDatabaseTopicGlobal Temporary Table With Multi-Level PartitioningHi, I want to make a Global Temporary or Volatile Table  With multi-Level Partitioning in TD 14, since I will be using the data in the session. I could not see anywhere the syntax.&...
4404 Feb 2010 @ 04:54 PSTDatabaseReplyANSI and BTETHi Supreme,I can try that ..no issue. But company pays me for my result-oriented works..not for error-producing codes.If I know it 100% right in the first shot (getting the right info from the docu...
4304 Feb 2010 @ 12:06 PSTDatabaseReplyANSI and BTETDieter,It is just that I want to see the solution. I guess between the logon and logoff, I cannot change from btet to ansi. Am I right?Thanks and regards,
4203 Feb 2010 @ 08:25 PSTDatabaseReplyANSI and BTETThe script must be run only once and it should be successful.
4103 Feb 2010 @ 01:08 PSTDatabaseTopicANSI and BTETHi,Using bteq, some sql dmls I want to use btet and some I want to use ANSI in the same script. I know how to set it(.set session trans.....). Can we use bt et in first part of the script and once...
4021 Dec 2009 @ 05:11 PSTDatabaseTopicCannot run Teradata Query Scheduler Admin 12.0Hi,I started Teradata service. I try running Teradata Query Scheduler Admin 12.0. It gives an a CLI error.My teradata is working fine.I can query and do all I want but scheduler is not working.Ple...
3921 Dec 2009 @ 02:59 PSTDatabaseReplyDBA work templateHi,Can you please provide a template or existing scripts..if any ..I dont want to work on the GUI.Raja
3817 Dec 2009 @ 05:06 PSTDatabaseTopicDBA work templateHi,Can anyone please pass on a template to determine these requirements:1) The ways to set up to prioritize the queries and if there is any way to see the peak time of jobs.2) What is the number ...
3710 Sep 2009 @ 06:33 PDTToolsReplyI am loading the data into files using fastexport but...Use mode record and format binary.
3628 Aug 2009 @ 01:30 PDTAnalyticsReplyhow to export table values into a file?Hi,Why dont u use script?.... logtable urtablelog;.logon......;.begin export sesions ;.layout ;.field * char(size); .......import infile ;.export format text mode record;select (case when ur...
3527 Aug 2009 @ 01:36 PDTToolsReplyInput types to TPUMP ?Hi,Your file should be input. See what are the paramters you need to set: sessions(min ,max),pack,serialize off/on,checkpoint, robust on/off,monitor after .begin load . Your input should be import...
3425 Aug 2009 @ 01:10 PDTToolsReplyQuery that uses more than 100 columns not working properly through bteqHi,please check the version of teradat you are using. Check the manual. Bteq older than V2R6 limits to 254 as far as I remember.Thanks and regards,Raja
3324 Aug 2009 @ 04:11 PDTUDATopicSOA QuestionsHi,Client has given an estimate of ~60 TB of data in SCD 2 in a span of 5 years. Can you please provide me the sets of questions and answers on SOA...example ....how much power usage,amps, etc etc...
3221 Aug 2009 @ 02:05 PDTDatabaseReplyTeradata stored proceduresHi,I m sorry I dont have a script.Maybe some onlookers have it .Best of luckRaja
3120 Aug 2009 @ 08:17 PDTDatabaseReplyTeradata stored proceduresHi,Lordbwithme2.For your problem, we can have execute , execute immediate. Please let me know the exact syntax once you implemented it.Thanks and regards,Raja
3018 Aug 2009 @ 01:13 PDTDatabaseReplyHow to fetch the data from one server and insert in to other server in SQL Assistance?Hi,As far as I know, there is no dblink in teradata like in oracle. but work arounds are always there.... :)Fastexport ...ftp....and then mload or tpump..... :). Anyone who knows better please sugg...
2918 Aug 2009 @ 01:05 PDTUDAReplyBTEQBTEQ stands for Basic Teradata Query. It comes from Teradata.
2818 Aug 2009 @ 01:03 PDTToolsReplyMload issueHi,Did it work that solution? What I feel is that you can define at table level itself.Thanks and regards,Raja
2714 Aug 2009 @ 02:44 PDTToolsReplyFastload and MultiloadHi,Since it fails in acquistion phase, you dont need to worry. Also double check in target table that nothing is loaded.Just a check.Since it fails it acquisition phase you need to Dropping the res...
2613 Aug 2009 @ 06:33 PDTToolsReplyCOMPILE C PROGRAM IN AIX WITH TERADATA SQLsHi,Bad english is not an issue so long as technology is good :). I suggest you can go to C forum for unix and get the right answer.Rgds,Raja
2512 Aug 2009 @ 01:35 PDTToolsReplyMload IssueHi Kiran, I m not pretty sure. However if the setting "NOSTOP" is given then it restricts mload from stopping if there is an errorcondition for variable-text length record. Check this setting. Seco...
2412 Aug 2009 @ 01:23 PDTUDAReplyMLoad ErrorPaul,I m not sure. You can get the info from the TDBA.Please let me know if you get the info.Thanks and regards,Raja
2311 Aug 2009 @ 02:30 PDTUDAReplywhich row is making err limit exceed errorHi,Di you check the error table for tpump? Also remember in fast load the table must be empty, no SI and no journaling.Thanks and regards,Raja
2207 Aug 2009 @ 04:39 PDTDatabaseReplyPPI codeThanks a lot......Raja K

Pages