#DateForumTypeThreadPost
1905 Sep 2007 @ 10:07 PDTDatabaseReplyIs Teradata a RDBMS?Yes, Teradata is a Relational database management system (its a database like Oracle) used to run the world's largest commercial databases. Its of 100 Terabytes (now days Teradata systems can scale...
1802 Sep 2007 @ 10:19 PDTDatabaseReplyWhat does Sessions means?Hi Rishi,Session means the number of logical link between the application (Teradata database) and the User.Command: [.SET SESSIONS 8;]It creates 8 logical links between the application and the user...
1702 Sep 2007 @ 10:13 PDTDatabaseReplystring to timestamp(0) convesionHi Feroz,Try this one,Query: SELECT CAST([COLUMN_NAME] AS TIMESTAMP(0) FORMAT 'Y4-MM-DDBHH:MI:SSBZ') FROM DBC.[TABLE_NAME]STRATION
1607 Jun 2007 @ 11:14 PDTToolsReply.OLE DB for TeradataHi Crusader,This is the link where you can download drivers for OLE DB:http://www.teradata.com/t/page/130536Stration.
1530 May 2007 @ 12:33 PDTDatabaseReplyIndex qualifaer.Hi,No, you should not add a qualifier to Index.Instead of, you should add (User name to table name as) a qualifier if you have two or more tables at different users. Fire this query and see the res...
1429 May 2007 @ 11:40 PDTDatabaseReplyIndex qualifaer.Hi,Try this one, exactly it helps,For User-1:CREATE INDEX IE1_COUNTRY(COUNTRYCODE) ON USER1.COUNTRY;Regards,Stration.
1328 May 2007 @ 10:41 PDTDatabaseReplyIndex qualifaer.Hi,Try this one,CREATE INDEX IE1_INDEXNAMEE (COLUMN_NAME) ON (TABLE_NAME);Regards,Stration.
1216 Apr 2007 @ 10:08 PDTToolsReplysessionsHi Giri,The Logical link between the Application and User is called Session(s), (This is for respect to User).Stration.
1120 Feb 2007 @ 09:23 PSTDatabaseReplyNeed to delete duplicate records from tableHi LaskarHere is the SQL to delete duplicate records,DELETE FROM TABLE_NAME AWHERE ROWID ( SELECT MAX(ROWID) or MIN(ROWID) FROM TABLE_NAME B WHERE A.COLUMN_NAME = B.COLUMN_NAME);Stration
1014 Jul 2006 @ 10:21 PDTDatabaseTopicRetriving distinct values from column cellHi Guru's,In my table - in a particular column the records are stored in this way, for ex: Dept_ID--------10,20,10,30,20,30,40,10,40I need to get the distinct value for this column, the output I ne...
914 Jul 2006 @ 05:42 PDTDatabaseTopicDelete first record in a tableHi Teradata Guru's,Is there any way to delete the first record in a table, by using delete statement & we should not use any column name.To be more specific:====================select * from table ...
829 Jun 2006 @ 09:26 PDTDatabaseReplyHow do you declare a variable in Teradata SQL?Matt,Could you please post the T-SQL code, I am interested to learn how its working.ThanksStration
714 Mar 2006 @ 12:54 PSTToolsReplyAlert by Email during mload errorMr.Swamy,Could you please elaborate the steps, explain how to configure OS to get alert by email & also include any scripts that you have executed.Stration
623 Feb 2006 @ 05:01 PSTToolsReplyBteq in Report formatHi Manoj,Please follow the steps to meet your requirements, you may specify file command in export rather than report command(as you have already mentioned "changing the report in "REPORT" Format t...
523 Feb 2006 @ 03:58 PSTDatabaseReplyMaterialized view in TeradataHi Barry,Yes, I am practicing it in the same way.Thank you so much,Stration
423 Feb 2006 @ 03:48 PSTDatabaseReply10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkHi Manjesh,Check whether the Teradata Services are running on your machine. if not start it by using the Windows services.Hope it helps!Stration
322 Feb 2006 @ 02:18 PSTToolsTopicMultiload vs TpumpHi Guru's,I am a newbie to Teradata, What are all the key differences between Multiload and Tpump?. which one performs best in bulk insert, update & upsert?. How can i measure the performance?. ple...
222 Feb 2006 @ 02:00 PSTDatabaseTopicMaterialized view in TeradataHi Guru's,What is the SQL command to create a materialized view in Teradata?.Thanks in advance,Stration.
110 Dec 2004 @ 09:40 PSTDatabaseTopicplease help me....Iam a student, doing my Master Degree, I want to advance my career through this Teradata Database.I have collected and downloaded all the materials(including NCR hardware and software ebooks in the...