Getting all GDG Base Names using Search Pattern

purusothaman · New User Joined: 17 Feb 2007 Posts: 9 Location: Chennai

Hi all,

I have to perform a search for the GDG bases using the pattern LJ.**.EXAMPLE.

This should return all the GDG base which has the above mentioned pattern. For example LJ.AA.EXAMPLE , LJ.BBBB.EXAMPLE should be the output.

How this can be achieved in background?

Purusothaman.HR

Bill Dennis · Posted: Fri Jun 20, 2008 6:25 pm Post subject:

You use pgm IDCAMS to list catalog entries and parameter GDG to list only those types of entries:

purusothaman · New User Joined: 17 Feb 2007 Posts: 9 Location: Chennai

Thanks for your reply.

In front end when running using REXX Exec:
When I use LISTCAT, my TSO user id gets appended to the pattern. For example LJ.*.EXAMPLE becomes TSOXXXX.LJ.*.EXAMPLE

When running using IDCAMS:
I am getting Memory error and also LJ.**.EXAMPLE does not seem to work.

purusothaman · New User Joined: 17 Feb 2007 Posts: 9 Location: Chennai

Forgot to write the code. Sorry. Here is the code.

Bill Dennis · Posted: Fri Jun 20, 2008 9:20 pm Post subject:

In front end when running using REXX Exec:
enclose the name pattern in single quote 'LJ.*.EXAMPLE' to keep your ID from getting pre-pended

When running using IDCAMS:
use a single asterisk LJ.*.EXAMPLE

What messages indicate a memory error?

purusothaman · New User Joined: 17 Feb 2007 Posts: 9 Location: Chennai

When I use LJ.*.TRADERPT in IDCAMS, I am not able to get the desired GDGs. All the GDGs that I am looking for are like

LJ.XXXX010XX.X010.TRADERPT

So kindly mention how this should be applied. I need to run through IDCAMS since I need the resuls to be routed to a output file.

When I tried LJ.*.TRADERPT, I got the below error.

LISTCAT LEVEL(LJ.*.TRADERPT) GDG
IDC3012I ENTRY LJ.*.TRADERPT. NOT FOUND
IDC3007I ** VSAM CATALOG RETURN-CODE IS 8
IDC1566I ** LJ.*.TRADERPT NOT LISTED

Thanks a bunch for ur help..

purusothaman · New User Joined: 17 Feb 2007 Posts: 9 Location: Chennai

Memory Error that I got earlier:

LISTCAT ENTRIES(LJ.*.TRADERPT) GDG
IDC3332I ** INSUFFICIENT MAIN STORAG
IDC1566I ** LJ.*.TRADERPT NOT LISTED

Pedro

Google 'IBM lookat'.

Search for IDC3332I.

purusothaman · New User Joined: 17 Feb 2007 Posts: 9 Location: Chennai

I tried increasing the REGION size.. But still I am getting the error.

Any idea?

nirmalya sengupta · New User Joined: 28 May 2007 Posts: 3 Location: kolkata

You may use rexx code to run this program. Your id will not be apended if you use "PREF NOPREF". I think that will help you out.

expat · Posted: Mon Jun 23, 2008 9:43 pm Post subject:

SYS1.SAMPLIB (IGGCSIRX) is a good place to look at

purusothaman · New User Joined: 17 Feb 2007 Posts: 9 Location: Chennai

Hi all,

Finally I found a solution for this. Thanks to all the buddies who have helped me.

Here is the code:

dick scherrer

Thank you for posting your solution

d