All forum activity

#DateUserForumTypeThreadPost
69204 Apr 2006 @ 02:38 PDTJeanne-AnneDatabaseReplyHow to get tablenameWhat sort of equivalent? What are you trying to do?
69104 Apr 2006 @ 02:37 PDTJeanne-AnneDatabaseTopicIdentifying invalid views?In our development and test environments, it is very common for a view to be created and then the underlying object changed or dropped. This renders the view invalid and any action attempted with i...
69004 Apr 2006 @ 11:54 PDTmike_nguyenDatabaseTopicHow to get tablenameHi,What is the equivalent for select table_name from user_tables in Teradata database?Thanks,Michael
68904 Apr 2006 @ 08:38 PDTBarry-1604ToolsReplyFastexport helpYou have to name each of the columns in your derived table. So, your query should look like this:SELECT CAST(MAX(CHARACTER_LENGTH(TRIM(X.State_Cd) || '|' ||TRIM(X.Company_Cd) || '|' ||TRIM(SUBSTR(...
68804 Apr 2006 @ 08:32 PDTBarry-1604ToolsReplyNumeric overflowThe only way that I can think of that you can do this is to break the column apart into two numbers. Then, sum them up separately, and then put them back together again into a CHAR column. When y...
68704 Apr 2006 @ 06:21 PDTSomnathTrainingTopicPreparation for Teradata Certification ExamHello everybody,I am new to this group. Currently, I am working as a Data Modeler in a Data Warehouse project in Oracle. Currently, our client is moving to Teradata. So I have to do the Certificat...
68604 Apr 2006 @ 02:00 PDTdnoethDatabaseReplyhow to find version of a teradata database?select * from dbc.dbcinfo;Dieter
68504 Apr 2006 @ 01:50 PDTlijuDatabaseTopichow to find version of a teradata database?hi,how do i find version of a teradata database from the client?
68403 Apr 2006 @ 12:39 PDTBarry-1604UDAReplyNEED TO CHECK FORMAT TO 'YYYY-MM-DD'Modify the query to the following:sel yt.mydateFROM your_table yt,LEFT OUTER JOIN SYS_CALENDAR.CALENDAR CALON (CALENDAR_DATE (FORMAT 'YYYY-MM-DD') (CHAR(10))) = yt.mydateWHERE CALENDAR_DATE IS NULL...
68303 Apr 2006 @ 12:16 PDTJerryJobsTopicTeradata Admin Needed in : Columbus, OHJob Title : Database Administrator IIIJob Description : Implements and maintains the DB environment. Primary function is to monitor and maintain a production Teradata database environment, includi...
68203 Apr 2006 @ 11:29 PDTmike_nguyenDatabaseReply3706 Syntax error with select statementI figured it out.select (cast (current_timestamp) as date - col_a from ....Thanks,Michael
68103 Apr 2006 @ 10:18 PDTmike_nguyenDatabaseReply3706 Syntax error with select statementHi Dieter,Thanks for response , the datatype for col2 is timestamp and the col_A is an integer.I used your suggestion, and I'm getting a 5407 error code: Invalid operation on an ANSI Datetime or I...
68003 Apr 2006 @ 09:33 PDTVincent GabrielliToolsReplyTeradata SyntaxThanks Dieter.. I tried the cast and worked fine!....
67903 Apr 2006 @ 06:57 PDTyoungDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.FYI...SELECT RANK(employee_number) ,employee_number ,last_nameFROM CUSTOMER_SERVICE.employee;Rank(Employee_Number) 1 Employee_Number 1025 Last_Name ShortRank(Employee...
67803 Apr 2006 @ 06:46 PDTyoungDatabaseTopicTD olap func need helpSELECT storeid ,prodid ,sales ,SUM(sales) OVER (ORDER BY sales DESC ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)FROM salestbl;I got answer set:storeid 1003 prodid C sal...
67703 Apr 2006 @ 04:51 PDTAmitToolsReplyNumeric overflowThanks for the reply. I know (18,2) will only have 16 digits to the left of the decimal. But my question is how can we treat a number having more than 16 digits to the left of the decimal. I hope I...
67602 Apr 2006 @ 03:42 PDTdnoethToolsReplyTeradata SyntaxHi Vincent,in V2R5.1+ the easiest way would be a UDF.If a.chargeable_drtn is a decimal > 0:case when (x mod 1) = 0 then x else x + 1 - (x mod 1) endor:cast(x + 0.9 as int) -- for dec(x,1)cast(x + 0...
67502 Apr 2006 @ 03:06 PDTdnoethDatabaseReply3706 Syntax error with select statementHi Michael, try"and col2
67402 Apr 2006 @ 02:58 PDTdnoethDatabaseReplyError Using an Alias Name - Is CM a reserved keyword in TeraDataHi Sam,CM is an abbreviation for CREATE MACRO, so it's a keyword.You'll find a list of all keywords in:SQL Reference: FundamentalsAppendix B: Restricted Words for V2R6.1Dieter
67301 Apr 2006 @ 03:06 PSTNW123ToolsReplyFastexport helpHello Barry,Now I am getting the following error: All expressions in a derived table must have an explicit name.SELECT CAST(MAX(CHARACTER_LENGTH(TRIM(X.State_Cd) || '|' ||TRIM(X.Company_Cd) || '|'...
67231 Mar 2006 @ 04:31 PSTNW123ToolsReplyFastexport helpBarry ,I tried with 1,2,3...but still getting the same error:UTY8713 RDBMS failure, 3504: Selected non-aggregate values must be part of theassociated group.Do you think there is a problem with the ...
67131 Mar 2006 @ 04:31 PSTsamit_9999DatabaseTopicError Using an Alias Name - Is CM a reserved keyword in TeraDataHi,When i run the following query , i get an error as 3706:Syntax Error: something expected between ',' and the 'cm' keywordSELECT TBL.BENEFIT_PKG,TBL.SOURCEID,TBL.DESCRIPTION,TBL.PD_CLASS_EFF_DTCM...
67031 Mar 2006 @ 04:04 PSTmike_nguyenDatabaseTopic3706 Syntax error with select statementHi,I'm a newbie in teradata, I'm trying to use the following select statement that works in Oracle db, but it doesn't work in teradata. Would some one help me with the syntax.select * from table_a ...
66931 Mar 2006 @ 03:46 PSTVincent GabrielliToolsTopicTeradata SyntaxCan someone tell me the syntax to round billed mins to the nearest minute?EgFrom ToBilled Mins New Billed Mins--------------- ------------------------6.4 7.0...
66831 Mar 2006 @ 03:24 PSTrlaskarUDAReplyNEED TO CHECK FORMAT TO 'YYYY-MM-DD'Thanks. But it's still not working for me.The column that i have is of type varchar(20) and it have value as "ABCDEFGH".If I ran the above query it returns me all the rows from the table.Say Field ...

Pages