Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Easytreive : Logic needed

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
ESSPRABHU

New User


Joined: 11 Oct 2005
Posts: 22

PostPosted: Wed Dec 26, 2007 5:34 pm    Post subject: Easytreive : Logic needed
Reply with quote

HI,

Can any of you please tell the coding logic in EASYTRIEVE for the below SQL query.

SELECT DEPT NAME MAX(SAL)
FROM PRSNL-FILE
GROUP BY DEPT


ie. while creating a report, using Easytreive, with fields ( DEPT NAME SAL ) I have to calculate the max salary of each department.

Let me know if you need any further details.

Thanks in advace,

Prabhu.
Back to top
View user's profile Send private message

socker_dad

Active User


Joined: 05 Dec 2006
Posts: 147
Location: Columbia, MO

PostPosted: Wed Dec 26, 2007 9:56 pm    Post subject: Reply to: Easytreive : Logic needed
Reply with quote

Yawn.


Yet another homework assignment?

You have already answered your own question. The DB2 query will retireve the max salary for each department. All you have to do now is format the report.

-----------------

Whay don't you students get study buddies?
Back to top
View user's profile Send private message
ESSPRABHU

New User


Joined: 11 Oct 2005
Posts: 22

PostPosted: Thu Dec 27, 2007 9:55 pm    Post subject: Easytreive : Logic needed
Reply with quote

Hellow,

Instead of giving my requirement in words , I have given it in the form of SQL query.
We are not using DB2. I have to do that type of (finding max value) calculation using Easytreive. that's why I have asked Easytrieve logic.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Dec 28, 2007 2:44 pm    Post subject:
Reply with quote

Does EASYTRIVE not have inbuilt functions such as MAX, MIN, MEAN ?
Back to top
View user's profile Send private message
socker_dad

Active User


Joined: 05 Dec 2006
Posts: 147
Location: Columbia, MO

PostPosted: Mon Dec 31, 2007 10:23 pm    Post subject: Re: Easytreive : Logic needed
Reply with quote

ESSPRABHU wrote:
Hellow,

Instead of giving my requirement in words , I have given it in the form of SQL query.
We are not using DB2. I have to do that type of (finding max value) calculation using Easytreive. that's why I have asked Easytrieve logic.



Did you try reading your Easytrieve manual? I found the answer rather easily (no pun intended).

-----------------------------------------------------------------------

Since you are trying to steal my job, at least earn it. Don't expect me to hand it to you on a silver platter.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Wildcard logic in COBOL dudenithy COBOL Programming 13 Thu Sep 01, 2016 7:36 pm
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts Sort Logic to extract data scorp_rahul23 DFSORT/ICETOOL 13 Tue Mar 01, 2016 1:22 am
No new posts Need a logic to validate the data in ... sandeep kumar302 COBOL Programming 17 Mon Feb 01, 2016 3:30 pm
No new posts Tricky sort logic required pgopi92 DFSORT/ICETOOL 3 Mon Jan 25, 2016 3:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us