#DateForumTypeThreadPost
924 Jun 2014 @ 10:49 PDTDatabaseTopicTypes of TablekindIn teradata there are 3 basic types of Database objects. they are  1. View 2. Table 3. Macro are there any other different type of Db objects available?
824 Jun 2014 @ 10:47 PDTDatabaseReplyunable to cast object of type 'system.dbnull' to type 'system.string'Can you please give more details?
723 Jun 2014 @ 11:25 PDTTeradata ApplicationsReplyConverting TimeStamp into DateHi Rohit, can you please paste your sample code that perform the operation here? you are trying to compare the date along with timestamp?
623 Jun 2014 @ 09:05 PDTGeneralTopicTeradata is low level or high level language?When I studied COBOL,FORTRAN computer programming languages,  my professor used to define COBOL as a high level language because the instruction statments used in COBOL were like reading Engli...
519 Jun 2014 @ 07:30 PDTDatabaseReplyQuery to Delete all the records in a table in TeradataDieter, Thanks for your reply. I don't have any idea regarding deleting data based on partitioning schema. can you give me a sample example? ramesh    
417 Jun 2014 @ 12:08 PDTUDAReplyImporting delimiter text file!!!!!!!! .IMPORT VARTEXT ','  FILE=D:\ABC.txt; from the above example it is clear that the file abc.txt has , as delimited character. how can I mention tab as delimited? can anyone please ...
315 Jun 2014 @ 11:25 PDTDatabaseReplyQuery to Delete all the records in a table in TeradataWhenever we delete huge number of records from a table, say I am trying to delete 50 millon records in a 1 billion records table, usually it takes so long to complete the task. What I know was the ...
215 Jun 2014 @ 08:57 PDTDatabaseReplyQuery to Delete all the records in a table in TeradataWhatever mentioned by Ckraenzle is correct.  You can simple use the below Synxtax to delete complete records from a teradata table. delete from dbname.tablename;  
111 Jun 2014 @ 07:00 PDTDatabaseReplysql assistantI know how to connect to Teradata DB using Oracle SQL Assistant.  But it is really possible to connect to Oracle DB using Teradata SQL Assistant? if so can anyone provide detailed step by ste...