58892 | 03 Aug 2016 @ 12:14 PDT | Vidhya Praveen Prabhu | General | Topic | Concatenate | 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... |
58891 | 02 Aug 2016 @ 11:05 PDT | siddharth91 | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | Getting the same error. Version : 15.11.0.201605311154 downloaded 30 mins ago... My Mac Version is : 10.11.5 (El Capitan)
|
58890 | 02 Aug 2016 @ 03:18 PDT | c0d3 | Database | Topic | Keeps returning zeros for decimal |
Casting as decimal with precision 2, keeps returning 00 after the decimal. How do I actually return values?
column1 hourlycolumn1
---------- --------------... |
58889 | 02 Aug 2016 @ 02:50 PDT | tman8216 | Connectivity | Reply | Excel 2016 VBA Connection | was there any updates on a patch for 2016 to fix the connectivity issue?
|
58888 | 02 Aug 2016 @ 02:27 PDT | RobertDiehl | Database | Topic | Distibution 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... |
58887 | 02 Aug 2016 @ 02:20 PDT | srivigneshkn | Tools | Topic | TPT 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... |
58886 | 02 Aug 2016 @ 02:18 PDT | srivigneshkn | Tools | Reply | Export with header using TPT | Thank you MissGate & Steve,
|
58885 | 02 Aug 2016 @ 02:13 PDT | skunkwerk | Tools | Topic | TPT with JDBC to Kafka | I 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... |
58884 | 02 Aug 2016 @ 09:58 PDT | dnoeth | Database | Reply | ODBC: 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... |
58883 | 02 Aug 2016 @ 09:56 PDT | fgrimmer | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | Can 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... |
58882 | 02 Aug 2016 @ 09:30 PDT | laura.barron@schwab.com | Connectivity | Topic | Connecting to Teradata through PYODBC on Mac | I 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... |
58881 | 02 Aug 2016 @ 09:03 PDT | khawar.ameer | Database | Reply | ODBC: 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... |
58880 | 02 Aug 2016 @ 09:02 PDT | dnoeth | Aster | Reply | Alternative to Strtok in Teradata Aster | As 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... |
58879 | 02 Aug 2016 @ 06:03 PDT | dnoeth | Database | Reply | ODBC: 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... |
58878 | 02 Aug 2016 @ 05:45 PDT | grzegorz_osik | Tools | Topic | Teradata 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... |
58877 | 02 Aug 2016 @ 05:14 PDT | abhishank18 | Database | Topic | Multiload |
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... |
58876 | 02 Aug 2016 @ 05:14 PDT | khawar.ameer | Database | Topic | ODBC: 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.... |
58875 | 02 Aug 2016 @ 04:55 PDT | abhishank18 | Tools | Reply | Record count from worktable in mload | I am follwoing this post, Can anybody pls answer this question ?
|
58874 | 02 Aug 2016 @ 04:41 PDT | sharonn | Database | Topic | How 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... |
58873 | 02 Aug 2016 @ 04:18 PDT | lokesh_meesala | General | Reply | error table's are invalid state or table is being loaded | Hi 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... |
58872 | 02 Aug 2016 @ 03:29 PDT | bkasterm | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | BTW: I am on OS X 10.10.5 (Yosemite).
|
58871 | 02 Aug 2016 @ 03:29 PDT | bkasterm | Teradata Studio | Reply | Teradata 15.1 Error when trying to execute query | I get the same error as @gtmmaj, my teradata studio is version 15.11.0.201605311155 downloaded an hour ago.
|
58870 | 02 Aug 2016 @ 02:00 PDT | jan.simecka | Aster | Reply | Running ncluster_export fails with uppercase objects | Works, thank you!
|
58869 | 02 Aug 2016 @ 01:47 PDT | sargofco72 | Connectivity | Topic | Unable 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... |
58868 | 02 Aug 2016 @ 01:02 PDT | NewbieTD | Database | Topic | Comparing 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&... |