All forum activity

#DateUserForumTypeThreadPost
6702 Jan 2006 @ 03:36 PSTDennis CalkinsDatabaseReplyUnion query 2616 errorMake them the same type..sel cast(127 as Integer) from customerunionsel cast(131 as Integer) from customer;
6602 Jan 2006 @ 03:33 PSTDennis CalkinsDatabaseReplytable size without indexesFrom 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...
6502 Jan 2006 @ 12:06 PSTvinod_sugurDatabaseTopicUnion query 2616 errorselect 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...
6402 Jan 2006 @ 10:03 PSTphil1212DatabaseTopictable size without indexesHi 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...
6302 Jan 2006 @ 08:12 PSTkhabDatabaseReplyString ReplacementHi 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
6202 Jan 2006 @ 05:45 PSTnellaivijayDatabaseReplyTeradata Error 2621 - Bad character in format or data of {table nm} column 7Hi,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...
6102 Jan 2006 @ 05:16 PSTakhil.bansal@gmail.comDatabaseTopicString ReplacementHi,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...
6029 Dec 2005 @ 02:33 PSTNytewyndDatabaseTopicGateway 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...
5921 Dec 2005 @ 11:24 PSTMatt W.DatabaseTopicPassing 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...
5820 Dec 2005 @ 09:58 PSTmarcmcAnalyticsTopicinteroperability with email and smsHi,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...
5720 Dec 2005 @ 05:30 PSTNageswarareddy EarasiToolsTopicSQL Query - DBQL tableHI,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.
5615 Dec 2005 @ 04:58 PSTSteve PaulusUDATopicOpportunityI 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...
5515 Dec 2005 @ 09:31 PSTM@_LorinhaAnalyticsTopicRead 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????
5409 Dec 2005 @ 11:56 PSTrgans_99ToolsTopicOracle to Teradata MigrationHi,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)----------------...
5307 Dec 2005 @ 06:21 PSTrajgowdaToolsTopicFastLoad CheckpointHi,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
5206 Dec 2005 @ 07:52 PSTiliaknThird Party SoftwareTopicWIIDoes somebody know about using WII with Teradata in the efficient way?
5101 Dec 2005 @ 06:40 PSTrajgowdaTrainingTopicNumber Data TypeHi 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...
5029 Nov 2005 @ 03:29 PSTNataliaToolsTopicSecure CopyHi!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.
4929 Nov 2005 @ 04:24 PSTphil1212DatabaseTopicIs 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...
4829 Nov 2005 @ 03:31 PSTgiriJobsTopiclooking for job: advanced teradata certified professionalok
4728 Nov 2005 @ 05:37 PSTsharadConnectivityTopicProblem 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,...
4626 Nov 2005 @ 09:18 PSTrgans_99DatabaseTopicInsert-SelectHi,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...
4522 Nov 2005 @ 07:51 PSTsingleampDatabaseTopicComparing COLLECT STATS/INDEXES/DDL between DatabasesHi 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...
4417 Nov 2005 @ 12:03 PSTnitinrpAnalyticsTopicEXcel to TeradataHi ,I have an Excel file with 1000 records ,i want to get these 1000 records to be loaded in teradata.Does any one know how to get this done and which utility will help me to get the excel file to ...
4301 Nov 2005 @ 09:43 PSTSandiUDATopicData retrieval queryHi all,I want to retrieve last 3 months data from a table,in which datas are loading daily. I have a query but it is retrieving last 3months data + data loaded till current day.But I need only last...

Pages