#DateForumTypeThreadPost
3027 Jul 2016 @ 09:51 PDTDatabaseReplyTPT ODBCThank you both for the reply ...i will check and get back to you.
2926 Jul 2016 @ 12:18 PDTDatabaseTopicTPT ODBCHi All  - I have been struggling to fix my ODBC TPT script.Here is the back ground: My teredata version is 14.10 I am trying to extract the data from AS400 (accessed through DB2 client...
2801 Apr 2016 @ 06:56 PDTDatabaseReplyTPT ODBCHi Carlos- We od not have any tool...May i know if there is a way that i can go an check manually in any of the path on UNIX server and if it not present can i create by my self or do i need to en...
2731 Mar 2016 @ 02:01 PDTDatabaseTopicTPT ODBCHi All - I am facing issue when i try to run the TPT script which extracts the data from oracle and load in to teradata.Please find below is the error i am getting. ODBC_Operator: TPT17122: Error...
2612 Jan 2016 @ 12:46 PSTDatabaseTopicTPT Easy LoaderHi All - I am using TPT easy loader to copy the data from prod to dev....but my dev objects are views .So when i try to run the TPT it get below error $LOAD: TPT10508: RDBMS error 3853: 'ABC&...
2514 Aug 2015 @ 01:58 PDTDatabaseReplyTeradata SQL Assistant ImportThank you for looking into this however i tried to run the same using bteq import and it worked .
2413 Aug 2015 @ 02:25 PDTDatabaseTopicTeradata SQL Assistant ImportHi All -   Can you please help me findin a solution for below issue.   I am trying to import txt file data into teradta table using import option and iam getting below error  Er...
2324 Jun 2015 @ 03:06 PDTDatabaseReplytime stamp field insert Thanks Dieter i will try this and get back to you if it is not working.
2224 Jun 2015 @ 03:03 PDTDatabaseReplyeasy loaderThank you fred it is working fine when i pass the values through jobvar file.
2115 Jun 2015 @ 11:06 PDTDatabaseTopictime stamp field insert Hi All - i am having trouble to insert the 2010-1-10.21.5.59.951939000 value into a time stamp field which is defined as TIMESTAMP(6) FORMAT 'YYYYMMDDBHH:MI:SS.S(F)'.   Could you pl...
2004 Jun 2015 @ 12:53 PDTDatabaseTopiceasy loaderHi All - I am trying to load the data from one tabl to another table which on 2 different servers by using the easy loader commnd as below tdload 'sel * from src_table;' src_tdpid src_use...
1919 May 2015 @ 04:05 PDTDatabaseTopicMload struck at MultiLoad Acquisition PhaseHi All - I am running Mload script and it is struck at MultiLoad Acquisition Phase .Please see below is the point where the log file got struck and it is not doing any thing neither failing nor lo...
1818 Dec 2014 @ 01:16 PSTDatabaseTopicView TPT LogHi ALL - I have executed a TPT script with export operator and able to generate the output data file successfully......and i also see a log file in the path /opt/teradata/client/14.10/tbuild/logs...
1706 Nov 2014 @ 09:50 PSTDatabaseReplyTPT errorI am able to run the script successfully ...thank you all
1605 Nov 2014 @ 09:59 PSTDatabaseReplyTPT errorHi satya - I Cahnged the column name to ACCT and i am getting below error... Teradata Parallel Transporter Version 14.10.00.02 TPT_INFRA: Syntax error at or near line 7 of Job Script File '...
1505 Nov 2014 @ 09:04 PSTDatabaseTopicTPT errorHi All - I have worked on Mload,Fload and Fastexport utilities and i am bit new to TPT .I am trying to unload data from one server to another sever using TPT but i am getting some error as below ...
1408 Oct 2014 @ 06:54 PDTDatabaseTopicFind user id Hi All - Can you please let me know is there a way that we can know who has done a DML (insert,update,delete) operation on a teradata table/view.If so could you please pass me the query. Thanks ...
1318 Sep 2014 @ 12:50 PDTDatabaseTopicExport to excelHi - Any body know how to export the result set from SQL assistant to excell....i know how to export to .txt file...but i want to export to excell. Thanks John
1218 Sep 2014 @ 12:46 PDTDatabaseReplyHandling NULL values in the dataI think i am good we did sed for one time but the source team is fixing the file...Thank all
1116 Sep 2014 @ 11:44 PDTDatabaseReplyHandling NULL values in the dataThanks raja ....I did try doing sed on the file and it worked but just want to know is there any way that we can handle in teradat code. --John
1016 Sep 2014 @ 09:29 PDTDatabaseTopicHandling NULL values in the dataHi - Can you please help how to handle below situation in teradata... There are some records from the source whoch has NULL in the data itself ....for example   John is from teraNULLdata c...
925 Aug 2014 @ 12:58 PDTDatabaseReplySpecial CharactersThank you very much dieter....It worked perfect.
825 Aug 2014 @ 12:12 PDTDatabaseReplySpecial CharactersHi Dieter - Thanks for the solution since the carriage return is already in the column value is there any function in teradata to use and delete/update  those carriage return values from the ...
725 Aug 2014 @ 10:02 PDTDatabaseTopicSpecial CharactersHi All - Can you please help me to resolve the below problem. I have a table with address column and output of that column in SQL Assistant answer set is as below (not in a singel line) 000...
604 Jun 2014 @ 01:56 PDTDatabaseReplyTeradata Data MaskingThanks joe for the solution but from the above solution we need to join security table with the table and create a view ? Instead that do we hae any other process to do ? please let me know. Than...

Pages