All forum activity

#DateUserForumTypeThreadPost
66731 Mar 2006 @ 12:37 PSTBarry-1604UDAReplyNEED TO CHECK FORMAT TO 'YYYY-MM-DD'There are two ways to do this that I know of. One is to write a UDF. There is currently a UDF available with the Oracle UDF's called "toDate" that converts a character column to a date. It produ...
66631 Mar 2006 @ 12:27 PSTBarry-1604ToolsReplyFastexport helpYou need to make sure that you're grouping on the columns where you don't have an aggregate function. The easy way to do this is to use the column numbers, rather than repeat the column definition...
66531 Mar 2006 @ 12:16 PSTrlaskarUDATopicNEED TO CHECK FORMAT TO 'YYYY-MM-DD'Hi,I have a column which is of type varchar(20) and which holds date value. Now i need to verify whether the data in the column is having correct date format.Date format should be YYYY-MM-DD.Thanks...
66431 Mar 2006 @ 11:40 PSTNW123ToolsTopicFastexport helpNew to Teradata: any help is appreciated:Thanksgetting the error:22:30:16 UTY8713 RDBMS failure, 3504: Selected non-aggregate values must be part of the associated group.While running the script:...
66331 Mar 2006 @ 11:30 PSTNW123UDATopicFastexport helpNew to TeraData:Any help is appreciated. Thanks in advanceTrying to run a fastexport with an inner and outer select.The inner select has aggregate function SUM.Getting error: 22:30:16 UTY8713 RDBMS...
66231 Mar 2006 @ 11:08 PSTBarry-1604UDAReplyPrimary Key - Create table (select)I don't believe that the syntax allows that, since the PRIMARY KEY specification is done along with specifying the columns of the table. You can specify a UNIQUE PRIMARY INDEX though by doing this...
66131 Mar 2006 @ 11:00 PSTBarry-1604ToolsReplyNumeric overflowWith DECIMAL(18,2), you can only have 16 digits to the left of the decimal. The number you are using has 17 digits to the left of the decimal. That's why you are getting the numeric overflow.Good...
66031 Mar 2006 @ 06:16 PSTTDUser-781ToolsReplyTpump - Is blocking normal?Hi,I've already encountered the problem you are describing here. Some colleagues of mine experienced tpump sessions locking each other.At this moment I don't remember really exactly but if I'm righ...
65931 Mar 2006 @ 04:25 PSTggToolsReplyTpump - Is blocking normal?alternative way to load the data:1. fastload file into empty staging table2. insert select via btequse the same PI for staging and destination table
65830 Mar 2006 @ 08:27 PSTDaveCAnalyticsReplyOracle Function percentile_discMaybe a little late, but how about something like thisSELECT inner1.*, MIN(CASE WHEN inner1.q = 49 THEN day_of_year ELSE NULL END) over() FROM (SELECT calendar_date, day_of_yea...
65730 Mar 2006 @ 06:46 PSTSKowaleskiJobsTopicSr. Data Warehouse Consultant with Project Management, Architect/ModelingOur client has an immediate opening for a Senior Data Warehouse Consultant.This is a four month contract opportunity. We are looking for a Sr. level Data Warehouse Consultant to help finish a proj...
65630 Mar 2006 @ 11:51 PSTJim ChapmanDatabaseReply"wait" operation in a Stored ProcedureI suppose a UDF could be written to perform this function. However, your application might be better served using a queue table. A queue table is a table that can be used as a FIFO event queue. ...
65530 Mar 2006 @ 11:22 PSTJDornDatabaseTopic"wait" operation in a Stored ProcedureI have a simple stored procedure that needs to do periodic polling of a table to determine if it has been refreshed or not, and I'm trying to figure out how to do a "wait" type operation for a spec...
65430 Mar 2006 @ 07:36 PSTAmitToolsTopicNumeric overflowI am running this query SELECT 12345678901234567 (DECIMAL(18,2)) (FORMAT 'ZZ,ZZZ,ZZZ,ZZZ,ZZZ,ZZ9.99')Error comes:Code = 2616: Numeric overflow occurred during computation. If I try to increase the ...
65330 Mar 2006 @ 01:03 PSTdnoethDatabaseReplySyntax error in View definition (nested query)Hi Vasu,are you trying to port SQL from another DBMS to Teradata? Because you didn't run the select before: You can't use scalar subqueries (= subquery within column list) in Teradata, but they can...
65229 Mar 2006 @ 06:05 PSTvasu_yDatabaseTopicSyntax error in View definition (nested query)I am getting a syntax error for the view definition mentioned below. Can anyone tell how to fix this?*** Failure 3706 Syntax error: expected something between '(' and the 'SELE CT' keyword.Statemen...
65129 Mar 2006 @ 02:55 PSTvikas sharmaDatabaseReplyIdentity Column Not Coming in a sequence. Need Suggestion.Hi We too have spent weeks trying to find a sequence eqivalent in Teradata .Apparently there is none. If the requirement is not sequqnce but unique number which should not be repeated in any case t...
65029 Mar 2006 @ 01:16 PSTWitarsaUDATopicPrimary Key - Create table (select)Is it possible to set a PRIMARY KEY when I'm creating a table from a select statement?Ex.:CREATE TABLE TESTAS (SELECT VAR1, VAR2, VAR3 FROM TABLE) WITH DATA;Where VAR1 should be the PRIMARY KE...
64929 Mar 2006 @ 01:08 PSTvikas sharmaDatabaseReplyCurrent Month End DateHiTry this .select add_months((current_date - extract(day from current_date)+1),1)-103/31/2006Vikas
64829 Mar 2006 @ 06:19 PSTGreatSushantToolsReplyCode = 2644 No more room in databasedrop unwanted tables from the database .
64729 Mar 2006 @ 05:25 PSTsan1ToolsReplyFile format mismatchi think u have to check proper format before running the script ..like if ur data file is a normal data file then use DATA file in ur script
64628 Mar 2006 @ 10:40 PSTvai_jConnectivityTopicResponse Limit ExceededOne of our web applications connects to teradata to perform database transactions. It gives the teradata exception ‘Response Limit Exceeded’ when the number of records inserted is more than 7. ...
64528 Mar 2006 @ 08:24 PSTshaik.feroz@aaa-calif.comDatabaseReplyCurrent Month End DateTry thisselect cast(current_date as date) - (extract (day from cast(current_date as date)) - 1) + interval '1' month - 1I am sure there are many more methods. (some of our guru's will provide)The l...
64428 Mar 2006 @ 06:50 PSTKksThird Party SoftwareReplyWIICan you tell a little more about WII
64328 Mar 2006 @ 02:41 PSTrlaskarDatabaseTopicCurrent Month End DateHi All,I was trying to identify current month end date. Let me know any sql syntax toidentify the current month end date.Thanks,rlaskar

Pages