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
 

 

Aggregate functions in File-AID for DB2.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
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    Post subject: Aggregate functions in File-AID for DB2.
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: 2161
Location: @my desk

PostPosted: Fri Jun 14, 2013 2:30 pm    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Fri Jun 14, 2013 4:44 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Fri Jun 14, 2013 7:10 pm    Post subject:
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: 1715
Location: UK

PostPosted: Fri Jun 14, 2013 8:50 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


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