All forum activity

#DateUserForumTypeThreadPost
64228 Mar 2006 @ 11:50 PSTJerryJobsTopicECTL Developer position -- TeradataRate: Open -- client will pay expensesStart Date : 10-APR-2006 End Date : 31-AUG-2006 Work Location : NYC, NY Job Title : ECTL Developer II Job Description : This individual specializes in buildin...
64128 Mar 2006 @ 10:36 PSTBBR2DatabaseReplynumber of CPUs per nodeJim,Thanks for highlighting. I forgot to include the RSS logging information in my earlier post.But I think you gave more information.Thanks,Vinay
64028 Mar 2006 @ 06:49 PSTakhil.bansal@gmail.comDatabaseReply10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkHi Vinay, How the use of DNS server for resolving the IP address can solve the problem ?I am facing the similar kind of problem where my ASP.Net application uses which OLE Db provider for Teradata...
63928 Mar 2006 @ 06:45 PSTakhil.bansal@gmail.comConnectivityTopicTeradata Server not Found errorHi,My ASP.Net application uses OLE Db provider for Teradata to connect to Teradata Server on unix box. During weekdays application works fine however during weekends it starts giving the error whic...
63828 Mar 2006 @ 06:24 PSTManoj_Kumar_ParmarToolsTopicFile format mismatchGroup,we are exporting records in a flat file through bteq utility, but while exporting it we are getting the following Errorie. File Format Mismatch.I want to know when this error should occour, p...
63727 Mar 2006 @ 11:57 PSTFredUDAReplyDefault spacesIn my test example, I included ten spaces after the word Long for this statement:insert into showVarchar values (2, 'Long ');Somehow it appears to have been truncated to a single blank in the post....
63627 Mar 2006 @ 09:31 PSTyoungDatabaseReplysth wrong when logon on BTEQsucceeded :-)
63527 Mar 2006 @ 08:15 PSTDennis-2569JobsReplyTeradata Professional needed (South Africa)Hi Teradata Job Seekers,Here after don't send your resumes to commercial email-id's like yahoo, Hotmail, gmail etc.,You will never get a call/reply mail,Regards,Dennis
63427 Mar 2006 @ 08:08 PSTDennis-2569JobsReplyTeradata Professional needed (South Africa)---------- Forwarded message ----------From: Bhanu Shekhar Date: 23 Mar 2006 06:36:01 -0000Subject: Re: So you are genuine?To: Dennis Yes I am , it usually take some time when there is backlog of a...
63327 Mar 2006 @ 05:35 PSTJerryJobsTopicSiebel ETL SAS Developer Needed: Charlotte, NCTitle: ETL Specialists Developer/AnalystLocation: CharlotteDuration: 12 monthsAvg hours/wk: 40Rate: Open (just tell me what your desired pay is, and if its reasonable, thats what rate we'll use!)MU...
63227 Mar 2006 @ 02:48 PSTJim ChapmanDatabaseReplynumber of CPUs per nodeI think that method would work only if RSS logging is turned on. I suppose the most general method would be to look up the hardware specs for your server nodes. If those are not available for som...
63127 Mar 2006 @ 11:58 PSTBBR2DatabaseReplySyntax to Create a surrogate keyKhab,CSUM function are retained for backword compatibility (i think).It is best if we use Ordered Analytical functions.Vinay
63027 Mar 2006 @ 11:55 PSTBBR2DatabaseReplynumber of CPUs per nodeTry this sel distinct NodeId, NCPUs from DBC.ResGeneralInfoView;Vinay
62927 Mar 2006 @ 10:47 PSTshaik.feroz@aaa-calif.comDatabaseReplyNeed to identigy Primary key from a table using SelectThank you very much Dieter for the post.I am sorry for the answer i gave. Good to know this info.
62827 Mar 2006 @ 08:21 PSTRenato DbaDatabaseReplynumber of CPUs per nodeHi,exist many way's for verify this.1 - Verify systems tables or open PMON and verify on the first screen (right superior side) "PentPro" ...Click in the box and verify nodes by CPU....
62727 Mar 2006 @ 07:46 PSTShefaliDatabaseTopicnumber of CPUs per nodeI know that my teradata database has got 2 nodes and 12 Amps. How can I find out the number of CPUs in each node?
62627 Mar 2006 @ 07:42 PSTTD_ArchDatabaseReplysth wrong when logon on BTEQAdd the following line to your hosts file:YOUR_COMP_IP_Address demotdat demotdatcop1to get your comp ip, type in ipconfig from cmd, and you will get it.
62527 Mar 2006 @ 05:51 PSTyoungDatabaseTopicsth wrong when logon on BTEQhere is hosts file:127.0.0.1 localhost DemoTDATcop1127.0.0.1 jiangyo but when I tried to log betq using command:.logon DemoTDAT/dbc,dbc;the system report error:*** CLI error: MTDP: EM_...
62427 Mar 2006 @ 05:51 PSTyoungDatabaseTopicsth wrong when logon on BTEQhere is hosts file:127.0.0.1 localhost DemoTDATcop1127.0.0.1 jiangyo but when I tried to log betq using command:.logon DemoTDAT/dbc,dbc;the system report error:*** CLI error: MTDP: EM_...
62327 Mar 2006 @ 05:50 PSTyoungDatabaseTopicsth wrong when logon on BTEQhere is hosts file:127.0.0.1 localhost DemoTDATcop1127.0.0.1 jiangyo but when I tried to log betq using command:.logon DemoTDAT/dbc,dbc;the system report error:*** CLI error: MTDP: EM_...
62227 Mar 2006 @ 05:19 PSTpoonamDatabaseTopicnumber of rows returned..rowcounthi,how do i get the rowcount or the number of rows affected by the last query?somethign like rowcount in oracle.
62127 Mar 2006 @ 02:05 PSTManoj_Kumar_ParmarToolsReplyO/p file headingHi All,If any body requires more clarification, kindly revert me back as early as possible.Regards
62026 Mar 2006 @ 11:19 PSTkhabDatabaseReplySyntax to Create a surrogate keyYou can use the CSUM function for this.
61926 Mar 2006 @ 10:23 PSTdnoethDatabaseReplyNeed to identigy Primary key from a table using SelectHi Rishab,if the table was created with a Primary Key constraint, it has been replaced by a UPI/USI. There's a PrimaryKeyIndexId in dbc.tables, which indicates the original PK and relates to dbc.in...
61825 Mar 2006 @ 03:26 PSTshrikrishnaDatabaseReplyURGENT:how to find col names and its values matching to my conditionThank you very much!!!

Pages