#DateForumTypeThreadPost
9401 Oct 2013 @ 09:46 PDTDatabaseReplyFamous Failed [3504: HY000] Selected non-aggregate values must be part of the associated groupWell, 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...
9301 Oct 2013 @ 09:35 PDTDatabaseReplyDate Field(yyyy-mm-dd). Remove Day from Date FieldThanks diether for the clarification!
9201 Oct 2013 @ 09:52 PDTDatabaseReplyDate Field(yyyy-mm-dd). Remove Day from Date FieldSorry, 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; ...
9101 Oct 2013 @ 09:10 PDTDatabaseReplyDate Field(yyyy-mm-dd). Remove Day from Date FieldYou 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_...
9001 Oct 2013 @ 08:55 PDTGeneralReplyOracle 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...
8901 Oct 2013 @ 08:49 PDTDatabaseReplyDate Field(yyyy-mm-dd). Remove Day from Date FieldThe 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...
8801 Oct 2013 @ 08:41 PDTToolsReplyTeradata TPT errorThis 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...
8701 Oct 2013 @ 02:31 PDTTeradata ApplicationsReplyShared 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.  
8630 Sep 2013 @ 12:58 PDTDatabaseReplyTrouble with timestamp(6) in TD 13.10I 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.   
8530 Sep 2013 @ 12:56 PDTCloud ComputingReplyTD 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  
8428 Sep 2013 @ 12:07 PDTDatabaseReplyTrouble with timestamp(6) in TD 13.10I 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 ...
8328 Sep 2013 @ 11:57 PDTDatabaseReplyTeradata Express Database for WindowsI 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...
8228 Sep 2013 @ 11:29 PDTDatabaseReplyUnable to find Samples database from Teradata SQL ClientThe 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.    
8127 Sep 2013 @ 12:14 PDTDatabaseReplyDynamically Determine Date Range Based on System DateHi, 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/  
8027 Sep 2013 @ 01:38 PDTDatabaseReplyUnable to find Samples database from Teradata SQL ClientYou 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. ...
7926 Sep 2013 @ 11:46 PDTDatabaseReplyTeradata Express for WIN 32 BITI 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.  
7826 Sep 2013 @ 11:43 PDTDatabaseReplyTrouble with timestamp(6) in TD 13.10Do you want to collect milliseconds now OR want to trun them off? Please clarify  
7726 Sep 2013 @ 11:42 PDTDatabaseReplyTeradata Express Database for WindowsYou can download the Teradata Express for Windows from the following URL: http://developer.teradata.com/database/articles/expanded-teradata-express-family-available  
7626 Sep 2013 @ 01:23 PDTDatabaseReplyReg: connecting to serverYes 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...
7525 Sep 2013 @ 11:26 PDTDatabaseReplyLT,WT,ET,UV tablesYou 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...
7425 Sep 2013 @ 11:17 PDTToolsReplyTD Administrator and SQL Assistant compatibility on Windows Terminal Server 2012Hi, 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...
7325 Sep 2013 @ 11:07 PDTDatabaseReplyObtain a result from the diference between 2 timestampsYou can use the following query: SEL TIME '12:51:00' - INTERVAL '12:49:15' HOUR TO SECOND;  
7225 Sep 2013 @ 12:17 PDTDatabaseReplyDynamically Determine Date Range Based on System DateHi, 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 ...
7124 Sep 2013 @ 11:55 PDTGeneralReplyIssues with VMPlayer version of Teradata 13Hi, You can download the Teradata Express for windows from the following URL: http://developer.teradata.com/database/articles/expanded-teradata-express-family-available  
7024 Sep 2013 @ 11:23 PDTDatabaseReplyHow to calculate business days turntime between 2 timestampsHi, You can consult the following thread: http://forums.teradata.com/forum/database/calculate-business-days-hours-between-two-timestamp6-fields  

Pages