MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Concatenate unknown number of files with the same HLQ

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Thu Sep 27, 2007 12:59 pm    Post subject: Concatenate unknown number of files with the same HLQ Reply with quote

I have searched so don't bury if my searches didn't turn up what I need. Embarassed

I need a way to grab all files with the same high level qualifier and concatinate them into 1 dataset. The number of files is unknown. The record length is fixed all records same size. My choices for tools are IBM utility or Synsort.

I would apperciate any help.
_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
CICS Guy
Intermediate


Joined: 30 Apr 2007
Posts: 292
Topics: 3

PostPosted: Thu Sep 27, 2007 1:48 pm    Post subject: Reply with quote

Up to the concatination limit, just concatinate them....
Back to top
View user's profile Send private message
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Thu Sep 27, 2007 2:01 pm    Post subject: Reply with quote

CICS Guy, thanks for your reply! I like your reply it sounds easy, but I'm unclear how or what concatination limit your taking about. Embarassed

Do you have an example?
_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
CICS Guy
Intermediate


Joined: 30 Apr 2007
Posts: 292
Topics: 3

PostPosted: Thu Sep 27, 2007 5:39 pm    Post subject: Reply with quote

I'm sure there is a (JCL?) manual that specifies the max number of datasets that can be concatenated....
Back to top
View user's profile Send private message
semigeezer
Supermod


Joined: 03 Jan 2003
Posts: 1014
Topics: 13
Location: Atlantis

PostPosted: Thu Sep 27, 2007 6:21 pm    Post subject: Reply with quote

Hopefully whatever person asked you to do this is not really concerned with how it gets done because neither of those solutions will work for a large number of data sets.

Since there are limits on concatenation and on the # of steps in a job, I'd suggest that you write a small program to get the data set names, allocate the target with disp=mod and copy each data set's contents to the output data set. This should probably be about 20 lines in Rexx, including error checking. Find the data set names with LMDLIST, do the allocation with LMINIT (and LMFREE) and do the copying with LMCOPY. Examples of all of these abound on the web. One thing to note is you may need to do an LMINIT/LMFREE on the target data set for each copy rather than doing it just once (due to an ISPF limitation).
Back to top
View user's profile Send private message Visit poster's website
vkphani
Intermediate


Joined: 05 Sep 2003
Posts: 483
Topics: 48

PostPosted: Fri Sep 28, 2007 1:27 am    Post subject: Reply with quote

NASCAR9,

Get all the file names by goving your high level qualifier and then concatenate them in the job.
Back to top
View user's profile Send private message Send e-mail
videlord
Beginner


Joined: 09 Dec 2004
Posts: 147
Topics: 19

PostPosted: Fri Sep 28, 2007 4:18 am    Post subject: Reply with quote

1. ISPF 3.4, list the data set whtat you want
SAVE command, save to a data set A
(or you can use LISTDS)
2. EDIT data set, to be your JCL DD card
(DFSORT or IEB* utility can be used)

It can be done in batch mode too, or you can code a simple REXX routine
Back to top
View user's profile Send private message
hchinnam
Beginner


Joined: 04 Feb 2005
Posts: 31
Topics: 10

PostPosted: Fri Sep 28, 2007 5:52 am    Post subject: Reply with quote

There is a utility which does something similar to what you are asking.

We were using it for taking the BKUP. It takes the wild card as input and copies all the datasets into a single output.

(i.e you can copy HLQ.* to some dataset name)

BUT

It will be a solution if your requirement is only to take BKUP.
Reason being it stores the data in it's own format. And you need to
execute the same program again to retrieve any of the data.

If you are interested in using this, the name goes some thing like ADDR**
(some address utility).
Back to top
View user's profile Send private message
vkphani
Intermediate


Joined: 05 Sep 2003
Posts: 483
Topics: 48

PostPosted: Fri Sep 28, 2007 6:04 am    Post subject: Reply with quote

It is ADRDSSU. You can check the below link for example.
ADRDSSU Documentation
Back to top
View user's profile Send private message Send e-mail
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Fri Sep 28, 2007 10:10 am    Post subject: Reply with quote

Thank you all for your responses! Very Happy I will investigate all options.
_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Fri Sep 28, 2007 11:48 am    Post subject: Reply with quote

I would like to add some clarification to my post. I'm not doing a backup.
The files I'm processing are for an outside vendor who will FTP files with a HLQ of PRXSOL.*
This is the only part of the file name I can require.
We created a REXX program. It seems to work ok, just maybe a little more tweaking.
I will post it when were done.
_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
NASCAR9
Intermediate


Joined: 08 Oct 2004
Posts: 274
Topics: 52
Location: California

PostPosted: Tue Nov 13, 2007 1:33 pm    Post subject: Reply with quote

An update to this post. The requirments have changed and now we will be Pulling the files, not having them pushed to us. The lan support group will be responsible for this activity. They will create a single file that will be FTP'ed to the mainframe and processed.
Thanks Again! Very Happy
_________________
Thanks,
NASCAR9
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group