#DateForumTypeThreadPost
3819 Oct 2009 @ 05:21 PDTDatabaseTopicStoring GMT offset in minutes with signHi,I am trying to make a table which should be to store GMT offset time along with the Sign for a city. For example City ...
3708 Jun 2009 @ 10:51 PDTDatabaseReplyQuery to find out the table name and the columns of that table associated with a viewHi Latha,I think your solution will not work and what Gorge has said is the way to go.The DBC.Tables.RequestText will give you the DDL used to create View or Table but to extract exact "View name" ...
3613 May 2009 @ 02:53 PDTToolsReplyImproving Loading Mechanism using FastloadHi Dieter/Standalone,I have been following this thread and really appreciates the knowledge being shared.I have one question related to the fastload log being posted we have statement axsmod np_axs...
3519 Apr 2009 @ 08:12 PDTUDAReplyGetting the date before the max dateSEL *FROM Your_database.Your_TableQUALIFY ROW_NUMBER() OVER(PARTITION BY Primary_key_columns ORDER BY date_column DESC ) =2;if you expect multiple records for the "one less than maximum date" then ...
3416 Apr 2009 @ 12:36 PDTUDAReplyNo Rows foundHi,you can useselect * from mydatabase.mytable sample 1;.if activitycount >0 then goto .continue_label.exit 8;cheers,Novice
3309 Apr 2009 @ 12:15 PDTUDAReplydetermining order from a list without using date fieldi think the below query will solve your purpose sel sum(case when movement_type ='+' then movement_quantityelse -movement_quantityend ) ,clientid from group by 2 order by 2 asc;
3208 Apr 2009 @ 10:45 PDTUDAReplydetermining order from a list without using date fieldChris, I have one question.You mentioned the opening and closing balances between entries will always match up (i.e. The closing balance for an entry will ALWAYS equal the opening balance of the n...
3106 Apr 2009 @ 09:57 PDTDatabaseReplyQuery if table existsSELECT * FROM DBC.TABLES WHERE TABLENAME ='TABLENAME' ;will tell you if the table exist or not .If you want to create a conditional statement then you can write DDL for the table and then execute ...
3001 Apr 2009 @ 09:43 PDTDatabaseReplyLoading changed dataHi,Alternatively the same thing can be achieved by below four steps. it doesnot use any updates but use 3 temp tables. it will be faster if the index of intermediate tables are chosen wisely.Step 1...
2918 Mar 2009 @ 12:47 PDTDatabaseReplybahaviour of primary index with two columnsopt2. HT.PI consists of bt_id only will be best for your case.When Two tables are joined on a column,which is primary index of each of the joined table then there is no need to Redistribute / copy ...
2810 Mar 2009 @ 09:53 PDTDatabaseReplypartition By column contains "NULL"Thanks Dieter,The moment i posted the question i was sure of this answer. it will help if we get to know how a RDBMS make sure a NULL when aggregated should be considered as equal but in comparison...
2710 Mar 2009 @ 01:01 PDTDatabaseTopicpartition By column contains "NULL"Hi All,When one of the partition By columns have Nulls will it lead to a new partition. For e.g.Col#1 Col#2 Col#3 Col#4(date)1 2 null 12-05-20081 2 null 11-07-20...
2626 Feb 2009 @ 08:47 PSTUDAReplyDate of birth MMDDYYYY text convert to date format and get ageTo account for the leap year, we could divide by 365.25 to get a more precise number of years.Calculate age as select (Current_Date - DOB )/365.25 from table;cheers...
2525 Feb 2009 @ 12:51 PSTToolsReplyAvoid header and trailer using MultiloadHi Kiran,While defining the layout of records put a field REC_ID_IN( Record Id indicator). this will store the record indicator for each row. you can filter the Header and trailer records in the ap...
2424 Feb 2009 @ 06:20 PSTDatabaseReplyNeed help with writing Querie..Hi Trubert,with the above dates we will not be able to answer the question " what was john's salary for 2005.06.05?". Since this date is not covered in any row. Do you want the data to be Start_Dat...
2323 Feb 2009 @ 07:47 PSTDatabaseReplyProblem with a Tera Data QueryHi skt,Here is what i understand of the problem. You have three tables each having one common column(rat_en) and there are count in another column i.e. sub_count. Now we need to show the max(sub_co...
2222 Feb 2009 @ 08:10 PSTDatabaseReplyProblem with a Tera Data QueryHi,I think the below query solves your problemSELECT A.RAT_EN,MAX(A.sub_count),MAX(B.sub_count),MAX(C.sub_count)FROMUP_AALZEER.PS_V_SUB_AGE A,UP_AALZEER.PS_V_SUB_AGE B,UP_AALZEER.PS_V_SUB_AGE CWHER...
2120 Feb 2009 @ 01:54 PSTAnalyticsReplyReporting DataHi,I tried the below query and it worked create volatile table abc1(emp integer,loc integer,work_ot integer,rate_ot integer,amt_ot integer,work_nt integer,rate_nt integer,amt_nt integer,work_no int...
2019 Feb 2009 @ 01:34 PSTAnalyticsReplyProblem in finding the latest recordHi Arun,In the first query you are not calculating Max(A.INSERT_TS) over CODE,KEYFLD columns. Teradata should know on what level of granularity should max(Insert_Ts) be calculated?
1916 Feb 2009 @ 06:51 PSTDatabaseReplyUSI in multiloadthanks Dieter..
1815 Feb 2009 @ 12:59 PSTAnalyticsReplyFinding the number of records in a derived tablesHi Arun,i would be better if you can provide us the query. But you can create volatile table and populate it with derived query result. Bteq Activitycount variable can be used to determine the numb...
1712 Feb 2009 @ 08:10 PSTDatabaseReplyUSI in multiloadDieter,the answer was great but i cannot understand the statement " One Amp will insert the row while other Amp will delete it".We would appreciate if you can explain a bit more about it...Cheers,N...
1612 Feb 2009 @ 02:45 PSTDatabaseReplyimport dataNeeraj,The data you posted has first row booking_date as '5/13/2006' make sure all the dates are in format 'MM/DD/YYYY'.So the first row should have '05/13/2006'.Once that is done change the follwi...
1511 Feb 2009 @ 06:50 PSTDatabaseReplyimport dataAt which record is import failing. I mean is import failing at record#1 of .csv file?can you send me us few records of your .CSV file ?
1410 Feb 2009 @ 08:30 PSTToolsReplyProblem with Multiload AcceptHi,I was thinking as why to export the date first and then subsequently read it from file as parameter Can't this be done is one step like DELETE FROM TABLE B WHERE CURRENT_DATE<(sel end_date -1...

Pages