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
 

 

selecting a set of values from a dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
ganeshj

New User


Joined: 20 Dec 2006
Posts: 6
Location: Bangalore

PostPosted: Wed Apr 04, 2007 8:42 pm    Post subject: selecting a set of values from a dataset
Reply with quote

Hi Group,
Let us consider a dataset has lots of DUMP values as example below,

DNFH3553I Command 'QUERY' ignored; ltname 'ANZBAU20A' not active.
query -lt ANZBAU30A
DNFF4450I State of LT 'ANZBAU30A' at 'Apr 4, 2007 11:45:29 AM'
FSM started at 'Apr 2, 2007 3:19:14 PM' on queue manager 'MQC1'
using LT connection number: '01' with SAG: 'SAGC1'
Current states: AL: SELECTED SL: OPEN
DNFH3553I Command 'QUERY' ignored; ltname 'ANZBAU20A' not active.
query -lt ANZBAU30A
DNFF4450I State of LT 'ANZBxxxxx' at 'Apr 4, 2007 11:45:29 AM'
FSM started at 'Apr 2, 2007 3:19:14 PM' on queue manager 'MQC1'
using LT connection number: '01' with SAG: 'SAGxx'
Current states: AL: REJECTED SL: OPEN
-----
----
Like this the dataset continues,

1)
I want to select the value ANZBAU30A , ANZBxxxxx which will be in the same line starting from 24th position to 32nd position which starts with the value DNFF4450I .

2)
I want to select 'SAGC1' and 'SAGxx' which will be next to the common value SAG:

3)
I want to select SELECTED , REJECTED from the variable near to AL:

4)
I need to put in to a new data set as

ANZBAU30A SAGC1 SELECTED
ANZBxxxxx SAGxx REJECTED

Please let me know is there any way to get it in this manner.
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: Wed Apr 04, 2007 8:48 pm    Post subject:
Reply with quote

Hello,

Is there some reason you want to do this with a Compuware solution?

It would not be very difficult to write a program to do this.
Back to top
View user's profile Send private message
ganeshj

New User


Joined: 20 Dec 2006
Posts: 6
Location: Bangalore

PostPosted: Wed Apr 04, 2007 9:05 pm    Post subject: Re: selecting a set of values from a dataset
Reply with quote

No i need the solution in Fileaid or in ice tool,
I had submitted there but how i got it here i'm not sure.
Now how i can post the same in the fileaid topic??
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Wed Apr 04, 2007 9:06 pm    Post subject: Re: selecting a set of values from a dataset
Reply with quote

This IS the FileAid Forum.
Back to top
View user's profile Send private message
ganeshj

New User


Joined: 20 Dec 2006
Posts: 6
Location: Bangalore

PostPosted: Wed Apr 04, 2007 9:09 pm    Post subject: Re: selecting a set of values from a dataset
Reply with quote

which will be a better solution for solving this problem?
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Wed Apr 04, 2007 9:14 pm    Post subject: Re: selecting a set of values from a dataset
Reply with quote

Well, it seems to me that if you have the tools available, that you'd have a much better idea of where to start than the rest of us. Anyway, let the Forum members decide. If, after a reasonable period of time, you don't get a workable response, then contact one of the Forum moderators and we'd be more than happy to move the entire post to another forum.

Don't keep reposting the same topic.
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 Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 5 Fri Mar 24, 2017 2:24 pm
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts Replacing same string with different ... vickey_dw DFSORT/ICETOOL 6 Wed Feb 22, 2017 10:44 pm


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