609 | 04 Mar 2014 @ 09:42 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | It is the other way around. :)
The question should be, "Does TPT support Teradata 13?"
The answer is "yes", but it depends on which versions of TPT.
Our client products... |
608 | 03 Mar 2014 @ 10:04 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Please send your entire JCL.
What dataset is PTYIN pointed to?
|
607 | 03 Mar 2014 @ 06:02 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | I think we need to see the entire set of output.
We only have a partial story here.
The job terminated with an error (Job step LOAD_TABLES terminated (status 8) ).
But the part of the output you... |
606 | 03 Mar 2014 @ 09:59 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | @Santanu84: please do NOT use the attributes ValidUTF8 and ReplaceUTF8Char.
We are not happy with the results we are getting from that feature and we are redesigning it.
@arun_tim... |
605 | 27 Feb 2014 @ 11:33 PST | Tools | Reply | Fast export and mload in vartext mode - Data item too large for field issue | You should consider switching to TPT.
In 14.10 TPT supports the ability to write out data (retrieved from Teradata or any other ODBC compliant data source) to delimited fashion without the need to... |
604 | 27 Feb 2014 @ 11:27 PST | Tools | Reply | tdload having issues loading data where the delimiter is part of a field | thomspsonhab: TPT does not yet support embedded cr/lf.
manharrishi: tdload (aka EasyLoader) does not yet support quoted data (but we should have so I will make sure we get this efixed).
|
603 | 26 Feb 2014 @ 03:57 PST | Tools | Reply | tdload having issues loading data where the delimiter is part of a field | Support for quoted fields (and thus, embedded delimiters) did go into TPT in 14.0.
However, TPT14.10 is probably a better release (performance improvements) if you can use that one.
We still do n... |
602 | 26 Feb 2014 @ 12:27 PST | Tools | Reply | tdload having issues loading data where the delimiter is part of a field | TPT does not support embedded delimiters in release 13.
|
601 | 26 Feb 2014 @ 11:30 PST | Tools | Reply | Teradata Parallel Transporter - Session Character Set | The USING CHARACTER SET UTF8 is only for the data. Not the script.
The script does not have to be encoded in UTF8 in order for you to load UTF8 data into Teradata.
If there is nothing special in ... |
600 | 25 Feb 2014 @ 12:14 PST | Tools | Reply | fast export and mload in fastload format issue - error code 2793 | Thanks Dieter! That is where I was going next, right after looking at a hex dump of the data.
|
599 | 25 Feb 2014 @ 11:28 PST | Tools | Reply | fast export and mload in fastload format issue - error code 2793 | Try it with just one row of data and post the hex output of the data file from the FastExport job.
|
598 | 21 Feb 2014 @ 06:07 PST | Tools | Reply | Backlog issue occuring when UNION ALLing multiple TPT DataConnector operators into Stream | I will look into the checkpoint issue, to see if we have a synchronization issue regarding the use of UNION ALL. I know that when using multiple instances of a single DC operator, the checkpoint do... |
597 | 20 Feb 2014 @ 07:16 PST | Tools | Reply | Backlog issue occuring when UNION ALLing multiple TPT DataConnector operators into Stream | A few thoughts.
If you are using the Stream operator, I doubt the file reading will ever be the bottleneck.
The Stream operator will probably always be running slower than the file reading.
Next... |
596 | 19 Feb 2014 @ 12:04 PST | Tools | Reply | Need Header Row in FastExport / TPT Export.? | TPT cannot load data into any database other than Teradata.
(You can use TPT to move data from a non-Teradata database to Teradata without landing the data to disk.)
However, TPT is a bulk data l... |
595 | 19 Feb 2014 @ 11:55 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | Thanks for the validation (and your patience).
|
594 | 19 Feb 2014 @ 12:02 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | Ok. You cannot "checkpoint" when using pipes.
Remove the "-z 60" part of the command and your job should be able to run.
|
593 | 18 Feb 2014 @ 07:35 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | What is the command line you are using to run the TPT job?
|
592 | 18 Feb 2014 @ 11:59 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | Pipe issues resulting in "getpos" errors was fixed in 14.10.00.003 and 14.00.00.011.
|
591 | 18 Feb 2014 @ 10:30 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | Not sure on the exact naming convention yet.
We have to be careful with backwards compatibility issues.
What specifically do you want to know about named pipes?
Are you using the named pipe acce... |
590 | 18 Feb 2014 @ 09:33 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | Yup. Found a bug.
The DC operator is looking at the .gz-x extension and not the .gz extension (prior to appending the instance number).
Plus, putting the instance number on the fi... |
589 | 17 Feb 2014 @ 10:24 PST | Tools | Reply | Zip/GZip Support in TTU 14? | TPT's implementation with TDCH will most likely not support .gz files.
The TPT implementation of the HDFS API will support .gz files.
|
588 | 17 Feb 2014 @ 10:22 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | You can specify multiple instances of the DataConnector operator (as the file writer) and use the -C option on the command line. TPT will round-robin the data to each instance and each instance wil... |
587 | 17 Feb 2014 @ 05:49 PST | Tools | Reply | TPT 14.10 output to named pipe and then gzip to final files | What are you trying to accomplish here?
TPT can both read and write gzip files.
Might be easier to do that than to use pipes.
|
586 | 17 Feb 2014 @ 09:48 PST | Tools | Reply | Need Header Row in FastExport / TPT Export.? | BTEQ is often known (or referred to) as a report writing tool.
It has those capabilities.
FastExport and TPT are high speed bulk loading/unloading tools.
It is best to use BTEQ for the types of ... |
585 | 12 Feb 2014 @ 04:32 PST | Tools | Reply | DEFINE SCHEMA target_schema FROM TABLE | Ok, well you found a bug in our code and we will get it fixed.
The workaround is to use that obsolete syntax. We never deprecate the syntax, even when we make it obsolete.
So, it will work for yo... |