Filtering records based on condtion from VSAM file

Rambhupalchowdary · New User Joined: 19 Aug 2010 Posts: 47 Location: Hyderabad

Hi,

I want to filter the records from VSAM based on condition and write those to either VSAM or Flat file thru JCL. ( Like filtering records using Include Cond in Sort )

Please let us know, your thoughts.

Thanks,
Ram.

expat · Posted: Wed Oct 06, 2010 11:49 am

Once more let us clarify exactly what JCL is.
it is Job Control Language.

By itself it does nothing. It is used to invoke the chosen program and to define which datasets are to be used by the DD names associated with the chosen program.

JCL does not have magical powers that solve all problems, JCL is merely the vehicule for telling the processor which program you want it to execute.

So if you might be so informative to suggest which program you would like your JCL to be executing then perhaps we might be better positioned to assist.

Rambhupalchowdary · New User Joined: 19 Aug 2010 Posts: 47 Location: Hyderabad

Hi Expat,

Till now i have used IDCAMS, to process VSAM files.
It would be better, if you please provide any solution for my query by using IDCAMS.

Appreciate any other solutions by using any other programs.

Thanks,
Ram.

expat · Posted: Wed Oct 06, 2010 12:05 pm

Search the forum for solutions using either DFSORT or SYNCSORT - depending on the product and release level you have installed.

Also, it might be a good idea to supply some useful information
Record length is fixed or variable.
The actual record length (Give both average and maximum if variable)
The position and format of the "filter" field(s)
The rules for including / omitting records

Rambhupalchowdary · New User Joined: 19 Aug 2010 Posts: 47 Location: Hyderabad

Hi Expat,

Please find below details.

Record length is fixed or variable = Variable
The actual record length (Give both average and maximum if variable) =
RECORDSIZE(31773,32710)
The position and format of the "filter" field(s) = from 5th position 4 bytes
The rules for including / omitting records = include only records have 'aaaa' from 5th position.

Please let me know if you require any further info.

Thanks,
Ram.

expat · Posted: Wed Oct 06, 2010 1:48 pm

Are you using SYNCSORT or DFSORT

Please run the code below and post the output from SYSOUT

enrico-sorichetti · Posted: Wed Oct 06, 2010 1:55 pm

if You had cared to search the jcl/dfsort forums with sort include
You would have found lots of examples
here is one of them
ibmmainframes.com/viewtopic.php?t=51341&highlight=sort+include
or
ibmmainframes.com/viewtopic.php?t=49018&highlight=
start doing a bit of work Yourself

it would be also useful for you to read and meditate on
How To Ask Questions The Smart Way
catb.org/~esr/faqs/smart-questions.html
to make the most out of the questions You ask

Rambhupalchowdary · New User Joined: 19 Aug 2010 Posts: 47 Location: Hyderabad

Hi Expat/enrico-sorichetti,

We have DFSORT in our shop.

Sorry for the confusion, earlier i had an opinion like we should not copy VSAM to flat file using DFSORT and we should do it using only IDCAMS. Now i did it successfully using DFSORT.

Thanks for your help.

Now my query is how to create VSAM file using DFSORT ? Also please let me know how to view whether the VSAM is VB or FB ?

Thanks,
Ram.

enrico-sorichetti · Posted: Wed Oct 06, 2010 3:18 pm

You do not create VSAM files with dfsort

You can create them
by JCL
by IDCAMS define

my advice is to use IDCAMS define

after that You can load data into it using idcams repro or sort

Rambhupalchowdary · New User Joined: 19 Aug 2010 Posts: 47 Location: Hyderabad

Thanks enrico-sorichetti for your valuable inputs,

If we need to filter few records based on condition from VSAM file and wants to copy those to another VSAM file; Do we have any other solution other than below mentioned ?

step1:- Copy records from VSAM to Flat file based on certian cond using DFSORT.

Step2:- convert the Flat file to VSAM using IDCAMS.

Is there any other solution we can achieve above in single step?

Thanks in advance.
Ram.

expat · Posted: Wed Oct 06, 2010 3:42 pm

Define new VSAM cluster
Sort from existing to new VSAM cluster

enrico-sorichetti · Posted: Wed Oct 06, 2010 3:42 pm

sort can read and write VSAM files

step1 IDCAMS delete/define
step2 sort with vsam input and output

to have an absolute one step only solution then the vsam define should be done with jcl allocation/implicit definition
but that' s an approach I would not advice for, since it needs a very sound SMS environment

Rambhupalchowdary · New User Joined: 19 Aug 2010 Posts: 47 Location: Hyderabad

Thanks a lot for all ur inputs..