#DateForumTypeThreadPost
13418 May 2011 @ 10:53 PDTToolsReplySelecting from file operator in TPT script, "missing SEMOCIL_" errorThe SELECT statement in the APPLY-SELECT clause of the TPT script language is not a SELECT statement that is sent to Teradata, and does not support all of the SQL syntax. The TPT script language...
13312 May 2011 @ 05:27 PDTToolsReplyTPT_ISSUEBy "DataConnector code" I hope you meant the script. We are not sharing any software. The DataConnector error is self-explanatory. The file you specified in the script is not found. As far as ...
13212 May 2011 @ 04:24 PDTToolsReplyUsing name of Flat File in TPT Load Yes, we do support this. In the schema object in the script, we support this syntax: DEFINE SCHEMA T2_SOURCE_SCHEMA DESCRIPTION 'T2 SCHEMA' ( METACOL1 VARCHAR(40) METADATA(Fi...
13104 May 2011 @ 12:07 PDTToolsReplyTPT issue : not able to open the data fileWell, we actually have 2 things going on here. I will check on the TPT01514 error. That is an infrastructure error. The first one though, TPT10517, is from the operator. And the error is self -ex...
13021 Apr 2011 @ 02:00 PDTToolsReplyTPT Vs other ETL UtilitiesTPT "data streams" use internal shared memory. If your system has low memory, then TPT might have difficulties. Some corrections to the above pro/con list: TPT is not an ETL tool. It is a lo...
12920 Apr 2011 @ 12:54 PDTToolsReplyTPT Extracting Data from Oracle ODBCYou can get evaluation copies of the DD drivers fairly quickly if that is allowed in your environment. As for the timeframe, I believe it will be a few more weeks before the patch becomes availabl...
12813 Apr 2011 @ 10:38 PDTToolsReplyTPT Extracting Data from Oracle ODBCJust a followup. This thread did actually uncover a bug in the ODBC operator when the large decimal specification is used. This bug is also due to the ODBC driver you are using (remember, we only s...
12713 Apr 2011 @ 10:34 PDTToolsReplyRelease Lock - LOAD Operator - TPTWhat version of TPT are you using? What record format are you using? Delimited? If you are using delimited, I believe the DataConnector operator (the file reader) has an attribute called RowErrFi...
12613 Apr 2011 @ 10:27 PDTToolsReplyMLOAD - Using File and Table.MultiLoad can only load tables with data from either flat files, INMODs, or access modules. It cannot pull data out of Teradata tables. Also if you are loading into an empty table, the UPSERT woul...
12531 Mar 2011 @ 06:41 PDTToolsReplyTPT Extracting Data from Oracle ODBCCan you try something for me? Even though your source table has DECIMAL(30,3), if you know your data will never be larger than would fit into DECIMAL(18,3), can you change the TPT script so that...
12431 Mar 2011 @ 04:09 PDTToolsReplyProblem to load data into teradata table by using tptYou cannot use any expressions in the INSERT statement when using the Load operator. That is a DBS restriction for the FastLoad protocol. Try it using the Update operator (MultiLoad protocol). Th...
12331 Mar 2011 @ 04:07 PDTToolsReplyTPT casting w/ format issuesTry doing the CAST in the SELECT statement for the producer operator (i.e. Selector or Export operator) and not the SELECT in the TPT APPLY-SELECT statement .
12223 Mar 2011 @ 12:59 PDTToolsReplyTPT Extracting Data from Oracle ODBCSince you have such a small row set size right now, I will ask for you to do something. In the script, in the ODBC operator definition, add this: VARCHAR TraceLevel = 'row' And re-run the job...
12109 Mar 2011 @ 12:04 PSTToolsReplyFastload errorLooking at the code, it seems to indicate that the sizes of the columns in the DEFINE statement is more than FastLoad can send in one buffer to the DBS. Please send the entire output of the Fast...
12024 Feb 2011 @ 05:06 PSTToolsReplyhow to load multiple files in fastloadjana.teradata. Please send me your scripts so that I can take a look at what you are trying to do.
11924 Feb 2011 @ 12:00 PSTToolsReplycan i do data converson for column in fastloadExpressions are not allowed in the DML INSERT statement for the FastLoad protocol. This is a Teradata Database restriction (hence the DBS error). The FastLoad utility has no control over this.
11823 Feb 2011 @ 05:50 PSTToolsReplyTPT Extracting Data from Oracle ODBCI would need to see the script, and the TPT output log showing me the detailed output from the ODBC and loading (Load, Update or Stream) operators (the entire .out file would be most helpful). P...
11731 Jan 2011 @ 03:42 PSTToolsReplywhat is to be in define and set record to fatload from excelBased on the data I see, you can use SET RECORD VARTEXT, and specify a delimiter of the space character. Each field definition in the DEFINE statement must be a VARCHAR, so just make sure you ha...
11627 Jan 2011 @ 04:09 PSTToolsReplyDEFINE STATEMENT ON FASTLOADWhat version of FastLoad are you using?
11527 Jan 2011 @ 04:03 PSTToolsReplyBTEQ Export / Import issueAfter the "show table" and prior to the .IMPORT, try this command: .export reset That will close the file "test" and return the output destination to the console instead of the file.
11427 Jan 2011 @ 01:13 PSTToolsReplyhow to load multiple files in fastloadThe only way to accomplish it is to have multiple scripts, where each script omits the END LOADING statement, except for the last script. So, an example could be: Script 1 ===== .logon td...
11326 Jan 2011 @ 07:44 PSTToolsReplyDEFINE STATEMENT ON FASTLOADIt specifies in the FastLoad manual that you need to convert the TIMESTAMP column to its fixed length CHAR equivalent, and use that in the DEFINE statement.
11219 Jan 2011 @ 12:25 PSTToolsReplytpump loading errorYou are running TPump with data in VARTEXT (delimited) mode. You need to specify that in the TPump script and indicate the delimiter character. Please refer to the TPump documentation for the pr...
11119 Jan 2011 @ 12:21 PSTToolsReplyterminated due to the receipt of signal number 11Does this occur every time you try to run this job? If so, then either email me and send all of the logs, or open an incident with the GSC so that they can look into it. I also urge you to go t...
11019 Jan 2011 @ 12:18 PSTToolsReplyTPT Load Operator error table being loaded?As long as the restart log table is preserved, so that the restarted TPT job can retrieve the correct job status, the restarted job should run just fine without the need to drop the error tables an...

Pages