#DateForumTypeThreadPost
5430 Mar 2016 @ 04:04 PDTToolsReplyfast export and mload with unicode column type and valuehi Steve, with UTF16 also facing same problem. in UTF16 it will multiply by 2 right? then also it will go beyond 64k(18+31000+18+1000=32036 , 32036*2=64072) CREATE SET TABLE database.table1 ,NO F...
5330 Mar 2016 @ 03:46 PDTToolsReplyfast export and mload with unicode column type and valueIs there anyway I can unload and load with translate function to handle the above scenario.? Or there is no solution for this issue?
5203 Mar 2016 @ 02:43 PSTToolsReplyfast export and mload with unicode column type and valueIs there anyway I can copy the data from table to table with any way ? As this multi character unicode  value are loaded by ETL tool in source table.   Teradata does not have any solut...
5123 Feb 2016 @ 08:16 PSTToolsReplyfast export and mload with unicode column type and valueHi Steve, in that case, how the data is loaded to the production table using ETL tool like datastage, abinitio? Should not they face similar issue?  In my case I can see data are loaded usin...
5023 Feb 2016 @ 02:30 PSTToolsReplyfast export and mload with unicode column type and valueI did not get the last statement-"Of course, all single byte ASCII characters will continue to be single byte with a UTF8 client session character set, but the schema must be adjusted (tripled...
4923 Feb 2016 @ 01:53 PSTToolsReplyfast export and mload with unicode column type and valueSorry Steve, I do not have the data to share as have some restrictions. If in a table, out of 5 columns one column char set is declared as Unicode. then in template job we have to use- USING CHAR...
4810 Feb 2016 @ 03:01 PSTToolsReplyfast export and mload with unicode column type and value USING CHARACTER SET UTF-8 $UPDATE: TPT10508: RDBMS error 3798: A column or character expression is larger than the max size.     USING CHARACTER SET UTF-16 $EXP...
4710 Feb 2016 @ 02:47 PSTToolsReplyfast export and mload with unicode column type and valueI am using Teradata Parallel Transporter Version 14.10.00.10   
4610 Feb 2016 @ 02:45 PSTToolsReplyfast export and mload with unicode column type and valueSteve, I think while I am using "USING CHARACTER SET UTF16" - then it is mulpliplying every cols length with 2 and going beyond 64K. but if I am using USING CHARACTER SET ASCI, then...
4510 Feb 2016 @ 02:22 PSTToolsReplyfast export and mload with unicode column type and valueI am trying to load data from table to table using TPT template. unload from the below table and loading to same structure table. my source table desc- CREATE SET TABLE database.table1 ,NO FAL...
4417 Sep 2015 @ 01:39 PDTToolsReplyunloaded Date value issue by tpt script Error $UPDATE: TPT10508: RDBMS error 3707: Syntax error, expected something like ',' or ')' between the word 'Daily' and the word 'Total'. $UPDATE: discon...
4317 Sep 2015 @ 12:15 PDTToolsReplyunloaded Date value issue by tpt scriptHi Steve , I am loading with tpt table to table. But got a new issue. The column name in my table is with space. Column names are as- "Daily Total" INTEGER,   Teradata ...
4229 Jul 2015 @ 10:18 PDTToolsReplyunloaded Date value issue by tpt scriptHi Steve, I got one new issue. I have one field with timestamp(6) and value in source table is NULL. But while unloading and then loading records are getting rejected with error 6706. I tried in f...
4124 Jul 2015 @ 12:24 PDTToolsReplyunloaded Date value issue by tpt scriptfor your information- load script- USING CHARACTER SET UTF8 DEFINE JOB dc_load DESCRIPTION 'Load a Teradata table from a file' (   APPLY $INSERT TO OPERATOR( $UPDA...
4024 Jul 2015 @ 12:22 PDTToolsReplyunloaded Date value issue by tpt scriptplatform is AIX 6.1 Teradata Parallel Transporter Version 14.10.00.05
3924 Jul 2015 @ 11:53 PDTToolsReplyunloaded Date value issue by tpt scriptTable has four records and one field in a row is null, below are the values in table- 2015-01-21|Palash|Dhara 2015-01-31|BLANK|Arora 2015-01-01|Abhishek|Dhara 2015-02-01|BLANK|NULL   whi...
3824 Jul 2015 @ 09:34 PDTToolsReplyunloaded Date value issue by tpt scriptHi Steve, I used the below setings in unload file- ,DCCCloseQuoteMark='"' ,DCCOpenQuoteMark = '"' ,DCCQuotedData='Yes'   and load job var...
3723 Jul 2015 @ 02:47 PDTToolsReplyunloaded Date value issue by tpt scriptThanks Steve,  1. I tried with the option dateform=ansiDate in job variable file but still the same wrong result. 2. I have another null vs blank issue- Table fields   MIS_DT DATE ...
3622 Jul 2015 @ 02:00 PDTToolsReplyfast export and mload with unicode column type and valueI am trying to get the log. but the value that you are getting also looks wrong. instead of 0001 it's unloading 2901.  
3521 Jul 2015 @ 01:51 PDTToolsReplyfast export and mload with unicode column type and valueI am using teradata 14.10 and OS is AIX .Also check the $DATACONNECTOR_CONSUMER.txt template and it is the correct atrtribute name-     VARCHAR OpenQuoteMark       &n...
3421 Jul 2015 @ 12:50 PDTToolsReplyfast export and mload with unicode column type and valueHi Steve, what I understood, I have to unload and load both with quoteddata. so I am using this below attributes in unload job variable file.But the script is not creating the file with ""...
3321 Jul 2015 @ 10:06 PDTToolsReplyunloaded Date value issue by tpt scriptSteve I tried that with TPT also to unload in delimited file and load it to another table. But there I am facing below issues- 1.when date is less than (1000-01-01) e.x "0001-01-01" it&...
3221 Jul 2015 @ 09:59 PDTToolsReplyfast export and mload with unicode column type and valueSteve I tried that with TPT also to unload in delimited file and load it to another table. But there I am facing below issues- 1.when date is less than (1000-01-01) e.x "0001-01-01" it&#...
3120 Jul 2015 @ 03:33 PDTToolsReplyfast export and mload with unicode column type and valuewhile I am unloading data by fast export and loading with mload, it's working sometimes.but that unload file is not delimited formatted data. Is there anyway I can read the fast export unloade...
3016 Jul 2015 @ 09:52 PDTToolsReplyunloaded Date value issue by tpt scriptHi Steve, my sleect statement is 'select * from table;" I tried with some other value like '1001-01-01','2001-01-01' , '0009-01-01' etc whenever year is less than...

Pages