#DateForumTypeThreadPost
2119 Aug 2016 @ 03:51 PDTToolsReplyUnicode Export through TPTI have changed the empcatnumber to 30. I even tried increasing the size to 60/90 but the error meesage remains the same. My TPT version is Teradata Parallel Transporter Version 15.10.01.02 64...
2019 Aug 2016 @ 02:01 PDTToolsReplyUnicode Export through TPTHi Steve,  I have mentioned UTF8 and tripled the size of the unicode fields, i still get the following error.   EXPORT_OPERATOR: connecting sessions TPT_INFRA: TPT02638: Error: ...
1919 Aug 2016 @ 01:21 PDTToolsTopicUnicode Export through TPT Hi,    I need to export few chinese and japanese characters stored in teradata to a file.   I have tried different options to export data through TPT but i am eith...
1819 Aug 2016 @ 12:29 PDTToolsReplyTPT export into AWS S3 buckets.Thanks Steve.
1718 Aug 2016 @ 11:38 PDTGeneralTopicDisable Logging in TPTHi, I am executing my TPT export and each time, it does a detailed logging in the following logs folder. This detailed logging makes the tpt to fail with out of space error in the logs folder. L...
1602 Aug 2016 @ 02:20 PDTToolsTopicTPT export into AWS S3 buckets.Hi,    I am using TPT to export data to a file and move into S3 buckets., am curious to know if there is a way to export data and write directly into AWS S3 buckets.   Thanks &am...
1502 Aug 2016 @ 02:18 PDTToolsReplyExport with header using TPTThank you MissGate & Steve, 
1426 Jul 2016 @ 10:23 PDTToolsTopicExport with header using TPTHi, I am using TPT export for doing data export from TD to a file and want to include column headers to the generated file. I would like to know if there are any attributes that is included with ...
1326 Jul 2016 @ 10:18 PDTToolsReplyCtrl-A delimiter with TPT Export.Thank you Steve,  Alternatively, i tried specifying CTRL-A in the Textdelimiter attribute by giving CTRL-V CTRL-A through vi editor and this is able to export data with CTRL-A delimiter. VAR...
1225 Jul 2016 @ 11:27 PDTToolsTopicCtrl-A delimiter with TPT Export.Hi,  I want to use CTRL-A as delimiter for TPT exports, I would like to know how to specify this in the TPT script. Thanks & Regards, Srivignesh KN
1122 Jun 2016 @ 01:33 PDTToolsTopicTPT Failure : Output schema mismatch - Output varies from Server to Server. Hi All,    I am facing a strange issue with TPT script, I am trying to run TPT script against the same table in 2 different servers.   In the First Server : &n...
1021 Jun 2016 @ 01:57 PDTToolsReplyTPT RestartabilityThanks Steve, that works.   Alternatively i started executing the TPT scripts with the job name as argument and later delete the logs and checkpoints created by the tpt scripts. $TPT_PATH/t...
921 Jun 2016 @ 11:26 PDTToolsTopicTPT RestartabilityHi,    I would like to know if there is a way in which i can disable TPT restartability, each time TPT executes i would like to run it from the beginning and it should not restart from ...
812 Apr 2016 @ 02:40 PDTDatabaseTopicRewrite Case when statements Hi,    I have a following query with multiple case when statements and i would need to performance tune it.   Request your help in re-writing this code.  ...
726 Feb 2016 @ 04:30 PSTDatabaseReplyHow to calculate a character occurance in a string in teradata Hi Deepok/Jitu,   I have replicated your scenario and tried out a solution and am able to get the desired output.   1. I have created a table (tmp_substr) with 2 column...
626 Feb 2016 @ 02:39 PSTDatabaseReplyNeed help to implement the logicHi, I have tried the solution with a self join on the table with tt_id and grouping the max priority id with the greatest one using qualify. I tested for the below input set with different sce...
523 Feb 2016 @ 11:32 PSTToolsReplyConvert a Field 1. This can be achieved by OREPLACE function in TD, the equivalent of the Oracle funtion.  Query : select oreplace(colname,' ','x') from Table; -- (' ' is space) &nbs...
423 Feb 2016 @ 10:59 PSTDatabaseReplyGenerate a Alphanumeric ID I was able to manipulate with the following statement.    select 'OFFR'||insertdt||trim(row_number() over (order by 1 desc)) from Tablename.   1. 'OFFR...
323 Feb 2016 @ 10:24 PSTDatabaseReplyNeed help to implement the logic   Query:   select a.tt_id,b.priority_id as StartPriority,a.priority_id as EndPriority from priority a  inner join priority b on (a.tt_id=b.tt_id and a.priority_id&...
223 Feb 2016 @ 10:04 PSTDatabaseReplyDDL for entire database1. The following statements would give the DDL's for view and table.   Select Requesttext from dbc.tables where tablekind='V'; -- View.   Select Requesttext from dbc.table...
122 Feb 2016 @ 04:35 PSTDatabaseReplyDo we have a Rank function for this requirement ?The following query should work for this requirement. select key_col,val,percent_rank () over (order by val desc) as Rank_value_needed from Table;   Output : Key Col   Val   Rank...