All forum activity

#DateUserForumTypeThreadPost
94217 May 2006 @ 09:21 PDTNytewyndToolsReplyAccessing Oracle Table from Teradata and vice-a-versaYou 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...
94117 May 2006 @ 04:29 PDTDGiabbaiDatabaseReply10065 WSA E HostUnreachPlease, try connecting through BTEQ to see if you still get the same error
94016 May 2006 @ 10:37 PDTnithyanandamTrainingReplyNR-011 CertificationPreetiTeradata 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...
93916 May 2006 @ 10:23 PDTnithyanandamTrainingReplyTeradata Basic Certification HelpAnuTeradata 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...
93816 May 2006 @ 10:16 PDTnithyanandamDatabaseReply10065 WSA E HostUnreachOkay. 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...
93716 May 2006 @ 11:17 PDTDGiabbaiDatabaseReply10065 WSA E HostUnreachMake 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...
93616 May 2006 @ 08:07 PDTANGELDatabaseReplyQuery to get the last day of each month in a year.Thanks Dieterit worked well
93516 May 2006 @ 08:04 PDTANGELDatabaseReplyQuery to get the last day of each month in a year.Hi,If possible can you give me the exact query.Thanks
93416 May 2006 @ 07:59 PDTdnoethDatabaseReplyQuery 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
93316 May 2006 @ 05:12 PDTTDUser-781DatabaseReplyQuery 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 ...
93216 May 2006 @ 05:06 PDTANGELDatabaseTopicQuery 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---...
93115 May 2006 @ 05:23 PDTvinod_sugurDatabaseTopicPPI explainBelow 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...
93015 May 2006 @ 12:18 PDTJaguarDatabaseTopicHow can we set the environment for Teradata rdbms in unixHi, 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...
92915 May 2006 @ 11:46 PDTJaguarDatabaseTopicAccessing Oracle Table from Teradata and vice-a-versaHi,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...
92815 May 2006 @ 11:13 PDTJaguarToolsTopicAccessing Oracle Table from Teradata and vice-a-versaHi,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...
92715 May 2006 @ 08:54 PDTMyNetHelperConnectivityReplyOLE DB Response FileOk. 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...
92614 May 2006 @ 07:18 PDTnithyanandamDatabaseReply10065 WSA E HostUnreachYes. The ODBC DSN for the SQL Assistant Demo has the address 127.0.0.1 (localhost) in it.
92514 May 2006 @ 02:39 PDTBBR2DatabaseReplyhow to get the primary indexes of all the tables in a user using dbc tablesYou may want to use this SQLSEL* FROM DBC.IndicesWHERE IndexType IN ('P', 'Q);Where P - Accounts for NPPIand Q for PPI tablesVinay
92414 May 2006 @ 02:35 PDTBBR2DatabaseReplyCOLLECT STATISTICSThis 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...
92314 May 2006 @ 04:56 PDTmackDatabaseReplyInsert...Selectits simpleINSERT INTO TABLE_NAME_1 SELECT FIELD_1,...,FIELD_N FROM TABLE_NAME_2 WHERE CONDITION EXPR(specify constraints if any)
92214 May 2006 @ 04:33 PDTDGiabbaiDatabaseReply10065 WSA E HostUnreachIn the ODBC DSN configuration, is there the address 127.0.0.1?
92114 May 2006 @ 01:37 PDTnithyanandamDatabaseReply10065 WSA E HostUnreachOkay. 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...
92012 May 2006 @ 01:39 PDTTimLind53ToolsTopicUsing 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...
91912 May 2006 @ 11:29 PDTDGiabbaiDatabaseReply10065 WSA E HostUnreachAt 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...
91812 May 2006 @ 11:24 PDTseshuDatabaseTopicInsert...Selecti need full syntax of Insert...Select Statement?

Pages