#DateForumTypeThreadPost
1303 Aug 2006 @ 03:01 PDTDatabaseReplySpool Space IssuesI just ran into a similar problem the other day. It had to do with the fact that Teradata's plan was left outer joining to my dimension table on the step where I still had millions of rows, rather...
1202 Aug 2006 @ 11:12 PDTDatabaseReplyceil function in oracle!That is close, but it adds 1 to numbers that are already integers. If you pass in 2, you should get 2 back. I changed it so it checks to see if NUM is already the equivalent of it's integer value...
1123 May 2006 @ 08:12 PDTDatabaseReplyImporting data from excel using the insert statementIf you have the file in excel, you can create a column that uses the concatenate function to build your insert statements.=concatenate("insert into cs.tag_table2 (field1, field2) values (",A1,",",B...
1017 May 2006 @ 02:06 PDTConnectivityReplyMS Access repeating Selects via ODBCIn oracle, I created an application that allowed the users to upload their tables into their schema using access and ODBC, then in a web application they could pick their tables from a drop down bo...
917 May 2006 @ 09:32 PDTConnectivityReplyMS Access repeating Selects via ODBCIn general, running queries through Access is not going to be very efficient, especially over an ODBC connection. Can you move your Access table into Teradata and run the query on the server? You...
817 May 2006 @ 09:21 PDTToolsReplyAccessing 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...
709 May 2006 @ 02:24 PDTUDAReplyImporting Data from Teradata to OracleYou can set up a Oracle heterogeneous service to connect to teradata through an ODBC connection, and then create a DBLink right to Teradata.You can use the DBMS_HS_PASSTHROUGH functions to run nati...
628 Apr 2006 @ 09:40 PDTDatabaseReplyCalculate hours(date_1 - date_2) * 24
528 Apr 2006 @ 09:34 PDTDatabaseReplyPopulating column with constant day-of-week value?select calendar_datefrom sys_calendar.calendarwhere day_of_week = 6 and calendar_date between date -6 and date
428 Apr 2006 @ 09:21 PDTToolsReplyPivot a table with SQLThe only way to do what you are asking about is with dynamic SQL. If you wanted a pivot showing sales by department by year, you might not know how many departments or years there are. You would ...
328 Apr 2006 @ 09:15 PDTToolsTopicBTEQI am an Oracle developer that recently starting using Teradata. I would like to use BTEQ but the only tool I have installed is Queryman (an old version at that).What product do I need to install t...
203 Jan 2006 @ 09:23 PSTDatabaseReplyPassing the value for an IN clause to a stored procedure.Very helpful. Tagging for later.
129 Dec 2005 @ 02:33 PSTDatabaseTopicGateway portsI'm not very familiar with Teradata, but I need to connect an Oracle DB link to Teradata over a network and through a firewall. I know what I need to do on every step except the connection to tera...