Problem with updating the same file



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Problem with updating the same file

Postby rajufis_01 » Mon Jul 09, 2012 2:52 pm

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.
rajufis_01
 
Posts: 17
Joined: Thu Nov 24, 2011 4:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Problem with updating the same file

 

Re: Problem with updating the same file

Postby BillyBoyo » Mon Jul 09, 2012 2:56 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Problem with updating the same file

Postby rajufis_01 » Mon Jul 09, 2012 3:19 pm

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.
rajufis_01
 
Posts: 17
Joined: Thu Nov 24, 2011 4:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Problem with updating the same file

Postby BillyBoyo » Mon Jul 09, 2012 3:27 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Problem with updating the same file

Postby rajufis_01 » Mon Jul 09, 2012 3:34 pm

thanks once again for your quick response…

I will ask here support team to resolve this problem…
rajufis_01
 
Posts: 17
Joined: Thu Nov 24, 2011 4:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Problem with updating the same file

Postby dick scherrer » Mon Jul 09, 2012 7:39 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Problem with updating the same file

Postby Monitor » Mon Jul 09, 2012 8:40 pm

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!
Monitor
 
Posts: 98
Joined: Wed Jan 18, 2012 8:59 pm
Has thanked: 0 time
Been thanked: 7 times

Re: Problem with updating the same file

Postby mongan » Tue Jul 10, 2012 12:29 pm

I would think it is also possible to achieve this with SORT or ICETOOL.
User avatar
mongan
 
Posts: 212
Joined: Tue Jan 11, 2011 8:32 pm
Has thanked: 1 time
Been thanked: 5 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post