View previous topic :: View next topic |
Author |
Message |
mf_user Intermediate

Joined: 01 Jun 2003 Posts: 372 Topics: 105
|
Posted: Fri Feb 03, 2006 3:22 am Post subject: Executing the Find command in batch mode. |
|
|
Hi,
How to execute the "Find" command in batch mode using the IKJEFT01. Can anybody pls send me the JCL?
Is it possible to execute "FAND" & "FOR" commands in batch mode too?
Thanks in advance. _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
Back to top |
|
 |
superk Advanced

Joined: 19 Dec 2002 Posts: 684 Topics: 5
|
Posted: Fri Feb 03, 2006 10:45 am Post subject: |
|
|
What "FIND" command? The ISPF EDIT Find? The TSO EDIT Find? SUPERC? And, more importantly, what do you need to do with the results of the FIND command? |
|
Back to top |
|
 |
mf_user Intermediate

Joined: 01 Jun 2003 Posts: 372 Topics: 105
|
Posted: Mon Feb 06, 2006 7:21 am Post subject: |
|
|
It is TSO Edit. I have got certain data into a PS file by using SARBCH utility. Now, I want to find certain string in the PS file (out of 1000000) records and copy thos lines into a separate PS file (in batch mode). I will download this file as a text file and prepare my xl sheet for further reporting.
Thanks. _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
Back to top |
|
 |
semigeezer Supermod
Joined: 03 Jan 2003 Posts: 1014 Topics: 13 Location: Atlantis
|
Posted: Mon Feb 06, 2006 9:22 am Post subject: |
|
|
I doubt anyone uses TSO edit anymore (I certainly hope not), and it may be possible to do this with TSO edit but I don't know. 1 Million lines is too large to place in ISPF edit. It is probably easiest to write a small Rexx program to do this (probably about 20 lines) or a small COBOL program to do it (probably about 37 Million lines ). Either way it should be a small programming effort. You could also call ISRSUPC (SuperC) or SORT depending on things like the length of the records, the variability of the data formats, etc.
Or you could put the file to an HFS location and use grep which does this type of search directly. I'd prefer the grep solution since the whole thing is about 4 lines of code (roughly: oput mvssource hfsinput..., grep "string" hfsinput>outputfile, oget outputfile, oshell rm hfsinput outputfile) maybe less if you can use grep on an MVS data set (I haven't checked, but it is worth looking up). |
|
Back to top |
|
 |
mf_user Intermediate

Joined: 01 Jun 2003 Posts: 372 Topics: 105
|
Posted: Mon Feb 06, 2006 9:35 pm Post subject: |
|
|
Hi semigeezer,
I will try to get the GREP thing.
Thanks for the help. _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
Back to top |
|
 |
|
|