134 | 18 May 2011 @ 10:53 PDT | Tools | Reply | Selecting from file operator in TPT script, "missing SEMOCIL_" error | The 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... |
133 | 12 May 2011 @ 05:27 PDT | Tools | Reply | TPT_ISSUE | By "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 ... |
132 | 12 May 2011 @ 04:24 PDT | Tools | Reply | Using 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... |
131 | 04 May 2011 @ 12:07 PDT | Tools | Reply | TPT issue : not able to open the data file | Well, 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... |
130 | 21 Apr 2011 @ 02:00 PDT | Tools | Reply | TPT Vs other ETL Utilities | TPT "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... |
129 | 20 Apr 2011 @ 12:54 PDT | Tools | Reply | TPT Extracting Data from Oracle ODBC | You 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... |
128 | 13 Apr 2011 @ 10:38 PDT | Tools | Reply | TPT Extracting Data from Oracle ODBC | Just 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... |
127 | 13 Apr 2011 @ 10:34 PDT | Tools | Reply | Release Lock - LOAD Operator - TPT | What 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... |
126 | 13 Apr 2011 @ 10:27 PDT | Tools | Reply | MLOAD - 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... |
125 | 31 Mar 2011 @ 06:41 PDT | Tools | Reply | TPT Extracting Data from Oracle ODBC | Can 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... |
124 | 31 Mar 2011 @ 04:09 PDT | Tools | Reply | Problem to load data into teradata table by using tpt | You 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... |
123 | 31 Mar 2011 @ 04:07 PDT | Tools | Reply | TPT casting w/ format issues | Try 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 . |
122 | 23 Mar 2011 @ 12:59 PDT | Tools | Reply | TPT Extracting Data from Oracle ODBC | Since 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... |
121 | 09 Mar 2011 @ 12:04 PST | Tools | Reply | Fastload error | Looking 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... |
120 | 24 Feb 2011 @ 05:06 PST | Tools | Reply | how to load multiple files in fastload | jana.teradata.
Please send me your scripts so that I can take a look at what you are trying to do.
|
119 | 24 Feb 2011 @ 12:00 PST | Tools | Reply | can i do data converson for column in fastload | Expressions 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. |
118 | 23 Feb 2011 @ 05:50 PST | Tools | Reply | TPT Extracting Data from Oracle ODBC | I 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... |
117 | 31 Jan 2011 @ 03:42 PST | Tools | Reply | what is to be in define and set record to fatload from excel | Based 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... |
116 | 27 Jan 2011 @ 04:09 PST | Tools | Reply | DEFINE STATEMENT ON FASTLOAD | What version of FastLoad are you using? |
115 | 27 Jan 2011 @ 04:03 PST | Tools | Reply | BTEQ Export / Import issue | After 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.
|
114 | 27 Jan 2011 @ 01:13 PST | Tools | Reply | how to load multiple files in fastload | The 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... |
113 | 26 Jan 2011 @ 07:44 PST | Tools | Reply | DEFINE STATEMENT ON FASTLOAD | It 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.
|
112 | 19 Jan 2011 @ 12:25 PST | Tools | Reply | tpump loading error | You 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... |
111 | 19 Jan 2011 @ 12:21 PST | Tools | Reply | terminated due to the receipt of signal number 11 | Does 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... |
110 | 19 Jan 2011 @ 12:18 PST | Tools | Reply | TPT 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... |