#DateForumTypeThreadPost
1811 May 2010 @ 10:32 PDTDatabaseReplyQuick Q for Dieter Noeth or People who follow DN's Stats query..!!!Hello Dieter, Thanks a lot for the help. I checked using above method and found that we have Linux - 64 bit system. Also the version we are currently on are 12.0.2.44 so I suppose we are fine w...
1710 May 2010 @ 01:23 PDTDatabaseTopicQuick Q for Dieter Noeth or People who follow DN's Stats query..!!!Hello, I have been following the SQL you have developed in my day to day practices. I did come to know that the system we are using here is 64-bit but could not find out how do we know that. Is...
1612 Jan 2010 @ 11:47 PSTToolsTopicInsufficient memory error message - TPUMP Update/Insert.Hi, I am receiveing the following error while executing the TPUMP job: **** 17:04:38 UTY6625 WARNING: Packing has changed to 7 statement(s) per request. **** 17:04:38 UTY6664 PACK factor was ...
1525 Nov 2009 @ 09:13 PSTDatabaseTopicJoin Index on table causing 2616 overflow error.Hello, I have a table that is defined with an Aggregate Join Index. The AJI was created successfully after table was populated with data. But when we try to insert/update the data into the tabl...
1402 Apr 2009 @ 04:05 PDTDatabaseTopicTeradata 12.0 (demo) suddenly hung up.I was using Teradata Manager and suddenly the Teradata Database 12.0 got hung up. I checked the Teradata Service Control and it is just showing up "PDE state is RUN/STARTED" and not "Teradata is ru...
1325 Jul 2008 @ 12:41 PDTDatabaseReplyIMP : New EXPLAIN Terminology[font=Verdana][/font]When joining two PPI tables that have equivalent partition definitions, a Row KeyMatch Scan within partitions can be used to join the tables together. Please specify the follow...
1204 Jun 2008 @ 07:37 PDTDatabaseTopicStored ProcedureHi, I need to write a stored procedure for creating a user on the basis of the values in a temp table. The temp table will have only username column and based on the values in the table. My SP shud...
1131 Jan 2008 @ 04:48 PSTToolsReplyMload a COMP field from mainframeHi varun, I did also have the same file layout once. I suppose you cannot load a COMP value in Teradata. For e.g : a value defined in copybook as S9(9) will be represented as000D0070i.e it will occ...
1031 Jan 2008 @ 03:14 PSTToolsReplyCOMP causing Mload faliureHi Satya, I did also have the same file layout once. I suppose you cannot load a COMP value in Teradata. For e.g : a value defined in copybook as S9(9) will be represented as000D0070 i.e it will ...
923 May 2007 @ 07:11 PDTDatabaseTopicDifference between GTT and Volatile tables..!!Hi, Can anyone let me know some of differences between Global Temp Table & Volatile table and also is there any specific purpose where each can be used???Thank You,
811 May 2007 @ 03:33 PDTToolsTopicFastload via MS-DOS batch fileHi,I have created a batch file as-C:\Program Files\NCR\Teradata Client\Bin\bteq < C:\Documents and Settings\Indrajit Gaikwad\My Documents\School_Project\DDL\School_Master.txt > C:\Documents and Set...
708 May 2007 @ 12:00 PDTDatabaseTopicFastload via Teradata ClientHi,I have Teradata Demo CD installed at my PC. I am trying to fast load a text file into a table by following method:From Start - Programs - Teradata Client - Fastload I run following steps:*******...
608 May 2007 @ 11:29 PDTToolsTopicFastlod via Teradata ClienyHi, I have Teradata Demo CD installed at my PC. I am trying to fast load a text file into a table by following method:From Start - Programs - Teradata Client - Fastload I run following steps:*****...
505 Apr 2007 @ 04:59 PDTDatabaseTopicSelecting the previuos row in a table.Hi, I have a table with following attributes:1. Acct_Num (Decimal 10,0) Not Null2. Prod_Code (Char 5)3. Start_Date (Date format 'yyyy-mm-dd') The index is Acct_Num & not UPI. The table is already ...
401 Nov 2006 @ 07:19 PSTTrainingTopicTeradata BASICS examination..!!Hi, I am planning to take the BASICS exam but someone has suggested me to go for the exam in 2007 since V2R6 is released and if I give the exam for V2R5 now i need to give it again. Please can anyo...
301 Nov 2006 @ 07:18 PSTTrainingTopicTeradata BASICS examination..!!Hi, I am planning to take the BASICS exam but someone has suggested me to go for the exam in 2007 since V2R6 is released and if I give the exam for V2R5 now i need to give it again. Please can anyo...
218 Oct 2006 @ 05:49 PDTJobsReplyTeradata Professional from IndiaHi Manoj, This is indrajit working for Xansa India Ltd. Our company is looking for Teradata candidates onsite (UK).. you can contact me if you wish..
118 Oct 2006 @ 05:41 PDTDatabaseTopicHelp on SET/MULTISET.. plzzHi, I have defined a table 'T1' in staging database which is loaded daily as Multiset.. and the application table 'T2' is defined as SET.. when I try to insert the data from T1 to T2 it takes very ...