59166 | 15 Aug 2016 @ 10:23 PDT | krishna1985 | Database | Topic | SQL query needed---Urgent | Hi All,
I have source data as
Month x y
Aug 14 3000 &n... |
59165 | 15 Aug 2016 @ 09:37 PDT | Smac | General | Reply | Multi Column Primary Index and Secondary Index | Many Thank Fred. Helps lot!
|
59164 | 15 Aug 2016 @ 08:01 PDT | dbloch | Connectivity | Reply | OLEDB Driver of TD15.10 | .NET Connector seems much slower than old OLEDB connector btw.
|
59163 | 15 Aug 2016 @ 07:46 PDT | krishna1985 | Tools | Reply | Casting Date in Bteq utilities | Hi Fred,
thank you very much for your inputs howver I have tried to create the staging table with the below query and used oTranslate funcion to pad 0 if its single digit
substri... |
59162 | 15 Aug 2016 @ 05:58 PDT | au185006 | Teradata Database on AWS | Reply | Does AWS have bring-your-own-license model for Teradata Database? | Not currently but it on the roadmap as an offer. I am nt aware of the Target date, but will update when there is one.
|
59161 | 15 Aug 2016 @ 05:55 PDT | franceszhu | Teradata Database on AWS | Topic | Does AWS have bring-your-own-license model for Teradata Database? | I am looking for Teradata database solutions on AWS. Does AWS have bring-your-own-license model for Teradata Database? Thanks.
|
59160 | 15 Aug 2016 @ 05:13 PDT | CrayRay | Database | Topic | Performance Issue - Left Join vs Update | Hi everyone, I have 2 tables as below:
Main (20 mil rows, 50 other columns):
Col1 Col2 Col3
a 2 3
b 2 &n... |
59159 | 15 Aug 2016 @ 04:52 PDT | franceszhu | Teradata Database on AWS | Reply | Does AWS provides previous versions of Teradata Database? | Thanks for the information.
|
59158 | 15 Aug 2016 @ 04:00 PDT | skunkwerk | Tools | Reply | TPT with JDBC to Kafka | thanks Tom.
Does anyone have a working Teradata -> Kafka configuration they can share?
I have Kafka, Zookeeper, & a Schema Registry up and running.
But when I run the JDBC connect... |
59157 | 15 Aug 2016 @ 02:09 PDT | au185006 | Teradata Database on AWS | Reply | Does AWS provides previous versions of Teradata Database? | 15.10 is the only version of the database available on AWS.
|
59156 | 15 Aug 2016 @ 01:39 PDT | franceszhu | Teradata Database on AWS | Topic | Does AWS provides previous versions of Teradata Database? | I am looking for Teradata database version 14.10 on AWS. I see all Teradata database products on AWS are Version 15.10.02.06. Does AWS provide previous versions. If yes, how do I get it?
&nbs... |
59155 | 15 Aug 2016 @ 01:09 PDT | mitsukiefi | Tools | Topic | Fatal Error with TD TPT API | Dear All
Our reporting tool generates the following SQL query to be executed on TD 15.10:
select a11.Gl_Acct_Prod_Grp_Id Gl_Acct_Prod_Grp_Id,
a11.Gl_Acct_Prod_Grp_Src_Id Gl_Acct_Prod_Grp_Sr... |
59154 | 15 Aug 2016 @ 12:16 PDT | Fred | Tools | Reply | Casting Date in Bteq utilities | FastLoad supports only limited data type conversions, either implicit or using Teradata-style syntax. And at a minimum you would need to change the input to always have 2 digits for the h... |
59153 | 15 Aug 2016 @ 11:50 PDT | Fred | Database | Reply | A table with non-latin characters in table name and column names doesn't display properly | help session;
|
59152 | 15 Aug 2016 @ 11:44 PDT | Fred | UDA | Reply | BT/ET | Not sure what you mean by "in Unix". Do you mean "in BTEQ?"
By default SQL Assistant stops executing SQL when an error is encountered.
In BTEQ you must explicitly check&n... |
59151 | 15 Aug 2016 @ 11:22 PDT | KellnerK | Tools | Reply | BTEQ and OReplace | Thank you Dieter, that was exactly the case. I did not realize that by not explicity casting the oReplace that it would expand the field size so significantly. Casting back to VarChar(3... |
59150 | 15 Aug 2016 @ 11:21 PDT | Fred | General | Reply | Multi Column Primary Index and Secondary Index | Non-unique PI(acctid) may be best choice if number of rows per acctid isn't too huge.
Partitioning on bus_dt may be better choice than USI. Again, somewhat depends on avg / max number of ... |
59149 | 15 Aug 2016 @ 10:58 PDT | feinholz | Tools | Reply | Understanding teradata sample scripts | The $FILE_WRITER and $LOAD syntax describes the use of templates.
Those templates define the operators you are trying to use, and those operator definitions are found in the "templates" ... |
59148 | 15 Aug 2016 @ 10:32 PDT | raddatz.dennis@gmail.com | Database | Reply | Datatype of a Column of a View | I have the following CASE statement in my view:
SELECT
CAST((CASE EV.EVNT_CD
WHEN 'A001' THEN 'SOMETHINGxxxxxxxx'
ELSE 'UN... |
59147 | 15 Aug 2016 @ 07:16 PDT | HanC | Database | Reply | Bteq import the output characters got cut off by 2 | Thank you so much Dieter! It is working as expected. You made my day!
|
59146 | 15 Aug 2016 @ 07:08 PDT | sdc | Database | Topic | SQL command for setting connection option to return generated keys | Hello,
I am setting the following parameter in a connection string:
ReturnGeneratedKeys="C"
Instead, I'd like to set this option via an SQL command after having made the connecti... |
59145 | 15 Aug 2016 @ 06:07 PDT | sk8s3i | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | Worked as a charm! Thanks Dieter! :-D
|
59144 | 15 Aug 2016 @ 05:20 PDT | dnoeth | Connectivity | Reply | CLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGON | The delay is caused by the lookup to find an ip-address for teracli., the COP discovery:
BTEQ/CLI adds COP1 to the hostname and resolves it to an p-address, if successful the number is increased t... |
59143 | 15 Aug 2016 @ 04:41 PDT | dnoeth | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | You should find 9 UDFs in syslib and 10 in td_sysfnlib with the name GREATEST (but different specific names).
The functions in syslib are not the built-in functions (those UDFs have been installed... |
59142 | 15 Aug 2016 @ 04:18 PDT | sk8s3i | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | Thank you Dieter!
I did check using dbc.FunctionsV for the function 'GREATEST', and I got one row in result set:
Databasename: SYSLIB
FunctionName: GREATEST
SpecificName... |