#DateForumTypeThreadPost
12216 Oct 2012 @ 09:14 PDTDatabaseReplysql help: valid indicator for records that are >= 6 monthsDieter, Thank you very much for your help. I tried the logic and it works great.   Quisar Aftab, thanks for looking into this i will work on that too and see how it works. -Feroz. &...
12115 Oct 2012 @ 09:29 PDTDatabaseTopicsql help: valid indicator for records that are >= 6 monthsI have a table that has customerid, and entrytimestamp. (combination of customerid and entrytimestamp is unique). I am trying to mark some records in this table with valid_ind = 1. The first t...
12022 Apr 2010 @ 06:18 PDTDatabaseTopicAlerts for long-running queriesHello, we are (still) using V2R5. can we set up alerts on the system to send an email / page for long-running queries? we did not find anything in the Teradata manager to set alert for long-r...
11921 Jan 2010 @ 06:24 PSTToolsTopicDatastage 8.0 on Z-linuxHello Friends,we are planning to purchase Datastage 8.0 and install on Z-linux.I have a few questions, and I appreciate if some one can provide some info:1) Can we connect to Teradata V2R5 using Da...
11826 Aug 2009 @ 03:02 PDTDatabaseTopicPerformace Issue (CPU time)Hello,We have a V2r5, 4 node system and here is the issue.Assume we have 3 groups (Group A, Group B and Group c) in our company.if Group A complains that the system is running slow,what is the best...
11726 Aug 2009 @ 01:45 PDTDatabaseReplyThoughts on CPUBusy caclulations.I am trying to understand the CPUUExec and CPUUServ
11626 Aug 2009 @ 01:21 PDTDatabaseReplyThoughts on CPUBusy caclulations.Hi Random, Could you please let us know what CPU_USR and CPU_SYS are? Plus -how can I identify which user is using most of the resources (CPU) and which user(s) is/are waiting for the resource...
11511 Sep 2008 @ 02:13 PDTDatabaseReplyrowid in Teradatacan this be done in V2R5?I tried it and it says 3706: syntax error: ROWID not allowed.
11422 Aug 2008 @ 11:57 PDTDatabaseReplyHow to convert minutes to H:M:S formatgot it!select '123' * CAST( INTERVAL '1' SECOND AS INTERVAL hour TO second(0));
11322 Aug 2008 @ 11:46 PDTDatabaseReplyHow to convert minutes to H:M:S formathello,I was trying to do this for seconds and i am running into issues.How can we convert a field that has integer (seconds) into time format hh:mm:ss?i was getting some interval field overflow err...
11213 Feb 2008 @ 04:00 PSTDatabaseReplyTranspose a Table, Using possible nested select statements, Working in SQL-Server But won't work in Teradatadont forget to change the qtrsales to Amount in the coalesce.select year, SUM(case when (quarter = 1 and q.year = year ) then (coalesce(amount,0)) else 0 end ) as Q1, SUM(case when (quarter = 2 and...
11111 Feb 2008 @ 12:22 PSTDatabaseReplyTranspose a Table, Using possible nested select statements, Working in SQL-Server But won't work in TeradataMy bad please ignore my earlier post.
11011 Feb 2008 @ 12:19 PSTDatabaseReplyTranspose a Table, Using possible nested select statements, Working in SQL-Server But won't work in TeradataSELECT YEAR,Q1= ISNULL((SELECT AMOUNT FROM QTRSALES WHERE QUARTER = 1 AND YEAR =Q.YEAR),0),Q2= ISNULL((SELECT AMOUNT FROM QTRSALES WHERE QUARTER = 2 AND YEAR =Q.YEAR),0),Q3= ISNULL((SELECT AMOUNT F...
10930 Jan 2008 @ 07:59 PSTToolsReplyCOMP causing Mload faliurehello satya try thisfor a field that is define in copy book as s9(04)v99 comp-3the layout is as follows (when you do cols and hex)0060070Cand this is defined as decimal(7,2)another exampledecimal(1...
10830 Jan 2008 @ 07:21 PSTDatabaseReplyTeradata and Mainframewhat is it that you are looking for specifically?The only difference in using Mainframe is you create JCL's (which are more like shell scripts) that call the contro members (which are the bteq, Mlo...
10730 Jan 2008 @ 07:12 PSTDatabaseReplyimport from csv to directly teradata tableIf it is a one time thing, you can import from SQL assistant. If this is a task that should be done daily you have to create a MLOAD/FLOAD.assume the table name is TABLEAin the sql assistant click ...
10607 Jan 2008 @ 08:25 PSTDatabaseReplyNeed to convert columns into a rowManish Shekharif each row only has one value populated at any given time (other values are NULL)then you can just group by the application_id and sum the other fieldsapplication_id epx eqi tu1234 0...
10507 Jan 2008 @ 02:21 PSTDatabaseReplyExtracting month from date as 'MMM'Thank you very much JIM.
10404 Jan 2008 @ 07:14 PSTDatabaseReplyExtracting month from date as 'MMM'jim,i tried it and i was still getting the date 01/04/2007has it got anything to do with the database settings or the teradata versionwe are currently using v2r5 and i issues this sql on queryman.T...
10304 Jan 2008 @ 02:40 PSTDatabaseTopicExtracting month from date as 'MMM'How can i extract month from a date in the MMM format.example 01-31-2008 I need to get an output 'JAN'can we do this with out using case statement?Thanks
10211 Dec 2007 @ 11:55 PSTDatabaseReplyhow to get only integer values from character fieldA better way would be to use the user defined function.You do not have to worry about the field size.you can find this function "is_integer"at the following linkhttp://www.teradataforum.com/is_inte...
10107 Dec 2007 @ 12:19 PSTDatabaseTopicHow to get the last update date on a tableHi,could you please provide a query to find when a table was last updated?i have a table that does not have any dates and i need to know from the dbc tables when the last row was added or updated i...
10028 Sep 2007 @ 05:34 PDTDatabaseReplyneed help with this processThanks JimI will try it.
9924 Sep 2007 @ 04:53 PDTDatabaseTopicneed help with this processHi,this is the query i am running which has some stat functions./****************************************************************/DROP TABLE devdata.f_im_incident_audit_log;CREATE TABLE devdata.f_i...
9804 Sep 2007 @ 02:26 PDTDatabaseReplyUnbounded PRECEDING? how to use it in this case.Thanks joe. that was helpful.

Pages