Page 1 of 1

Problem with updating the same file

PostPosted: Mon Jul 09, 2012 2:52 pm
by rajufis_01
hi ,
i want to update the same file without using Cobol program and also JCL intermediate files like repro is there any other way to overcome this situation? apologies if i am wrong. Can you please help me out.

Re: Problem with updating the same file

PostPosted: Mon Jul 09, 2012 2:56 pm
by BillyBoyo
Can you describe exactly what it is you want to do, including the type of file, and why you have partcular limits to the methods to achieve it.

Re: Problem with updating the same file

PostPosted: Mon Jul 09, 2012 3:19 pm
by rajufis_01
Thanks for the reply….

Well coming to my requirement

I have one VSAM file In that VSAM file I want to update 3 fields, here the problems records are in millions so that previously in my company we have utility
Called FILEAID was there to do this but now it is disabled, here is the previous code before how we update thru FILEAID at a time millions of records with one JCL .

/PS180 EXEC PGM=FILEAID,COND=(0,LT)
//SYSPRINT DD SYSOUT=*
//SYSLIST DD SYSOUT=*
//DD01 DD DSN=G1OL00AT.FORP.YDGECLST.RAJ.TES,
// DISP=SHR
//SYSIN DD *
$$DD01 UPDATEALL FORM=MULTI,
IF=(1,EQ,C'05'),
REPL=(5,C'999')
/*
//*

is there any other way to achive like this??? now in my comapny we are using INSYNC inplace of FILEAID.

Re: Problem with updating the same file

PostPosted: Mon Jul 09, 2012 3:27 pm
by BillyBoyo
I can't say I've heard of INSYNC. There must be some people in you support teams who are responsible for INSYNC and the transition from FILEAID. You need to find those people and get their assistance. They should be able to give you access to manuals and even tell you what changes you'd need to use INSYNC to do this. If they can't give you an answer, the software vendor should be keen to help out as you are new clients and they will want to give you an easy time in using their product.

Re: Problem with updating the same file

PostPosted: Mon Jul 09, 2012 3:34 pm
by rajufis_01
thanks once again for your quick response…

I will ask here support team to resolve this problem…

Re: Problem with updating the same file

PostPosted: Mon Jul 09, 2012 7:39 pm
by dick scherrer
Hello,

Most well-managed organizations do not permit updating files "on-the-fly".

Suggest you repro the file into a qsam dataset (which could also be your backup of the data pre-update), apply the changes, and reload the vsam file. Using your sort product instead of IDCAMS will run faster.

When this is being done, the vsam file would not be used for any other processing.

Re: Problem with updating the same file

PostPosted: Mon Jul 09, 2012 8:40 pm
by Monitor
Whats wrong with a COBOL program?
Simple, easy to maintain.
The time you spent on posting and replying to this forum would have been enough to solve your problem with a COBOL-program, with the advantage not to be disabled in the future.
KIS!

Re: Problem with updating the same file

PostPosted: Tue Jul 10, 2012 12:29 pm
by mongan
I would think it is also possible to achieve this with SORT or ICETOOL.