#DateForumTypeThreadPost
2010 Mar 2016 @ 11:15 PSTDatabaseTopicFind out any DELETE happened on a table or notIs there any easy way to find out any DELETES happened on a table or not with out parsing the qrylog table. Do we have any dbc tables that captures this information.      
1909 Dec 2015 @ 09:03 PSTToolsTopicRecord Rejected to Error Table if String contains untranslatable character while doing TPT extract/Load in BINARY modeError table is getting loaded with error code "6706" while doing TPT EXTRACT/LOAD using TPT Binary Mode. In case of text mode I understand we need to handle this case. even for BINARY m...
1808 Nov 2015 @ 05:02 PSTToolsReplyTPT binary mode exportThanks Steve . Just trying out different possibilities.
1705 Nov 2015 @ 02:52 PSTHadoopTopicTeradata Binary file to Hadoop Sequence FileCould Some one please help on how to convert teradata binary file to hadoop sequence file. I have exported data from teradata table to binary file using TPT in binary mode. How to convert that bi...
1605 Nov 2015 @ 02:49 PSTToolsTopicTPT binary mode exportI tried exporting the data using TPT in binary mode and it worked. File has been created. When I tried to understand the exported data file, I am not able to understand it. Is that will be the LP...
1505 Nov 2015 @ 02:45 PSTDatabaseTopicFormat of Binary File exported from TPT in Binary ModeHello All, I have exported a table to binary file through TPT in Binary mode. I want to understand the exported file format. Is that a Length Prefixed File ? or How I can read the file? What is...
1428 Oct 2015 @ 03:31 PDTDatabaseTopicReading Binary format Data File exported from TPTI have exported the data using TPT format as binary. File has been generated. How I can Validate my data with out loading into any of the table. Is there any way we can interpret the Teradata binar...
1328 Oct 2015 @ 03:27 PDTDatabaseReplyOracle Table to Teradata DDL300+ Tables. Aplologize for the late response.
1227 Aug 2015 @ 11:37 PDTDatabaseTopicOracle Table to Teradata DDLI want to form a teradata table structure for a given oracle table. Do we have any ways to acheive this ? Also I heard about ora2td tool which will help to acheive this. but I do not have enough ...
1127 Aug 2015 @ 11:29 PDTDatabaseReplyhow to find the unique column(s) in a tableyou can get it from one of the dbc tables called indices. use below query to get unique columns available in a specified table   select columnname from dbc.indices where ...
1021 Jul 2015 @ 11:40 PDTDatabaseReplyDecimal Formatting in TeradataInput Values --- OutPut 123.23               123.23 123.00               123   
921 Jul 2015 @ 11:38 PDTDatabaseTopicDecimal Formatting in TeradataRequirement : Input (Decimal) Output 123.23 123.23 123.00 123 I want the out as above for th...
829 Apr 2015 @ 12:15 PDTGeneralReplyPermanent Journal creation at Table LevelThank Fred . CREATE SET TABLE journal_database.journal_table ,NO FALLBACK , NO BEFORE JOURNAL, AFTER JOURNAL, with journal TABLE =journal_database.journal_name, CHECKSUM ...
729 Apr 2015 @ 12:07 PDTDatabaseReplyHow to read Journal Table in teradata ?Thanks Fred. then to restore the journal content to actual table we need to do a ARCHIVE & RESTORE . Am I right. ?
623 Apr 2015 @ 11:05 PDTDatabaseTopicHow to read Journal Table in teradata ?Are the journal table data's are readable ? If yes , can we select it using simple SQL (select *) ? or How to read Journal Table data ? please suggest. Thanks, Muthu.    
522 Apr 2015 @ 09:34 PDTGeneralTopicPermanent Journal creation at Table LevelI am trying to enable permamnet journal for my table.PFB the table structure I am using and I am getting error message Database doesnot have a permanent journal. CREATE SET TABLE pp_tables_d.tes...
426 Mar 2014 @ 05:16 PDTGeneralTopicHow we can replicate Tables structures between 2 teradata servers ?is there any easiest way to make sure table defintions between 2 teradata servers are in SYNC. currently I am exporting table definitions from one server and creating tables in another server by u...
326 Mar 2014 @ 05:10 PDTToolsTopicBTEQ Parallel Execution to speed up executing SQL statementsCurrently I am executing SQL statements one by one as below, bteq << EOB .logon XXXX .OS rm -f file.sql .SET FORMAT OFF .SET TITLEDASHES OFF .SET WIDTH 999 .export data file=file.sq...
226 Mar 2014 @ 05:02 PDTGeneralReply.0 is appending at lat of timestamp value while fetching using java JDBCYes. I dont need a trailing ".0". I have formatted the timestamp as below and it worked for me, SimpleDateFormat dateFormat = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss");...
116 Mar 2014 @ 12:02 PDTGeneralTopic.0 is appending at lat of timestamp value while fetching using java JDBCin table I am having a value timestamp "2014-03-15 06:12:35". But while selecting using java JDBC I am getting "2014-03-15 06:12:35.0". I tried both resultSet.getString and res...