#DateForumTypeThreadPost
58412 Feb 2014 @ 02:23 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLEThanks for pointing out the doc issue. We will get it fixed. As for this: In any event I can't get any form of it to work with a variable. Sorry, I was reading it wrong. I thought this did ...
58312 Feb 2014 @ 01:39 PSTToolsReplyObtaining Failed load records from TPT loadIn Appendix B of the TPT Reference Manual we list: DEFINE SCHEMA schema-name 'DBS table name' DEFINE SCHEMA schema-name DELIMITED 'DBS table name' as being obsolete, and not to u...
58212 Feb 2014 @ 01:09 PSTToolsReplyObtaining Failed load records from TPT loadAny tool that can SELECT from Teradata.  :) You can use BTEQ or FastExport. Some people have used SQLA. However, realize that the data will be in binary. The reason for the field being VARBY...
58112 Feb 2014 @ 12:36 PSTToolsReplyObtaining Failed load records from TPT loadIncidentally, just so you know (this is not a trade secret), the information in DataParcel is in the exact format that we send the data to Teradata. Thus, if your original file contained delimited ...
58012 Feb 2014 @ 11:53 PSTToolsReplyObtaining Failed load records from TPT loadWe are coming out with a utility to extract the data from the DataParcel field and write it out in readable format (delimited), if the original record was delimited. If the original record format w...
57912 Feb 2014 @ 11:50 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLEYou can put a job variable anywhere in the script you want. We even have customers switching between the Update operator and the Stream operator and parameterizing the operator "type". ...
57811 Feb 2014 @ 02:51 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLEThen use this:   DEFINE SCHEMA EOD_USAGE DELIMITED FROM TABLE 'SONARTEST.EOD_USAGE';   That will convert the data types of the columns in the table schema to their equivalent ...
57711 Feb 2014 @ 12:28 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLEI think you may be confusing a few things. "SourceFormat" describes what the data will look like as it arrives to the Data Connector operator as a file reader. Not the file writer. If y...
57611 Feb 2014 @ 11:31 PSTToolsReplyTeradata Parallel Transporter - queriesFor #2, the DML statement is enclosed in single-quotes. Thus, if you have text inside those single-quotes that are enclosed in single-quotes, you need to escape them (by doubling each single-quote)...
57511 Feb 2014 @ 11:28 PSTToolsReplyTeradata Parallel Transporter - queriesFor #1:   Ok, so in TPT we do things a little differently in our script language but we accomplish the same thing. The schema object defines what the incoming data record looks like.  ...
57410 Feb 2014 @ 03:41 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLETPT will not parse/touch anything in single quotes.   Thus, if you want to use job variables inside a SQL statement, then you need to break it up into pieces, and use the concatenation opera...
57307 Feb 2014 @ 12:00 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLEThe connection information in the script is through the use of the TdpId, Username and UserPassword attributes. But the TdpId must be in your hosts file. Or, you can just put the IP address in th...
57207 Feb 2014 @ 11:45 PSTToolsReplyMload - execute a file in batch mode, invalid statement was foundHave you tried running "mload" from the command line prompt (NOT from clicking on the mload utility)? Also, you cannot use the wildcard syntax on the INSERT statement because you did not...
57107 Feb 2014 @ 11:41 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLEHave you used any of our load/unload products before?  
57007 Feb 2014 @ 11:35 PSTToolsReplyDEFINE SCHEMA target_schema FROM TABLEOn what platform are you running? You will need to add your Teradata Database node id's and IP addresses into the /etc/hosts file (for Unix/Linux). Please refer to the CLIv2 documentation for...
56906 Feb 2014 @ 08:05 PSTToolsReplyCan we load the same table concurrently using TPT Update operator by setting seperate checkpoint filesI believe Teradata is giving you the answer.  :) Teradata locks the table while these operations are taking place. So, the answer is no. You cannot have 2 TPT jobs using the MultiLoad protoc...
56806 Feb 2014 @ 03:26 PSTToolsReplyMload - execute a file in batch mode, invalid statement was foundWhat do you mean by "When I click on Mload utility"? What happens if you remove the trailing semicolon from this (not sure why you put it there):   mload < C:\mload_in.txt;
56706 Feb 2014 @ 03:19 PSTToolsReplyTeradata Parallel Transporter ~ OPERATOR FILE_WRITER ~ escape characters in output The double-quote character is treated as the OpenQuoteMark and CloseQuote Mark by default. No need to set those attributes.  
56605 Feb 2014 @ 12:12 PSTToolsReplyConvert HostData to actual record from Error TableThis will only work if your original data was delimited. This will not work if your data was originally loaded from one of the binary record formats. You have to also be careful because the data ...
56504 Feb 2014 @ 10:22 PSTToolsReply TPT12106: Cannot restart !!! Please resubmit the job.It looks like something is out of sync. For some reason the ODBC operator thinks the job is a restart job. Start from the beginning, but before you run tbuild, try running:     &...
56404 Feb 2014 @ 10:03 PSTToolsReplyTPT - ODBC connector missingPlease let me know where you found that sample script with the concatenation. We need to get that removed/changed. Thanks!   As for coredump, you must upgrade to the latest patch. We canno...
56303 Feb 2014 @ 10:58 PSTToolsReplyTPT - ODBC connector missingAlways upgrade to the latest patch. Question: why are you concatenating the SELECT statement in the ODBC operator?
56203 Feb 2014 @ 09:30 PSTToolsReplyTPT - ODBC connector missingYou are probably venturing where you do not need to go. The "template" directory is for our templates and you (as a beginner) should not be accessing those files. If you would like to k...
56130 Jan 2014 @ 04:50 PSTToolsReply TPT12106: Cannot restart !!! Please resubmit the job.It depends on utility slots.
56027 Jan 2014 @ 10:39 PSTToolsReplyProblem in writing MULTILOAD scriptPlease refer to the MultiLoad Reference Manual. There are a lot of sections that talk about what is supported and what is not supported in MultiLoad. For an example, here is an exerpt:   P...

Pages