MVSFORUMS.com

Thanks Kolusu.

Sorry for bothering you for this simple one. I bought a book on vsam by Jay Ranade and it was over in half an hour.

Is it possible to write an optimum cobol batch program for deleting records from a ksds vsam file? Environment is MVS(S390).
I have
1)a huge ksds indexed master file(Around 4000000 records).key is ...

Hi Guys,

I am done with it. The problem was with migrated indexes.

I got a jcl from sys admin which recalled all index related datasets.

Now its running in a flash of a sec.

Jcl is given
...

Hi Kolusu,

Thank you for your prompt response Kolusu..

I tried it earlier.

It was not helping....

Hi,
I am running DB2 on MVS os.
I have a simple query like this

SELECT COUNT(DISTINCT(CLIENT_ID))
INTO :WS-COUNT
FROM U_BAS_V

There are around 250 tabl ...

Thanks guys for the responses.
We had to go for a work around. The input we had to change had only 500 records. So we downloaded the file and the used an ordinary word editor with macros and then upl ...

Guys,

Thanks for the responses

Kolusu,

we dont have DFSORT/ICETOOL ,only ordinary sort I think Syncsort. Is there any way in it??

Premkumar,

I ran your jcl.it was showing invalid LRECL, ...

My sequential file is as follows

01CP19841231
TRK=99999999REL=DCLS=NDED=NFLT=NTER=NCOM=NAGE=N PP
T=99999999REL=NDED=NR45=NAGE=N ...

Hi Guys,

Thanks for all the responses.

Both are input files only and not an output file. Sorry to confuse you.

I will check what can be done regarding checking the Buffers for the 2 input fil ...

Sunil,

How long is this program running?? Are you writting these files to a tape or to a dasd file?? If you are writting it to a tape then check the file section and make sure that you have B ...

I am on an MVS mainframe system(OS 390).We have two sequential files which needs to be compared.One containing ratefile F1(which contains 20,00000 records) and an output file F2 (which contains around ...