| 69 | 03 Jan 2006 @ 01:09 PST | XTUPIE | Database | Reply | table size without indexes | HiI generally use the following query to determine table sizes.select databasename, tablename, sum(currentperm)from dbc.tablesize where databasename = 'DBA' and tablename = 'testing' group by... |
| 68 | 03 Jan 2006 @ 01:02 PST | XTUPIE | Database | Reply | String Replacement | HiI agree, I have tried using a normal Update "update dba.testing set linea = 'or' where linea like '%and%' ;"But one gets a duplicate error. You can do this with a program or a UDF.Divvy |
| 67 | 02 Jan 2006 @ 03:36 PST | Dennis Calkins | Database | Reply | Union query 2616 error | Make them the same type..sel cast(127 as Integer) from customerunionsel cast(131 as Integer) from customer; |
| 66 | 02 Jan 2006 @ 03:33 PST | Dennis Calkins | Database | Reply | table size without indexes | From screen 6 of the DBW program. start ferretthis will start the Ferret application in one of the DBW application windows.at the ferret prompt typescope table "mydatabase.mytable" 0showblocks qu... |
| 65 | 02 Jan 2006 @ 12:06 PST | vinod_sugur | Database | Topic | Union query 2616 error | select 127 from customerunionselect 131 from customerThe above query generates the subject mentioned the qorkaround is typecast the value 127 to Integer. the reason for the error is the value 127 i... |
| 64 | 02 Jan 2006 @ 10:03 PST | phil1212 | Database | Topic | table size without indexes | Hi folks and hapy new year,Could you tell me how can i get the exact table size, but without indexes size ?select sum(currentperm) from dbc.allspace where databasename = 'XXXX' and tablename = 'MAT... |
| 63 | 02 Jan 2006 @ 08:12 PST | khab | Database | Reply | String Replacement | Hi Akhil,There is no such finction avaliable in TD, but you can make your work easy with UDF. There is a Oracle UDF which can do this job. I guess you can find the UDFs at www.teradata.com-Cheers |
| 62 | 02 Jan 2006 @ 05:45 PST | nellaivijay | Database | Reply | Teradata Error 2621 - Bad character in format or data of {table nm} column 7 | Hi,I hope that following modified query would work fine, because you missed out the reference name of the table.UPDATE B2B_SubsFROM (SELECT duns_loc_num1 ,bus_nm2, loc_emp_tot, naics_desc1,ult_num... |
| 61 | 02 Jan 2006 @ 05:16 PST | akhil.bansal@gmail.com | Database | Topic | String Replacement | Hi,Is there is a way to replace a particular in a column with another character ?Support a Column values likeYahoo and HotMailHotMail and YahooYahoo and GMailGMail and HotMailI would like to replac... |
| 60 | 29 Dec 2005 @ 02:33 PST | Nytewynd | Database | Topic | Gateway ports | I'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... |
| 59 | 21 Dec 2005 @ 11:24 PST | Matt W. | Database | Topic | Passing the value for an IN clause to a stored procedure. | I'd like to create a stored procedure that can accept a string with multiple values as a parameter, and then put that into an IN clause in the query. Here's an example of what I'm trying to do:CRE... |
| 58 | 20 Dec 2005 @ 09:58 PST | marcmc | Analytics | Topic | interoperability with email and sms | Hi,My company is seriously considering translating from SqlServer 2k to TeraData after christmas. I have written an vb.net/sql application that incorporates emailing and subsequent sms notification... |
| 57 | 20 Dec 2005 @ 05:30 PST | Nageswarareddy Earasi | Tools | Topic | SQL Query - DBQL table | HI,We are not getting full SQL from DBQL tables.We are able to findout only 200 Charecters of that Query.Please let us know, how can we find the full SQL Query from DBQL table.Regards,Nagesh Earasi. |
| 56 | 15 Dec 2005 @ 04:58 PST | Steve Paulus | UDA | Topic | Opportunity | I hope I am not out of line in posting a job opportunity in this forum. If so, would anyone know of a more acceptable way? I was doing some research on Teradata.com and came across this Teradata D... |
| 55 | 15 Dec 2005 @ 09:31 PST | M@_Lorinha | Analytics | Topic | Read data from txt file using Procedure/function in Teradata ?? | How read data from txt file using Procedure/function in Teradata like UTL_FILE in Oracle???? |
| 54 | 09 Dec 2005 @ 11:56 PST | rgans_99 | Tools | Topic | Oracle to Teradata Migration | Hi,I tried to load Teradata from Oracle table.Look at the following code---------------------------------------------//To write Oracle table data into a flat file//dept.sql (Oracle)----------------... |
| 53 | 07 Dec 2005 @ 06:21 PST | rajgowda | Tools | Topic | FastLoad Checkpoint | Hi,I am writing a fastload job script to load data into target table.If I include checkpoint option will it be useful.Thanks and Regards,Gowda C H |
| 52 | 06 Dec 2005 @ 07:52 PST | iliakn | Third Party Software | Topic | WII | Does somebody know about using WII with Teradata in the efficient way? |
| 51 | 01 Dec 2005 @ 06:40 PST | rajgowda | Training | Topic | Number Data Type | Hi I am loading data from oracle to Teradata table, one of the source column having data type Number in oracle which contains data having length of 30 digits.In Teradata for the same column the da... |
| 50 | 29 Nov 2005 @ 03:29 PST | Natalia | Tools | Topic | Secure Copy | Hi!I need to transfer files from Unix Teradata MP-Ras to Linux.Someone knows about secure copy? and how I can get it to MP-ras?Thanks a lot.Natalia. |
| 49 | 29 Nov 2005 @ 04:24 PST | phil1212 | Database | Topic | Is it normal ? | INCREDIBLE ...the context :the batch jobs insert/update datas with transaction:begin transactionlock table tutu for write ;insert ..update ......end transactionWe have view with lock row for access... |
| 48 | 29 Nov 2005 @ 03:31 PST | giri | Jobs | Topic | looking for job: advanced teradata certified professional | ok |
| 47 | 28 Nov 2005 @ 05:37 PST | sharad | Connectivity | Topic | Problem with Linux TeraJDBC.03.02.00.03 driver. | Hi,Facing some error with TeraJDBC driver.I have Linux 7.2 machine with JDK 1.5 installed. Recently i installed TeraJDBC.03.02.00.03 driver. Through sample java files,provided with the installable,... |
| 46 | 26 Nov 2005 @ 09:18 PST | rgans_99 | Database | Topic | Insert-Select | Hi,I want to insert the records from an existing table to new tables.I would like to know the time taken when I use Insert-Select stmt.But I could not estimate this using EXPLAIN.Is there a way out... |
| 45 | 22 Nov 2005 @ 07:51 PST | singleamp | Database | Topic | Comparing COLLECT STATS/INDEXES/DDL between Databases | Hi All,We have two databases (DEV_RETAIL and TEST_RETAIL) used for different loads in the same Teradata Box. Different people are using these environments and before promoting the stuff from DEV_RE... |
