#DateForumTypeThreadPost
3330 May 2016 @ 03:32 PDTToolsReply TPT03036: Length must be a positive integer valueAs 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...
3230 May 2016 @ 03:18 PDTToolsReply TPT03036: Length must be a positive integer valueAnd the problem seems to be in the SELECT part as SELECT * goes through fine as well.
3130 May 2016 @ 03:16 PDTToolsTopic TPT03036: Length must be a positive integer valueThere 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...
3030 May 2016 @ 03:09 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorHmm, 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? 
2925 May 2016 @ 02:51 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorI 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.
2824 May 2016 @ 05:30 PDTTeradata ApplicationsReplyBTEQ - DELIMITERdineshks, 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
2724 May 2016 @ 03:12 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorI 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 ...
2624 May 2016 @ 12:21 PDTDatabaseReplyTeradata 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...
2524 May 2016 @ 05:35 PDTTeradata ApplicationsReplyExport multiple SQL's results into single excel sheet by sheetTeradata 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...
2420 Jan 2016 @ 03:42 PSTConnectivityReplyTeradata 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
2301 Jan 2016 @ 07:15 PSTToolsReplySending data to Windows Named PipeThanks 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...
2231 Dec 2015 @ 08:53 PSTToolsReplySending data to Windows Named PipeMore information about that can be found in Teradata Tools and Utilities Access Module Reference. It was really helpful.
2103 Sep 2015 @ 01:37 PDTConnectivityReplyInstalling Teradata ODBC Driver in CYGWINIs there a reason why you want to use Cygwin? Why wouldn't you just use "pip install teradata" from Windows command line prompt?
2029 Jun 2015 @ 04:49 PDTDatabaseReplyInserting Unicode Characters into a Unicode FieldIt seems I have a similar problem with a French character https://en.wiktionary.org/wiki/%C3%B4     Character  ô  Uni...
1919 May 2015 @ 06:40 PDTTeradata ApplicationsReplyTPT export and error code 2595It 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...
1812 Jul 2011 @ 11:17 PDTDatabaseReplyDealing 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)
1712 Jul 2011 @ 01:22 PDTDatabaseReplymake use of ppi partition elimination without a hardcoded dateI 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 ...
1611 Jul 2011 @ 09:08 PDTDatabaseTopicmake use of ppi partition elimination without a hardcoded dateIs 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...
1521 Jul 2010 @ 07:01 PDTToolsReplyfastexportTo 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...
1423 Apr 2010 @ 02:35 PDTDatabaseReplyJunk 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...
1309 Oct 2007 @ 03:07 PDTAnalyticsReplyTranspose Columns to RowsAlternatively you could use the Teradata Datawarehouse Miner, which can generate transposing code for you.
1216 Oct 2006 @ 11:38 PDTUDAReplySupressing Titles on .EXPORT command.SET TITLEDASHES OFF;will do if you only want to get rid of the dashes.
1118 Aug 2006 @ 11:37 PDTTrainingReplyFastLoad, Multiload UsageI 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...
1018 Aug 2006 @ 11:30 PDTToolsReplyProblem 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...
916 Aug 2006 @ 04:56 PDTToolsReplyProblem 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.

Pages