#DateForumTypeThreadPost
93424 Jul 2015 @ 01:19 PDTToolsReplyunloaded Date value issue by tpt scriptThank you! I will let you know when we find something out.  
93324 Jul 2015 @ 12:17 PDTToolsReplyunloaded Date value issue by tpt scriptThe NULL is not supposed to be represented by "". That is an empty string. It is valid to not write anything in the 3rd field. The existence of a delimiter and then an end-of-line marke...
93224 Jul 2015 @ 11:05 PDTToolsReplyunloaded Date value issue by tpt scriptWhen you say this:   unload file content is - "2015/01/21"|"palash"|"dhara" "2015/02/01"|""| "2015/01/01"|"abhishek"|...
93123 Jul 2015 @ 06:39 PDTToolsReplySQL Inserter Help with TPT and CLOB Data LoadPlease do not use the Wizard. It is a tool that will have a limited shelf life (the plan is to discontinue it soon), and it does not support all of the features of TPT. Also, it generates scripts...
93023 Jul 2015 @ 03:44 PDTToolsReplyunloaded Date value issue by tpt script#1. If you read all of my posts, you will see that the DateForm solution originally proposed will not work. You will have to also explicitly provide the schema and define the DATE fields as ANSIDAT...
92923 Jul 2015 @ 11:45 PDTToolsReplyunloaded Date value issue by tpt scriptEven a little more information.   This is the formula Teradata uses: (year-1900) * 10000 + (month*100) + day   Thus, "2015/01/01" would yield: (2015-1900) * 10000 + (1 * 1...
92823 Jul 2015 @ 11:27 PDTToolsReplyunloaded Date value issue by tpt scriptOk, a little more information. When the default method of exporting DATE data is used, Teradata exports the data as integer data. This is what is happening in this case. And any year prior to 19...
92722 Jul 2015 @ 07:00 PDTToolsReplyunloaded Date value issue by tpt scriptOk, I was finally able to reproduce the problem (#1) on my PC! I will have to talk to the DBS folks to figure out what is going on, but here is what I know. When you use the DEFINE SCHEMA <nam...
92622 Jul 2015 @ 03:05 PDTToolsReplyfast export and mload with unicode column type and valueThat might be a database setting. In other words, yes 2901 seems wrong, but with "0001", I think the DBS has to differentiate between the year 1901 and 2001. I will talk to some databas...
92521 Jul 2015 @ 02:49 PDTToolsReplyfast export and mload with unicode column type and valueWhen I do this: CREATE TABLE abc ( F1 DATE FORMAT 'YYYY/MM/DD' ); INSERT INTO abc ('0001/01/01');   and then I use TPT to export the data to a flat file in delimited form...
92421 Jul 2015 @ 02:07 PDTToolsReplyfast export and mload with unicode column type and valueI need to know the version of TPT, not Teradata ("Teradata" refers to the database). And you need to use the Job Variable names (on the right side of the "=" sign). Not the at...
92321 Jul 2015 @ 01:28 PDTToolsReplyfast export and mload with unicode column type and valueYour script is using templates (good!). However, your job variables for QuotedData may not be correct. Please check the template file for the DataConnector Consumer operator to make sure you are ...
92221 Jul 2015 @ 10:10 PDTToolsReplyfast export and mload with unicode column type and value(Different thread in the Tools section, so was not aware this is the same user/problem as discussed in the other thread.)   1. I cannot reproduce; we are still looking at the problem 2. thi...
92121 Jul 2015 @ 09:49 PDTToolsReplyFastLoad: Unable to load certain txt files using FastLoad Scrip but colleague can using same file, same script...In the future, it would be helpful if you could provide more information than just "my job fails". What type of failure? What is the error message? What platform? What version of Fast...
92021 Jul 2015 @ 09:39 PDTToolsReplyfast export and mload with unicode column type and valueYou need a file in delimited format. FastExport does not offer that capability. If you would like that capability, you shoud switch to TPT (you should be switching to TPT anyway).  
91917 Jul 2015 @ 08:39 PDTToolsReplyTPT - Load progress indication"Should it be"? Some type of reporting is probably warranted, but we do not currently provide any. We are working on an enhancement to provide the number of rows "sent" to the...
91816 Jul 2015 @ 07:24 PDTToolsReplyWhy TPT mload is taking long time than bteq for huge volume of dataBased on your job scripts, the Export operator will connect 12 data sessions (and 1 SQL session for executing the SELECT statement). The Update operator will also connect 12 data sessions (and 2 a...
91716 Jul 2015 @ 05:20 PDTToolsReplyunloaded Date value issue by tpt scriptWhen your BTEQ output shows a date of 01/01/01, what is the real date? 2001? 1901? When I enter a date as: INSERT INTO TABLE abc ('0001/01/01'); I get this on output from TPT: 2901/01...
91616 Jul 2015 @ 01:41 PDTToolsReplyDoes TTU13.10 work with TD database v12 ?yes
91516 Jul 2015 @ 11:06 PDTToolsReplyWhy TPT mload is taking long time than bteq for huge volume of dataThanks Todd! For a pure delete, I was going to steer this user into invoking the MultiLoad-protocol Delete Task (an application phase only operation) which is must faster than the approach current...
91415 Jul 2015 @ 04:54 PDTToolsReplyTPT DDL Merge Into. How to report rows inserted / updatedDid you look into the log of the DDL operator to see if those statistics are reported?  
91315 Jul 2015 @ 03:46 PDTToolsReplyunloaded Date value issue by tpt scriptAlso, please provide me with the SELECT statement you are passing in as a job variable. (When I try it on my system, I get 2001/01/01 in my data file.)  
91215 Jul 2015 @ 10:46 PDTToolsReplyWhy TPT mload is taking long time than bteq for huge volume of dataI do not see where you specify that rows are being inserted. The only DML statements I see is a DELETE.  
91114 Jul 2015 @ 11:24 PDTToolsReplyunloaded Date value issue by tpt scriptThe DBS 3621 issue is a separate issue and not related to which operator is used to export the data. I would like to address them separately. For the DATE data issue, is it true that only the dat...
91014 Jul 2015 @ 10:19 PDTToolsReplyWhy TPT mload is taking long time than bteq for huge volume of dataThe only privacy issues probably involve any password and you can always just remove that text. I need to see all of the other attributes you have set up in the script. What is this script attemp...

Pages