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

How to apply group by and max condition is a file data


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
jemonthomas

New User


Joined: 24 Jul 2006
Posts: 35
Location: india

PostPosted: Mon Mar 30, 2009 4:56 pm
Reply with quote

I need to filter a file data by using a groupby and max of one column condition.As we filter from a table Is this possible thru jcl???
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Mon Mar 30, 2009 6:46 pm
Reply with quote

Hi,

'Am not sure what is beiong asked here? Are you saying that can we execute DB-2 queries in batch thorigh JCL instead of QMF/SPUFI?
Back to top
View user's profile Send private message
jemonthomas

New User


Joined: 24 Jul 2006
Posts: 35
Location: india

PostPosted: Mon Mar 30, 2009 8:09 pm
Reply with quote

yes
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Mar 30, 2009 8:27 pm
Reply with quote

what utility or application are you executing with your job (which is made up of JCL)?
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Mon Mar 30, 2009 9:51 pm
Reply with quote

Hi,

May be you are looking something like this: www.ibmmainframes.com/viewtopic.php?t=27071&highlight=ikjeft01
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 7
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