All forum activity

#DateUserForumTypeThreadPost
5889403 Aug 2016 @ 12:14 PDTVidhya Praveen PrabhuGeneralTopicConcatenate   I am having 5 columns say Col1 to Col5. The data present in Col1 to Col 5 is either 0 or 1.  My requirement is I need to populate the data in a FLG column as wherever the data as 1.&nb...
5889302 Aug 2016 @ 11:05 PDTsiddharth91Teradata StudioReplyTeradata 15.1 Error when trying to execute queryGetting the same error. Version : 15.11.0.201605311154 downloaded 30 mins ago...  My Mac Version is : 10.11.5 (El Capitan)
5889202 Aug 2016 @ 03:18 PDTc0d3DatabaseTopicKeeps returning zeros for decimal Casting as decimal with precision 2, keeps returning 00 after the decimal. How do I actually return values?   column1   hourlycolumn1 ----------   --------------...
5889102 Aug 2016 @ 02:50 PDTtman8216ConnectivityReplyExcel 2016 VBA Connectionwas there any updates on a patch for 2016 to fix the connectivity issue?
5889002 Aug 2016 @ 02:27 PDTRobertDiehlDatabaseTopicDistibution of Small table (rows less than number of amps) to single amp for Performance There was an old technique where you would make tables with number of rows less than the number of amps distirbute to a singel amp. You would do this by creating a PI_column and populate it with t...
5888902 Aug 2016 @ 02:20 PDTsrivigneshknToolsTopicTPT export into AWS S3 buckets.Hi,    I am using TPT to export data to a file and move into S3 buckets., am curious to know if there is a way to export data and write directly into AWS S3 buckets.   Thanks &am...
5888802 Aug 2016 @ 02:18 PDTsrivigneshknToolsReplyExport with header using TPTThank you MissGate & Steve, 
5888702 Aug 2016 @ 02:13 PDTskunkwerkToolsTopicTPT with JDBC to KafkaI can get TPT working from the Teradata Utilities on Linux, but I have to write this massive script to specify each column name and data type. I'm trying to get it working from Kafka's JDB...
5888602 Aug 2016 @ 09:58 PDTdnoethDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. Do the modifications I wrote (and add a final Group By), this results in a query like this: with t1(Account_Num, Acct_Status_End_Dt) As ( Select Account_Num, Acct_Status_End_Dt from dp_vie...
5888502 Aug 2016 @ 09:56 PDTfgrimmerTeradata StudioReplyTeradata 15.1 Error when trying to execute queryCan you open an incident for this so we can gather the error logs and configuration information? As a work around, can you try creating another connection profile with the same attributes as the fi...
5888402 Aug 2016 @ 09:30 PDTlaura.barron@schwab.comConnectivityTopicConnecting to Teradata through PYODBC on MacI have been trying to connect to Teradata using PYODBC from my Mac terminal. I have the Teradata ODBC drivers installed but PYODBC doesn't seem to be able to find them. This is the connection s...
5888302 Aug 2016 @ 09:03 PDTkhawar.ameerDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. @dnoeth Actually i want to select Account_Num and Account_Status_End_Dt from Account_Status_Hist table based on Account_Num from Agreement Table with condition that their bnrahc_party_id should be...
5888202 Aug 2016 @ 09:02 PDTdnoethAsterReplyAlternative to Strtok in Teradata AsterAs long as there's only a single character delimiter you can get a similar result using split_part('Text1,Text2,Text3,Text4,Text5',',',1)  Caution: multiple consecuti...
5888102 Aug 2016 @ 06:03 PDTdnoethDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. There are multiple problems with your query, the error message is caused by Select t2(Account_Num this should probaby be Select t2.Account_Num, but there's no alias t2 defined, y...
5888002 Aug 2016 @ 05:45 PDTgrzegorz_osikToolsTopicTeradata Parallel Transporter - error with automatic schema Using Teradata parallel transport with simplified syntax we get error  TPT02638: Error: Conflicting data length for column(3) - "sr_abo_netto_do_oferty". Source column's d...
5887902 Aug 2016 @ 05:14 PDTabhishank18DatabaseTopicMultiload I have below two questions on Multiload:-  While going through Multiload reference document, I found that a 'Field overflow on columns',  will go into application error...
5887802 Aug 2016 @ 05:14 PDTkhawar.ameerDatabaseTopicODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. Dear All, I am getting the subject error while running following code theough ODBC. with t1(Account_Num, Acct_Status_End_Dt) As ( Select Account_Num, Acct_Status_End_Dt from dp_view_t24_ibg....
5887702 Aug 2016 @ 04:55 PDTabhishank18ToolsReplyRecord count from worktable in mloadI am follwoing this post, Can anybody pls answer this question ?  
5887602 Aug 2016 @ 04:41 PDTsharonnDatabaseTopicHow to concatenate rows into a varchar parameter in a Stored Procedure?     Hi , I would like to concatenate a column data (multi rows) into one string inside a Stored Procedure. I’ve succeeded getting what I want using CTE (with recu...
5887502 Aug 2016 @ 04:18 PDTlokesh_meesalaGeneralReplyerror table's are invalid state or table is being loadedHi Fred,  i need one more help for file upload.  how to allow if  file column value exceeds than the length defined in the target table. please let me know if there are any attrib...
5887402 Aug 2016 @ 03:29 PDTbkastermTeradata StudioReplyTeradata 15.1 Error when trying to execute queryBTW: I am on OS X 10.10.5 (Yosemite).
5887302 Aug 2016 @ 03:29 PDTbkastermTeradata StudioReplyTeradata 15.1 Error when trying to execute queryI get the same error as @gtmmaj, my teradata studio is version 15.11.0.201605311155 downloaded an hour ago.
5887202 Aug 2016 @ 02:00 PDTjan.simeckaAsterReplyRunning ncluster_export fails with uppercase objectsWorks, thank you!
5887102 Aug 2016 @ 01:47 PDTsargofco72ConnectivityTopicUnable to Connect to Teradata Database from Teradata Studio on iOS (Mac)Hello Guys, I am to attempt to connect to a remote TERADATA Database from the Teradata Studio from my Mac. The error reported is showed below and this same error happened from the Linux Operating S...
5887002 Aug 2016 @ 01:02 PDTNewbieTDDatabaseTopicComparing current column with next column and generating values dynamically --Source: =============== id|MainVal|st_tm|end_tm|subval1|st_tm|end_tm|subval2|st_tm|End_tm|subval3|st_tm|end_tm 01|xxx    |07:30|16:00 |aaa    |12:00|12:30 |bbb&...

Pages