Focal Point
Query regarding the modify syntax

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5611059962

February 05, 2008, 02:52 AM
mukund
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
February 05, 2008, 06:09 AM
Tony A
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 
February 05, 2008, 07:54 AM
GamP
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
February 05, 2008, 09:14 AM
GinnyJakes
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
February 05, 2008, 09:42 AM
PBrightwell
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