MVSFORUMS.com

In my requirement table A is refreshed daily. Please suggest if weekly REORG is still sufficient.

I can have 40,000 records in table A. As of know with index created and reorg executed on the tab ...

Hi,

Do i need to bind the program everytime when reorg is executed on a table that is used in the program.

In development region i have to bind the program whenever reorg is executed. Is this th ...

Hi,
I have a requirement to read all the records from database A and for each record read i have to look for a match based on some key and the date conditions in the same database A and some other da ...

Hi,

I have a file which is sorted on 1 to 7 charecters. This file has header positioned at end. After sorting header comes first and rest of the records next. This was fine since records other than ...

Thanks for the reply

Here is my requirement
I have to read all the records from database A and for each record read i have to look for a match based on some key and the date conditions in the
sam ...

Here is my complete cursor declaration

EXEC SQL
DECLARE PRFRCST_CSR CURSOR WITH HOLD FOR
SELECT DISTINCT ...

I can have maximum of 10 records for each of 30-40,000 trigger records of the qsam file

My Cursor declaration as follows
DECLARE CSR_NAME CURSOR WITH HOLD FOR

Yes, I am re-populating the ho ...

I have a requirement where i have to process input file of 30,000 to 40,000 records and for every record read i have to open, fetch, close a cursor which is taking huge CPU time.

I tried to open an ...

I have a requirement where I have to select maximum effective date <= current _date for a given group and then delete the rows for the group with
effective date < maximum effective date obtaine ...

But LISTDSI functions only for Sequential Datasets and PDS's. It doesn't work for VSAM files. Please let me know if you find any alternate for the same.
Thanks, Dubasi.

In TSO, when I give the first qualifier/text as "FILE" in 3.4 and press ENTER, it would display all the list of dataset/PDS names starting with qualifier/text FILE. Where it would display th ...

Try deleting SYS1.MAN4 not SYS1.MAN4.DATA

Thanks for your responses.

Bill Dennis, you are absolutely right. Please let me know how it can be done.
Would be great if you can give me any example.

kolusu,
I am sorry....the processing logic isn't a macro. The processing logic has reading the input files and then generating output into Output_PDS & Report_PDS etc.