1209 | 22 Aug 2016 @ 08:56 PDT | Tools | Reply | Zero records are fetching when using where statement in TPT | If you tried to put the SELECT statement in the script, please send me your script and I will make adjustments as necessary.
|
1208 | 19 Aug 2016 @ 03:56 PDT | Tools | Reply | Unicode Export through TPT | Please send me your script.
(I may make changes to it.)
|
1207 | 19 Aug 2016 @ 03:07 PDT | Tools | Reply | Unicode Export through TPT | In the example script you sent, EmpCatNumber was defined in the table as VARCHAR(10).
If that is the case, then the script must specify VARCHAR(30).
If this is done correctly, I am not sure how T... |
1206 | 19 Aug 2016 @ 01:43 PDT | Tools | Reply | Unicode Export through TPT | In order to see the chinese/japanese characters, you MUST specify either UTF8 or UTF16 as the character set in the script.
If you specify UTF8, you must triple the size of the character fi... |
1205 | 16 Aug 2016 @ 02:04 PDT | Tools | Reply | TPT - Instances Vs Sessions | Since you are using templates, you will need to use the template job variable name.
It could be FileReaderMultipleInstances.
To be sure, take a look at the $FILE_READER.txt template file.
|
1204 | 16 Aug 2016 @ 08:41 PDT | Tools | Reply | TPT - Instances Vs Sessions | In order to use multiple instances to read from a single file, you must set the MultipleReaders attribute to 'yes'.
|
1203 | 15 Aug 2016 @ 10:58 PDT | Tools | Reply | Understanding teradata sample scripts | The $FILE_WRITER and $LOAD syntax describes the use of templates.
Those templates define the operators you are trying to use, and those operator definitions are found in the "templates" ... |
1202 | 10 Aug 2016 @ 11:46 PDT | Tools | Reply | TPT load failure - Please suggest | Since an incident has been opened for this, I will let the GSC handle it for now.
If they need to come to engineering, then I will get involved to help them.
(That message it provided by the DBS ... |
1201 | 09 Aug 2016 @ 08:46 PDT | Tools | Reply | TPT load failure - Please suggest | What version of TPTAPI have you installed?
What version of CLI?
This sometimes can occur when mismatching components are installed.
|
1200 | 09 Aug 2016 @ 08:29 PDT | Tools | Reply | Queries for Teradata Fast Export Utility | 1. FastExport should be installed on the edge node. It should never be installed on the database server.
2. It has been shown that a max session count of 4 is generall the best setting, but you ca... |
1199 | 09 Aug 2016 @ 08:25 PDT | Tools | Reply | TPT export into AWS S3 buckets. | We are currently developing an Amazon AWS S3 access module that will allow you to move data from S3 directly into Teradata (and vice versa) without landing the data to disk. It is not yet released.... |
1198 | 27 Jul 2016 @ 12:20 PDT | Tools | Reply | Delimiter issue in Fastload | The Data Connector (we do not really refer to it as "legacy" since it is used by BTEQ, which is not a frozen product) does support quoted delimited data (as does FastLoad, MultiLoad and T... |
1197 | 26 Jul 2016 @ 11:28 PDT | Tools | Reply | Export with header using TPT | The Export (and SQL Selector) operator(s) is/are not capable of extracting out the column headers from the database.
|
1196 | 25 Jul 2016 @ 11:06 PDT | Tools | Reply | TPT 15.10 ODBC Operator : Bundled DataDirect Drivers ! | This is not true.
We bundle both the 32-bit and 64-bit drivers with TPT.
You do not have to purchase the license from DataDirect.
However, you do need to obtain the license files from us.
|
1195 | 25 Jul 2016 @ 02:13 PDT | Tools | Reply | Ctrl-A delimiter with TPT Export. | There is an attribute for the DataConnector operator (I think still undocumented) called TextDelimiterHex.
Set that to '0A' and the DC operator should write out that character as the field... |
1194 | 21 Jul 2016 @ 04:23 PDT | Tools | Reply | Zero records are fetching when using where statement in TPT | Our documentation will describe examples, and we ship sample scripts with TPT.
Look in the "samples" directory where TPT is installed.
|
1193 | 21 Jul 2016 @ 04:22 PDT | Tools | Reply | TPT Export vs Fast Export | Yes, TPT supports the writing of data to multiple files.
Just use the Export operator to extract the data from Teradata.
Use the DataConnector operator as the file writer.
Specify how many insta... |
1192 | 21 Jul 2016 @ 03:50 PDT | Tools | Reply | TPT - Scripting | There is currently no way to force tdload to use a specific operator.
(It is on the list for a future enhancement.)
To force the use of a specific operator, you would need to write a script.
(Al... |
1191 | 20 Jul 2016 @ 01:39 PDT | Tools | Reply | Zero records are fetching when using where statement in TPT | If you write a script and put the SELECT statement in the script, the single quotes will not be stripped.
|
1190 | 19 Jul 2016 @ 11:23 PDT | Tools | Reply | Zero records are fetching when using where statement in TPT | I have enough information.
I needed to know if the single-quotes were being stripped.
|
1189 | 19 Jul 2016 @ 09:45 PDT | Tools | Reply | TDCH-TPT Interface--For loading into Hadoop | The use of TDCH by TPT is basically performed by TPT sending a command to the name node of the Hadoop cluster to execute the TDCH command, passing the needed information as command line options to ... |
1188 | 19 Jul 2016 @ 09:21 PDT | Tools | Reply | TPT - Scripting | What version of TPT are you using?
That would dictate what type of "template" and "generated schema" features you can use.
It would also dictate whether you can use Easy Loade... |
1187 | 19 Jul 2016 @ 09:11 PDT | Tools | Reply | Zero records are fetching when using where statement in TPT | For your versiobn of TPT, continue to use SelectStmt.
We are "fixing" TPT to also accept ExportSelectStmt, but that is not completed yet.
I will need to see a complete log (the .out fil... |
1186 | 19 Jul 2016 @ 09:07 PDT | Tools | Reply | Determine #sessions to set for load / exp jobs | The calculation that is often used in TASM (TDWM, workload management) is:
If number of AMPs <= 20, then use 1 per AMP.
If number of AMP > 20, then use 20 + (#AMPS/20)
But ... |
1185 | 15 Jul 2016 @ 12:30 PDT | Tools | Reply | TPT Export vs Fast Export | FastExport will process the blocks in order.
TPT Export can have multiple processes, each process controlling multiple data sessions, and thus you can get parallelism extracting the data from Tera... |