33 | 30 May 2016 @ 03:32 PDT | Tools | Reply | TPT03036: Length must be a positive integer value | As it often happens I got an eureka! moment just after posting :-). The culprit was an explicit empty string as in
SELECT '' AS emptyfield FROM ...
So just two single quotes as a field... |
32 | 30 May 2016 @ 03:18 PDT | Tools | Reply | TPT03036: Length must be a positive integer value | And the problem seems to be in the SELECT part as SELECT * goes through fine as well.
|
31 | 30 May 2016 @ 03:16 PDT | Tools | Topic | TPT03036: Length must be a positive integer value | There is a following error message from a tbuild execution:
Teradata Parallel Transporter Version 14.10.00.10
TPT_INFRA: Semantic error at or near line 12 of Generated Schema based on SELECT... |
30 | 30 May 2016 @ 03:09 PDT | Tools | Reply | ASCII value of the delimiter in TPT Export Operator | Hmm, I actually need the tab in the OpenQuoteMark, not in the TextDelimiter. Judging by its name seems like TextDelimiterHex should't be of help here. Or am I missing something?
|
29 | 25 May 2016 @ 02:51 PDT | Tools | Reply | ASCII value of the delimiter in TPT Export Operator | I have just tried out with pressing TAB on the keyboard in vi. It gets converted to a space in the resulting exported text file. So unfortunately it does not work this way either.
|
28 | 24 May 2016 @ 05:30 PDT | Teradata Applications | Reply | BTEQ - DELIMITER | dineshks, have you seen this already? http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Load_and_Unload_Utilities/B035_2501_071A/2501Chap2.103.3.html
|
27 | 24 May 2016 @ 03:12 PDT | Tools | Reply | ASCII value of the delimiter in TPT Export Operator | I have a similar question so posting into this thread. As per this recipe http://superuser.com/questions/318420/formatting-a-comma-delimited-csv-to-force-excel-to-interpret-value-as-a-string?lq=1
... |
26 | 24 May 2016 @ 12:21 PDT | Database | Reply | Teradata Error: [3704] '' ('0A'X) is not a valid Teradata SQL token. | The solution I found is to remove all new lines \n from the SelectStmt. This is very annoying.
Personally I think that this is a scandal for Teradata to have such bugs in their code for such a lo... |
25 | 24 May 2016 @ 05:35 PDT | Teradata Applications | Reply | Export multiple SQL's results into single excel sheet by sheet | Teradata basic utilites are pretty lame regarding basic MS office related stuff. I understand, they were developed before MS was even a company. But it makes the life of an analyst rather frustrati... |
24 | 20 Jan 2016 @ 03:42 PST | Connectivity | Reply | Teradata ODBC Teradata Driver Not enough information to log on - Python/SQL Assistant ODBC |
udaExec = teradata.UdaExec(appName="test", version="1.0"
, logConsole=True)
set
logConsole=True
and check if that brings any clarity
|
23 | 01 Jan 2016 @ 07:15 PST | Tools | Reply | Sending data to Windows Named Pipe | Thanks to @Sastry for his tips. I want to give back and share a boilerplate to pipe data from Python to Fasltoad via a named pipe on Windows (tested with Windows7).
teradata_dn = 'your datab... |
22 | 31 Dec 2015 @ 08:53 PST | Tools | Reply | Sending data to Windows Named Pipe | More information about that can be found in Teradata Tools and Utilities Access Module Reference. It was really helpful.
|
21 | 03 Sep 2015 @ 01:37 PDT | Connectivity | Reply | Installing Teradata ODBC Driver in CYGWIN | Is there a reason why you want to use Cygwin? Why wouldn't you just use "pip install teradata" from Windows command line prompt?
|
20 | 29 Jun 2015 @ 04:49 PDT | Database | Reply | Inserting Unicode Characters into a Unicode Field | It seems I have a similar problem with a French character
https://en.wiktionary.org/wiki/%C3%B4
Character
ô
Uni... |
19 | 19 May 2015 @ 06:40 PDT | Teradata Applications | Reply | TPT export and error code 2595 | It would be appreciated if somebody could give us a hint as to where to start debugging when getting the 2595 error. It is three years already since we saw this problem and it keeps coming up for b... |
18 | 12 Jul 2011 @ 11:17 PDT | Database | Reply | Dealing with Duplicates. | create table duplicates as (
select * from your_table
qualify rank() over (partition by account_number order by load_date ascending) >1
) with data primary index (account_number,load_date) |
17 | 12 Jul 2011 @ 01:22 PDT | Database | Reply | make use of ppi partition elimination without a hardcoded date | I forgot to mention that the table transaction_table gets redistributed by the hash value of customer_id, transaction_date and this seems to be a problem. If the hard-coded date is present the PPI ... |
16 | 11 Jul 2011 @ 09:08 PDT | Database | Topic | make use of ppi partition elimination without a hardcoded date | Is there any other way of reliably tell the optimizer to use the PPI other than hard-coding the minimal/maximal value (date) in a following case?
Here is a DDL for a big table with customer tra... |
15 | 21 Jul 2010 @ 07:01 PDT | Tools | Reply | fastexport | To export into a fixed width flat file run this query:
SELECT ColumnID, ColumnLength, ColumnType, ColumnName,
CASE
WHEN ColumnType = 'CF' THEN ColumnLength -- char
WHEN ColumnType = 'CV' THEN... |
14 | 23 Apr 2010 @ 02:35 PDT | Database | Reply | Junk Characters in FASTEXPORTED Flat file.. | To not to waste the space with trailing spaces I have created the following selects to aid writing the casting part for an arbitrary table. Just run the first three selects and paste the results in... |
13 | 09 Oct 2007 @ 03:07 PDT | Analytics | Reply | Transpose Columns to Rows | Alternatively you could use the Teradata Datawarehouse Miner, which can generate transposing code for you. |
12 | 16 Oct 2006 @ 11:38 PDT | UDA | Reply | Supressing Titles on .EXPORT command | .SET TITLEDASHES OFF;will do if you only want to get rid of the dashes. |
11 | 18 Aug 2006 @ 11:37 PDT | Training | Reply | FastLoad, Multiload Usage | I do not pretend to give you exhaustive answer, but once I've noticed your post...From my practial view: FastLoad is faster than Multiload, but one can open only a limited number of load sessions a... |
10 | 18 Aug 2006 @ 11:30 PDT | Tools | Reply | Problem using Teradata import - making me crazy!! | 02251219 |381646195I have noticed than you have a space after the first number.I had to set the delimiter in Queryman Export Option to | and also asked to enclose the values in "."02251219 "|"38164... |
9 | 16 Aug 2006 @ 04:56 PDT | Tools | Reply | Problem using Teradata import - making me crazy!! | Sorry, the forum told me my message could not be added, that's why I have it posted 4 times. |