IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Aggregate functions in File-AID for DB2.


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pradeean

New User


Joined: 08 Jan 2013
Posts: 6
Location: india

PostPosted: Fri Jun 14, 2013 1:33 pm
Reply with quote

Hi,

I am using 'File-AID for DB2 tool' for Browsing/Editing my tables. I can able to retrive data using RELATIONAL/LOGICAL Connectors functions like 'IN, BETWEEN,LIKE,>,< in WHERE Phrase. But i am unable to extract data by using aggregate functions like SUM,MAX,MIN,COUNT etc..in 'BROWSE Selection Template' or 'EDIT Selection Template'. Is there any way to use aggregate functions in File-AID DB2? Please suggest me on this. Thanks.

-Pradip.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Fri Jun 14, 2013 2:30 pm
Reply with quote

- One way is to allocate an SQL dataset and use the 'SQL' command to edit the SELECT sql in whichever way you want in BROWSE mode. But it may not always make sense to 'EDIT' rows which are already processed by an aggregate function.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Jun 14, 2013 4:44 pm
Reply with quote

What did the manual tell you?
Back to top
View user's profile Send private message
pradeean

New User


Joined: 08 Jan 2013
Posts: 6
Location: india

PostPosted: Fri Jun 14, 2013 5:42 pm
Reply with quote

@Robert,

The manual not describing about the aggregate functions. I would like to know the way to use these functions in selection template if any. Note: The manual says that "For all other WHERE clauses, you must enter the CAST function manually. " after describing logical and relational functions.

@Arun Raj,
Thanks for your reply. As you said i can modify the query in dataset member. But i would like to know the is there any chance to use the aggregate functions in selection template itself.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jun 14, 2013 7:10 pm
Reply with quote

Hello,

If it is not in the manual, probably not.

Suggest you ask File-Aid Support.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Jun 14, 2013 8:50 pm
Reply with quote

Manuals tend to describe what CAN be done. They tend not to define what CANNOT be done otherwise they would be rather large and repeat a lot of stuff that cannot be done - e.g. I know of no software that can wash the dishes in the kitchen sink but you would not expect any software manual to mention that the software cannot do it.
Back to top
View user's profile Send private message
pradeean

New User


Joined: 08 Jan 2013
Posts: 6
Location: india

PostPosted: Sat Jun 15, 2013 9:35 am
Reply with quote

Hi All,

Thanks for your suggestion. Till now I am following the process as Arun Raj says and I will try other options if any.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top