Focal Point
[SOLVED] Copying Focus Data

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

October 13, 2008, 01:08 AM
manash
[SOLVED] Copying Focus Data
I have a Focus file from which i need to copy the entire data into a new Focus file. Please suggest.

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


FOCUS 7.1.1/ MF(OS/390)
October 13, 2008, 02:00 AM
GamP
Rebuild? Look it up int he manual.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
October 13, 2008, 02:02 AM
Tony A
Manash,

Try reading about FOCUS files in the manual and you will learn all you need to know to enable you to do this. In particular check out USE and REBUILD. If you have problems then ensure that your bosses give you the necessary training to allow you to do the job which is asked of you.

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 
October 13, 2008, 02:40 AM
<JG>
Tony I don’t think that many people from the Indian sub continent understand Hebrew.

To paraphrase John Arbuthnot from 1692
quote:
“The Reader may here observe the Force of WebFocus, which can be successfully applied, even to those things, which one would imagine are subject to no Rules.
There are very few things which we know, which are not capable of being reduced to WebFocus Reasoning; and when they cannot it's a sign our knowledge of them is very small and confused.”

October 13, 2008, 03:56 AM
Tony A
John,

The item within my signature was not specifically destined for them. After the recent problems in assisting the chap from Spain, I thought that I would occasionally add a quote in a different language to see who's reading the posts fully. So full marks to you for identifying Hebrew as the language!

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 
October 13, 2008, 04:22 AM
<JG>
Tony, understand that.

What might be a good idea would be an extension to the keyword tags
for example [español] indicating a need for help in other than english.

quote:
“You gain strength, courage, and confidence by every experience by which you really stop to look
WebFocus in the face. You are able to say to yourself,
'I lived through this horror. I can take the next thing that comes along.”
Eleanor Roosevelt
October 13, 2008, 04:46 AM
Tony A
Not a bad idea at all, however, being (primarily?) an English 'speaking' forum I would guess that IB would want to encourage interaction using English? Who knows?

I did think about posting the English version followed by a translation for those that need it? If our English is grammatically correct etc. then it might help non-English speaking individuals in their understanding of our language?

T
October 13, 2008, 10:36 AM
Dave Ayers
manash,

TABLE FILE whatever
PRINT *
ON TABLE HOLD AS newname FORMAT FOCUS
END

You might need to assign key fields, and assign an APP directory to receive the focus and master files, but that is the basic, simple, way.


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
October 14, 2008, 12:03 AM
Shrikant
Manash,

You can directly use 3.3 for copying focus files on mainframes, alternately you can copy using COPY option in DATA SET LIST ACTIONS.


FOCUS 7.2.3
Platform: IBM system Z9 Business class
O/P formats: Flat files, excel and CSV files
October 14, 2008, 01:56 AM
Tony A
quote:
3.3
Providing your ISPF hasn't been changed from what is "standard" and making sure the lrecl, recfm and blksize values are correct.

I have seen occasions when this method corrupts the data in copying and the most reliable method is to use rebuild IMHO.

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 
October 14, 2008, 07:19 PM
StuBouyer
quote:
Originally posted by Dave Ayers:
manash,

TABLE FILE whatever
PRINT *
ON TABLE HOLD AS newname FORMAT FOCUS
END

You might need to assign key fields, and assign an APP directory to receive the focus and master files, but that is the basic, simple, way.


Dave,

It is a simple way ut it only works for simple FOCUS files.

Try

TABLE FILE CAR
PRINT *
ON TABLE HOLD AS CARHOLD FORMAT FOCUS
END
-RUN
CHECK FILE CAR PICT
CHECK FILE CARHOLD PICT

and compare CARHOLD.MAS against CAR.MAS.

PRINT * only takes one path of a multipath file - you should see a warning about it

(FOC757) WARNING. YOU REQUESTED PRINT * OR COUNT * FOR A MULTIPATH FILE

If you have a single segment then all is good, otherwise you lose the structure of the original FOCUS file

Cheers

Stu


WebFOCUS 8.2.03 (8.2.06 in testing)
October 15, 2008, 02:46 PM
GCohen
Copying Focus files is done via the REBUILD command. The first phase is a REBULD DUMP and the second phase is a REBUILD LOAD. This is documented under the "REBUILD Command".


Release 7.6.9
Windows
HTML
October 15, 2008, 02:56 PM
Tony A
Gerry,

I think you mean REBUILD, REORG, DUMP and REBUILD, REORG, LOAD unless you've had the REBUILD command changed Confused

T