94 | 01 Oct 2013 @ 09:46 PDT | Database | Reply | Famous Failed [3504: HY000] Selected non-aggregate values must be part of the associated group | Well, The first thing is you are not using any aggregate function in the select, in the abscence of aggregation when you use the group by clause you must include all the selected columns in the gro... |
93 | 01 Oct 2013 @ 09:35 PDT | Database | Reply | Date Field(yyyy-mm-dd). Remove Day from Date Field | Thanks diether for the clarification!
|
92 | 01 Oct 2013 @ 09:52 PDT | Database | Reply | Date Field(yyyy-mm-dd). Remove Day from Date Field | Sorry, to add the column attribute like format you need to use the following syntax:
CREATE TABLE Test(sdate FORMAT 'YYYY-MM')
AS
(SELECT date_col FROM TableName)WITH DATA;
... |
91 | 01 Oct 2013 @ 09:10 PDT | Database | Reply | Date Field(yyyy-mm-dd). Remove Day from Date Field | You can use either the keyword AS to name a column or by providing a list of columns in the table header.
for example
Create table pp_oap_jeggert_t.ACH_US_MA_VintageData_V1 AS (
SELECT C.acct_... |
90 | 01 Oct 2013 @ 08:55 PDT | General | Reply | Oracle to Teradata SQL equivalents? | You can use the following:
SELECT CURRENT_TIMESTAMP(0) - INTERVAL '1' HOUR;
I doubt that you can not subtract HOUR from date, thats why you will have to either use timestamp, Or conver... |
89 | 01 Oct 2013 @ 08:49 PDT | Database | Reply | Date Field(yyyy-mm-dd). Remove Day from Date Field | The extract function is used to get a specific part of a date, e.g. day, month or year. To remove the day part you can use the following query:
SELECT CURRENT_DATE (FORMAT 'YYYY-MM');
U... |
88 | 01 Oct 2013 @ 08:41 PDT | Tools | Reply | Teradata TPT error | This error occures when there is a mismatch between the data types of fields in the Schema definition and the select statement. You need to cast the mismatching columns in the select. Look into the... |
87 | 01 Oct 2013 @ 02:31 PDT | Teradata Applications | Reply | Shared ICU Libraries.. | You need to install CLIV2 for TD 14. These libraries are shiped with TTU. You can install both the CLI Libraries and OLEDB drivers by selecting the options from TTU installation wizard.
|
86 | 30 Sep 2013 @ 12:58 PDT | Database | Reply | Trouble with timestamp(6) in TD 13.10 | I have recently gone through a session level setting for date, timestamp and time fromats. you can check the session level settings in Bteq and ODBC advanced options.
|
85 | 30 Sep 2013 @ 12:56 PDT | Cloud Computing | Reply | TD 14.10 Express: What are the systemrequirements or where do I find them? | Hi,
You can download the TD 14 Express VMWare and all the related details on the floowing URL:
http://downloads.teradata.com/download/database/teradata-express/vmware
|
84 | 28 Sep 2013 @ 12:07 PDT | Database | Reply | Trouble with timestamp(6) in TD 13.10 | I am not sure if there is any such parameter in DBSControl. I dont think this is an issue caused by shifting from TD 12 to TD 13.
You must probe into the issue, it might be a change in the source ... |
83 | 28 Sep 2013 @ 11:57 PDT | Database | Reply | Teradata Express Database for Windows | I think the best way is to download VMWare, install the Teradata utilities on you local machine. and access the Database running on VM from your system. This way using can perform all the activitie... |
82 | 28 Sep 2013 @ 11:29 PDT | Database | Reply | Unable to find Samples database from Teradata SQL Client | The best way is to create a user under dbc with max of perm, and then use this user to create other objects e.g databases, tables.
|
81 | 27 Sep 2013 @ 12:14 PDT | Database | Reply | Dynamically Determine Date Range Based on System Date | Hi,
I have not done much work in Business Objects. You cant refer to the following blog, and I am sure it contains info you need.
http://bobjblog.wordpress.com/tag/formatdate/
|
80 | 27 Sep 2013 @ 01:38 PDT | Database | Reply | Unable to find Samples database from Teradata SQL Client | You have to add the Samples database in SQLA manually.
In the database explorer windows right click on the top most node, Select Add Database, and in the prompt enter database name, Click ok. ... |
79 | 26 Sep 2013 @ 11:46 PDT | Database | Reply | Teradata Express for WIN 32 BIT | I doubt that TD Express 14 is only available in the form of VM. It is not available separately to install on Windows (32-64 bit).
If anyone have update about this please correct me as well.
|
78 | 26 Sep 2013 @ 11:43 PDT | Database | Reply | Trouble with timestamp(6) in TD 13.10 | Do you want to collect milliseconds now OR want to trun them off? Please clarify
|
77 | 26 Sep 2013 @ 11:42 PDT | Database | Reply | Teradata Express Database for Windows | You can download the Teradata Express for Windows from the following URL:
http://developer.teradata.com/database/articles/expanded-teradata-express-family-available
|
76 | 26 Sep 2013 @ 01:23 PDT | Database | Reply | Reg: connecting to server | Yes it is possible. Do the following to accomplish this:
On SQLA go to Tools -> Options -> General.
On General tab there is a checkbox "allow connections to multiple data s... |
75 | 25 Sep 2013 @ 11:26 PDT | Database | Reply | LT,WT,ET,UV tables | You can read the basics about the TPT from the following, And the remaining three (MLOAD, FASTLOAD, TPUMP) processing protocols are covered in TPT as well.
http://teradataworld.wordpress.com/terad... |
74 | 25 Sep 2013 @ 11:17 PDT | Tools | Reply | TD Administrator and SQL Assistant compatibility on Windows Terminal Server 2012 | Hi,
Which version of Teradata utilties you are using?
You can download these utilities from the following URL and give it a try on Windows Terminal Server 2012.
http://downloads.teradata.c... |
73 | 25 Sep 2013 @ 11:07 PDT | Database | Reply | Obtain a result from the diference between 2 timestamps | You can use the following query:
SEL TIME '12:51:00' - INTERVAL '12:49:15' HOUR TO SECOND;
|
72 | 25 Sep 2013 @ 12:17 PDT | Database | Reply | Dynamically Determine Date Range Based on System Date | Hi,
You can use the following query.
SELECT CURRENT_DATE - EXTRACT(DAY FROM CURRENT_DATE) AS PREV_MONTH , (ADD_MONTHS(PREV_MONTH, -12) +1) PREV_MONTH_LAST_YEAR;
The ADD_MONTH Function ... |
71 | 24 Sep 2013 @ 11:55 PDT | General | Reply | Issues with VMPlayer version of Teradata 13 | Hi,
You can download the Teradata Express for windows from the following URL:
http://developer.teradata.com/database/articles/expanded-teradata-express-family-available
|
70 | 24 Sep 2013 @ 11:23 PDT | Database | Reply | How to calculate business days turntime between 2 timestamps | Hi,
You can consult the following thread:
http://forums.teradata.com/forum/database/calculate-business-days-hours-between-two-timestamp6-fields
|