#DateForumTypeThreadPost
1620 Mar 2015 @ 07:04 PDTDatabaseTopicHow to Skip first COLOUMN from a flatfile and load remaining columns using mload?Hi Experts, How I have an urgent requirement. I need to skip first column from a delimited flat file and load remaining coloumns to my traget table.. Is there any property to skip first COLUMN? ...
1523 Dec 2014 @ 10:18 PSTDatabaseTopicSomething ) Expected Between DESC and RESETHi All,  I have a table as following  Col1 col2  A B  B C  C D  P Q  Q R  R S  X Y  Y Z  Z F  Required o...
1410 Jul 2013 @ 12:28 PDTDatabaseTopicCursor-Getting Error Hi Experts, I am getting following error whlie creating cursor.Please help me.   Create procedure Order_Proc()   Begin Declare K INTEGER default 0; Declare V_TOTAL INTEGER default ...
1310 Jul 2013 @ 12:03 PDTPrivate Forum
1213 Jan 2013 @ 07:15 PSTDatabaseTopic Conversion of oracle query into teraadata query(Row id is not working)Hi All, I have an issue while converting oracle query into teradata.below is the oracle query, select table1.productid,table2.productid,table2.max_rowid from table1,table2 where tabl...
1129 Nov 2012 @ 06:52 PSTGeneralReplyNOPI with Multiset tableHi Dieter, Thanks for reply. Yes, This functionality has been activated on all Teradata servers in our company.   Thanks AmarnathG
1029 Nov 2012 @ 11:40 PSTGeneralTopicNOPI with Multiset tableHi Experts,   In Teradata Database 13.10 is the ability to let Teradata select an appropriate index.  This new feature is called No Primary Index (NOPI).  When a table is created without...
928 Nov 2012 @ 11:45 PSTToolsReplyHow to Find Database name using Proxyid/Service idHi Koti.Thanks for reply. Above Query Valid for username. if i use Proxy id, do we have any query to find out name of the database?   Thanks AmarnathG
821 Nov 2012 @ 09:46 PSTToolsReplyMload table locks cannot be released because NUSI exists Hi feinholz, Thanks a lot for the post!! Could you please explain what are the possible "internal inconsistencies between the primary and its non-unique secondary indexes". I am a ...
721 Nov 2012 @ 08:02 PSTToolsTopicMload table locks cannot be released because NUSI exists Hi All, I had  a problem when i executed mload script. My table has NUPI on some coloumns. The mload script has got failed  and When i try to release the lock on mload target tab...
621 Nov 2012 @ 07:40 PSTToolsReplyHow to Find Database name using Proxyid/Service idi All, Any replies...Thanks
506 Nov 2012 @ 09:56 PSTToolsReplyHow to Find Database name using Proxyid/Service idHi ulrich, In teradata View pont by having session id/username we can find out long running jobs/scripts. I have two questions. 1.There is only one proxy id/username  for every database? 2...
404 Nov 2012 @ 10:56 PSTToolsReplyHow to Find Database name using Proxyid/Service idHi All, Any replies...Thanks
302 Nov 2012 @ 12:39 PDTToolsTopicHow to Find Database name using Proxyid/Service idHi Experts, Could you please let me know the query/process to find database name using Proxy id/Service id. I t would be highly appreciated. Thanks, Amarnath
231 Oct 2012 @ 04:52 PDTToolsReplyQueue tabel in Terra Data Hi Aftab, Thank you so much.Article is very helpful. Can you give one example on this.   Thanks, Amarnath G
130 Oct 2012 @ 08:52 PDTToolsTopicQueue tabel in Terra Data Hello all,   Can any one explain me about queue table in Terra Data with example   Thanx in advance   Amarnath