Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help with Fileaid!!!!!!

Status
Not open for further replies.

mutual33

Programmer
Jul 3, 2002
5
US
I need to select all records from file that have a string,for example 'jj'.This string can be located anywhere in record. File format is variable.It must be done in batch. I tried FileAid(batch) using CO relational operand but was not succesful(got message-something wrong with control card). Is anybody know how control card looks like ? Is there any other way to this task witout writing program ? Please help....
My control card looks like this

$$dd01 copy if=(1,co,c'jj')


 
Mutual,
I'll reply to this later as I've found the manuals!
Marc
 
Mutual,
The manual I have managed to find is a reference summary of file aid and although it mentions batch, it's not very thorough. The operands it mentions are: EQ, NE, NO(binary Bits are not all ones), MX (Binary Bits are mixed - ones and zeroes), GT, GE, LE and LT. It doesn't mention CO. I have found a reference to CO in a file aid Data Ager manual which is used in creating test data, which may be where you got it from. Certainly from the manual that I have (release 8.0.2) CO does not appear to be an option. I'd be surprised if you can't do it, and I'd try messing about with the location (ie the position) putting in 0 or similar.

As an alternative to file aid, I believe that Selcopy is widely used and can do this, being able to specify a position of ANY. If all else fails and you don't want to write a program, you could knock up a REXX exec to do this.

Sorry to not be able to give a proper answer, especially when I managed to find some documentation, but hope this helps anyway.

Marc
 
The only other thought I had is if your max length was, say 250, then issue the statement:

$$dd01 copy if=(1,250,eq,c'jj')

but I have a feeling this won't work
 
Hi Mutual,

Idon't recall the full stmt syntax, but I'm sure of the IF stmt. It s/b:

if=(1,0,c'jj')

The 0 being a zero.

I'll try to follow up when I get into work on Monday. I just did this a few days ago, and I've forgotten everthing but the IF.

A bit of advice - don't ever get old. :) But then, again consider the alternative.

Regards, Jack.
 
Thank you guys all for trying to help.I created control card thru File aid online.When you submit it online you can type JCL commmand on command line and it will show you all jcl with control card.That easy!!!Control card was really wacky(like everything created by utilities) but it works.

Thank you again,I really appreciate this.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top