642 | 28 Mar 2006 @ 11:50 PST | Jerry | Jobs | Topic | ECTL Developer position -- Teradata | Rate: 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... |
641 | 28 Mar 2006 @ 10:36 PST | BBR2 | Database | Reply | number of CPUs per node | Jim,Thanks for highlighting. I forgot to include the RSS logging information in my earlier post.But I think you gave more information.Thanks,Vinay |
640 | 28 Mar 2006 @ 06:49 PST | akhil.bansal@gmail.com | Database | Reply | 10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this network | Hi 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... |
639 | 28 Mar 2006 @ 06:45 PST | akhil.bansal@gmail.com | Connectivity | Topic | Teradata Server not Found error | Hi,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... |
638 | 28 Mar 2006 @ 06:24 PST | Manoj_Kumar_Parmar | Tools | Topic | File format mismatch | Group,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... |
637 | 27 Mar 2006 @ 11:57 PST | Fred | UDA | Reply | Default spaces | In 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.... |
636 | 27 Mar 2006 @ 09:31 PST | young | Database | Reply | sth wrong when logon on BTEQ | succeeded :-) |
635 | 27 Mar 2006 @ 08:15 PST | Dennis-2569 | Jobs | Reply | Teradata 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 |
634 | 27 Mar 2006 @ 08:08 PST | Dennis-2569 | Jobs | Reply | Teradata 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... |
633 | 27 Mar 2006 @ 05:35 PST | Jerry | Jobs | Topic | Siebel ETL SAS Developer Needed: Charlotte, NC | Title: 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... |
632 | 27 Mar 2006 @ 02:48 PST | Jim Chapman | Database | Reply | number of CPUs per node | I 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... |
631 | 27 Mar 2006 @ 11:58 PST | BBR2 | Database | Reply | Syntax to Create a surrogate key | Khab,CSUM function are retained for backword compatibility (i think).It is best if we use Ordered Analytical functions.Vinay |
630 | 27 Mar 2006 @ 11:55 PST | BBR2 | Database | Reply | number of CPUs per node | Try this sel distinct NodeId, NCPUs from DBC.ResGeneralInfoView;Vinay |
629 | 27 Mar 2006 @ 10:47 PST | shaik.feroz@aaa-calif.com | Database | Reply | Need to identigy Primary key from a table using Select | Thank you very much Dieter for the post.I am sorry for the answer i gave. Good to know this info. |
628 | 27 Mar 2006 @ 08:21 PST | Renato Dba | Database | Reply | number of CPUs per node | Hi,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.... |
627 | 27 Mar 2006 @ 07:46 PST | Shefali | Database | Topic | number of CPUs per node | I know that my teradata database has got 2 nodes and 12 Amps. How can I find out the number of CPUs in each node? |
626 | 27 Mar 2006 @ 07:42 PST | TD_Arch | Database | Reply | sth wrong when logon on BTEQ | Add 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. |
625 | 27 Mar 2006 @ 05:51 PST | young | Database | Topic | sth wrong when logon on BTEQ | here 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_... |
624 | 27 Mar 2006 @ 05:51 PST | young | Database | Topic | sth wrong when logon on BTEQ | here 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_... |
623 | 27 Mar 2006 @ 05:50 PST | young | Database | Topic | sth wrong when logon on BTEQ | here 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_... |
622 | 27 Mar 2006 @ 05:19 PST | poonam | Database | Topic | number of rows returned..rowcount | hi,how do i get the rowcount or the number of rows affected by the last query?somethign like rowcount in oracle. |
621 | 27 Mar 2006 @ 02:05 PST | Manoj_Kumar_Parmar | Tools | Reply | O/p file heading | Hi All,If any body requires more clarification, kindly revert me back as early as possible.Regards |
620 | 26 Mar 2006 @ 11:19 PST | khab | Database | Reply | Syntax to Create a surrogate key | You can use the CSUM function for this. |
619 | 26 Mar 2006 @ 10:23 PST | dnoeth | Database | Reply | Need to identigy Primary key from a table using Select | Hi 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... |
618 | 25 Mar 2006 @ 03:26 PST | shrikrishna | Database | Reply | URGENT:how to find col names and its values matching to my condition | Thank you very much!!! |