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

selecting a set of values from a dataset


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Wed Apr 04, 2007 8:48 pm
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
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

Global Moderator


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

PostPosted: Wed Apr 04, 2007 9:06 pm
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
Reply with quote

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

Global Moderator


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

PostPosted: Wed Apr 04, 2007 9:14 pm
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 All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts count contained values of several col... DB2 4
No new posts REXX to get all Dataset names from a ... CLIST & REXX 5
No new posts Avoid job abend on dataset held by us... JCL & VSAM 6
No new posts Identify Number of Multivolume Dataset All Other Mainframe Topics 5
No new posts batch SFTP job using AOPBATCH unable ... All Other Mainframe Topics 7
Search our Forums:


Back to Top