942 | 17 May 2006 @ 09:21 PDT | Nytewynd | Tools | Reply | Accessing Oracle Table from Teradata and vice-a-versa | You don't need the transparent gateway. You can do the same thing with heterogeneous services. Install the teradata ODBC driver on your database server, and then you configure a listener to point... |
941 | 17 May 2006 @ 04:29 PDT | DGiabbai | Database | Reply | 10065 WSA E HostUnreach | Please, try connecting through BTEQ to see if you still get the same error |
940 | 16 May 2006 @ 10:37 PDT | nithyanandam | Training | Reply | NR-011 Certification | PreetiTeradata documentation which comes with the Demo CD should be almost sufficient for you to clear any exams. I don't think, people would create dumps for Teradata certification just as they do... |
939 | 16 May 2006 @ 10:23 PDT | nithyanandam | Training | Reply | Teradata Basic Certification Help | AnuTeradata documentation PDF's are the best you can look into while preparing for your basics certification. I'd suggest you go through the "Introduction to Teradata RDBMS" completely and take som... |
938 | 16 May 2006 @ 10:16 PDT | nithyanandam | Database | Reply | 10065 WSA E HostUnreach | Okay. My hosts file looks like this:127.0.0.1 localhost demo DemoTDATcop1I created a new dsn in the name of demo, IP as 127.0.0.1 username/password as dbc/dbcI also modified the dsn in the T... |
937 | 16 May 2006 @ 11:17 PDT | DGiabbai | Database | Reply | 10065 WSA E HostUnreach | Make sure that the alias name in the hosts file is no more than 8 characters long...My line of aliases looks like this:127.0.0.1 localhost demo democop1 DemoTDAT DemoTDATcop1and I use the aliase... |
936 | 16 May 2006 @ 08:07 PDT | ANGEL | Database | Reply | Query to get the last day of each month in a year. | Thanks Dieterit worked well |
935 | 16 May 2006 @ 08:04 PDT | ANGEL | Database | Reply | Query to get the last day of each month in a year. | Hi,If possible can you give me the exact query.Thanks |
934 | 16 May 2006 @ 07:59 PDT | dnoeth | Database | Reply | Query to get the last day of each month in a year. | Hi Angel,where hire_date = add_months(hire_date,1) - extract(day from add_months(hire_date,1))Dieter |
933 | 16 May 2006 @ 05:12 PDT | TDUser-781 | Database | Reply | Query to get the last day of each month in a year. | Hi,what about joining your empl table with sys_calendar.calendar on employee_date = the last day of every month? Obviously you have to extract from sys_calendar.calendar view the last day for each ... |
932 | 16 May 2006 @ 05:06 PDT | ANGEL | Database | Topic | Query to get the last day of each month in a year. | hi,I have a empl table. i want to get a report for all those employees who joined on the last day of each month. Let's say for year 2005all employees who joined on 31st jan, 28 th feb, 31 march---... |
931 | 15 May 2006 @ 05:23 PDT | vinod_sugur | Database | Topic | PPI explain | Below are the two tables created vinod_5 and vinod_6, the problem is of those two queries where if all the PI are considered and only four columns specified in the (2nd ) query then the explain pla... |
930 | 15 May 2006 @ 12:18 PDT | Jaguar | Database | Topic | How can we set the environment for Teradata rdbms in unix | Hi, I need to set up a environment file for Teradata rdbms in unix.I will call this environment file whenever i need to get data from teradata tables in unix..Can some one help with this?Any sett... |
929 | 15 May 2006 @ 11:46 PDT | Jaguar | Database | Topic | Accessing Oracle Table from Teradata and vice-a-versa | Hi,I need to put data in a Oracle table picking data from a Teradata table and vice-a-versa i.e Load Oracle table using data from Teradata table.Is that possible.Is there some kind of a DBLINK betw... |
928 | 15 May 2006 @ 11:13 PDT | Jaguar | Tools | Topic | Accessing Oracle Table from Teradata and vice-a-versa | Hi,I need to put data in a Oracle table picking data from a Teradata table and vice-a-versa i.e Load Oracle table using data from Teradata table.Is that possible.Is there some kind of a DBLINK betw... |
927 | 15 May 2006 @ 08:54 PDT | MyNetHelper | Connectivity | Reply | OLE DB Response File | Ok. I would have bet money that I did this before posting, but this does work. There were a few things that have to be specific.Create the file:setup.exe /r /f1c:\temp\teradata\ole.issInstall usi... |
926 | 14 May 2006 @ 07:18 PDT | nithyanandam | Database | Reply | 10065 WSA E HostUnreach | Yes. The ODBC DSN for the SQL Assistant Demo has the address 127.0.0.1 (localhost) in it. |
925 | 14 May 2006 @ 02:39 PDT | BBR2 | Database | Reply | how to get the primary indexes of all the tables in a user using dbc tables | You may want to use this SQLSEL* FROM DBC.IndicesWHERE IndexType IN ('P', 'Q);Where P - Accounts for NPPIand Q for PPI tablesVinay |
924 | 14 May 2006 @ 02:35 PDT | BBR2 | Database | Reply | COLLECT STATISTICS | This is a comment on the 4th answerActually you can collect statistics on a selected % of tables rows.You may use "USING SAMPLE" qualifier for collecting statistics on % of table rows.There are som... |
923 | 14 May 2006 @ 04:56 PDT | mack | Database | Reply | Insert...Select | its simpleINSERT INTO TABLE_NAME_1 SELECT FIELD_1,...,FIELD_N FROM TABLE_NAME_2 WHERE CONDITION EXPR(specify constraints if any) |
922 | 14 May 2006 @ 04:33 PDT | DGiabbai | Database | Reply | 10065 WSA E HostUnreach | In the ODBC DSN configuration, is there the address 127.0.0.1? |
921 | 14 May 2006 @ 01:37 PDT | nithyanandam | Database | Reply | 10065 WSA E HostUnreach | Okay. Thanks for the initiative taken by you all.I tried all the commands you've mentioned in the command prompt.And the message I get is:C:\Documents and Settings\Nithyanandam>pdestatePDE state is... |
920 | 12 May 2006 @ 01:39 PDT | TimLind53 | Tools | Topic | Using WHERE & JOIN in MLOAD INSERT? | I want to load data from an external file into a Teradata table and restrict the data to only those records that already exist in a previously loaded Teradata table.For example; I have two files:Fi... |
919 | 12 May 2006 @ 11:29 PDT | DGiabbai | Database | Reply | 10065 WSA E HostUnreach | At the command prompt, type "pdestate" (and hit enter). if the message is not "RUN/STARTED", then you'd probably have to start the RDBMS...To start the Teradata RDBMS, type the following commands a... |
918 | 12 May 2006 @ 11:24 PDT | seshu | Database | Topic | Insert...Select | i need full syntax of Insert...Select Statement? |