Query regarding the modify syntax

I am using mainframe FOCUS version 7.3.5.

XYZ,PQR are sequential file.
1) Can we have READ syntax inside the MODIFY command.
e.g MODIFY file XYZ
on match hold a b c d
on match compute
READ file PQR
on match update a b c d
end

2) How to retain the values of variable inside the MODIFY syntax ?
from above example i want to retain the value of a b c and d after coming out of MODIFY syntax.
but currently i am unable to retain the values once i come out of the MODIFY syntax.
can we pass values to the variable used in MODIFY syntax from outside ?

3) in PQR file i have four value in different rows. How can i read the values one by one untill the end of file?

This message has been edited. Last edited by: mukund,

mainframe focus 7.3.5

Posts: 3 | Location: India | Registered: December 26, 2007

Tony A

Expert

posted

Hide Post

Mukund,

This is a little more than you should expect from this kind of forum.

Your best course of action is to get some training or buy some specialist assistance in.

I don't think that you'll get a MODIFY course but you could use the newer technology - MAINTAIN - instead. I would still recommend a training course though. It will stand you (and the company you work for) in good stead.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

GamP

Virtuoso

posted

Hide Post

You state XYZ and PQR are sequential files.
You can't MODIFY a sequential file. You can only modify non-sequential files, such as a focus database or a relational datasource.
Using modify you can READ a sequential file, using the FIXFORM statement.
You can HOLD data only by storing it into a non-sequential data file using INCLUDE/UPDATE comamnds.
OR you could use the TYPE ON ddname command to write the fields out to a sequential data stream identified to the Modify by using the FILEDEF statement.
I agree with Tony, this is all a bit too much to expect from the forum, and I also agree with his remark to use MAINTAIN instead.

GamP

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

Posts: 1961 | Location: Netherlands | Registered: September 25, 2007

Ignored post by GamP posted

Show Post

GinnyJakes

Expert

posted

Hide Post

Minimally, please read the chapter on MODIFY in the manual. Your syntax is totally wrong. You would spot that in a New York minute if you just at least read up on MODIFY in the manual.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Show Post

PBrightwell

Master

posted

Hide Post

If these are flat file, you may be looking for MATCH logic instead of MODIFY.

Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes

Posts: 755 | Location: TX | Registered: September 25, 2007

Ignored post by PBrightwell posted

Show Post