122 | 16 Oct 2012 @ 09:14 PDT | Database | Reply | sql help: valid indicator for records that are >= 6 months | Dieter,
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.
&... |
121 | 15 Oct 2012 @ 09:29 PDT | Database | Topic | sql help: valid indicator for records that are >= 6 months | I 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... |
120 | 22 Apr 2010 @ 06:18 PDT | Database | Topic | Alerts for long-running queries | Hello,
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... |
119 | 21 Jan 2010 @ 06:24 PST | Tools | Topic | Datastage 8.0 on Z-linux | Hello 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... |
118 | 26 Aug 2009 @ 03:02 PDT | Database | Topic | Performace 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... |
117 | 26 Aug 2009 @ 01:45 PDT | Database | Reply | Thoughts on CPUBusy caclulations. | I am trying to understand the CPUUExec and CPUUServ |
116 | 26 Aug 2009 @ 01:21 PDT | Database | Reply | Thoughts 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... |
115 | 11 Sep 2008 @ 02:13 PDT | Database | Reply | rowid in Teradata | can this be done in V2R5?I tried it and it says 3706: syntax error: ROWID not allowed. |
114 | 22 Aug 2008 @ 11:57 PDT | Database | Reply | How to convert minutes to H:M:S format | got it!select '123' * CAST( INTERVAL '1' SECOND AS INTERVAL hour TO second(0)); |
113 | 22 Aug 2008 @ 11:46 PDT | Database | Reply | How to convert minutes to H:M:S format | hello,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... |
112 | 13 Feb 2008 @ 04:00 PST | Database | Reply | Transpose a Table, Using possible nested select statements, Working in SQL-Server But won't work in Teradata | dont 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... |
111 | 11 Feb 2008 @ 12:22 PST | Database | Reply | Transpose a Table, Using possible nested select statements, Working in SQL-Server But won't work in Teradata | My bad please ignore my earlier post. |
110 | 11 Feb 2008 @ 12:19 PST | Database | Reply | Transpose a Table, Using possible nested select statements, Working in SQL-Server But won't work in Teradata | SELECT 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... |
109 | 30 Jan 2008 @ 07:59 PST | Tools | Reply | COMP causing Mload faliure | hello 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... |
108 | 30 Jan 2008 @ 07:21 PST | Database | Reply | Teradata and Mainframe | what 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... |
107 | 30 Jan 2008 @ 07:12 PST | Database | Reply | import from csv to directly teradata table | If 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 ... |
106 | 07 Jan 2008 @ 08:25 PST | Database | Reply | Need to convert columns into a row | Manish 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... |
105 | 07 Jan 2008 @ 02:21 PST | Database | Reply | Extracting month from date as 'MMM' | Thank you very much JIM. |
104 | 04 Jan 2008 @ 07:14 PST | Database | Reply | Extracting 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... |
103 | 04 Jan 2008 @ 02:40 PST | Database | Topic | Extracting 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 |
102 | 11 Dec 2007 @ 11:55 PST | Database | Reply | how to get only integer values from character field | A 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... |
101 | 07 Dec 2007 @ 12:19 PST | Database | Topic | How to get the last update date on a table | Hi,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... |
100 | 28 Sep 2007 @ 05:34 PDT | Database | Reply | need help with this process | Thanks JimI will try it. |
99 | 24 Sep 2007 @ 04:53 PDT | Database | Topic | need help with this process | Hi,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... |
98 | 04 Sep 2007 @ 02:26 PDT | Database | Reply | Unbounded PRECEDING? how to use it in this case. | Thanks joe. that was helpful. |