Hi All,

I am running out with one issue in my focus application. In application one of the focus database file is full. Now my target is to create a same database file with large volume and load data into new file. Can you please let me know, how to create the new file and load the data from old file to new file.


Thanks for your support!!!

Thanks,
Rajesh

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

What platform are you on?

UNIX and Widows do not have file size limitations from a physical point of view
whereas mainframe does.

The limitations on Unix and Windows are based on the Focus Database limit which
is 2 gigabytes. You cannot have a Focus database larger than this.

XFocus does not have this limitation as it can use multiple physical files
and has a maximum theoretical size of 2044 gigabytes.

However it is an additional cost option

To learn how to rebuild Focus files or use XFocus
search for REBUILD and XFOCUS in the online help of developers studio

Rajesh

Update your signature so we know better how to help you.

It is possible to give your focus database an other name but use the same master.
If you need to report from the two or mare focus databases you can use the USE command.

So you might have one master (CAR.MAS) and have CAR1.FOC and CAR2.FOC etc.

Rajesh,

The first thing that I would ask is - "How well do you know WebFOCUS/FOCUS?" If the answer is "not very well" then I would suggest basic training. If the answer is "quite well" then I would suggest the MODIFY or MAINTAIN course would be advisable.

T

If you just want to transfer the data from a Focus file to an Xfocus file that has much more storage space, you can do this easily using the REBUILD utility. You 'dump' the data using the old MFD ,and you create a new MFD with suffix XFOC and another name, and you 'load' the data under this MFD. Its all documented, and you can do it from Developer Studio.

Gerry,

XFOCUS is still an extra cost option ?

jg, i use xfocus and we don't pay anything extra for it.
radesh, do you know that you can have 2+ identical focus databases and concatenate them vertically,
USE
/.../database1.foc AS database1
/.../database2.foc AS database1
END
so, you're not restricted to one file, evenif you don't want to change them over to xfocus.

... and don't forget LOCATION files for subordinate segments.

T

quote:

i use xfocus and we don't pay anything extra for it

susannah,
If I were you I would check with your IBI account manager because XFOCUS is listed as a seperate
chargable item on the companies price list.

product no. WDS on mid range WDSN on windows

The multidimensional index functionality is also an extra cost item

product no. WMD on mid range WMDN on windows

This message has been edited. Last edited by: <JG>,

try it
ON TABLE HOLD FORMAT XFOCUS
works

Just because it works doesn't mean you have a license for it. There is no way to turn off that feature.

That sentence reminds me of a line from "Working Girl" when Joan Cusack says in a NY accent, "Just because I dance around in my underwear, don't make me Madonna".

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

ROFL!!!!!

I'm waiting for the day that coding a WebFOCUS program in a text editor will be "listed as a separate chargeable item on the company's price list".

Does that mean we can hold a wake for TED?

I should have said "I'm NOT waiting for the day that coding a WebFOCUS program in a text editor will be "listed as a separate chargeable item on the company's price list".

well we do have a nice notepad++ template
used as a DS substitute...

quote:

Originally posted by Francis Mariani:
I'm waiting for the day that coding a WebFOCUS program in a text editor will be "listed as a separate chargeable item on the company's price list".

Francis, You should not give people ideas like that.
They may well spot a potential new revenue stream

forgot to mention
you must use XFOCUS if you're making a table with long fieldnames.

Hi All,

Thanks for the provided information. I worked on the Rebuild option, it created little amount spaces in existing file. Temporary my issue is resolved, b'cos I am able to load the daily data.

I am working on the XFOCUS option to load the data in larger volume data. I used below code to load the data. I am getting some errors. Can you please let me know, how to use the XFOCUS option.

I have provided the sample code below and MFD's I am using in the code having same structure and database file I am using having same length also.

DYNAM ALLOC FILE EMPL DA AAAAABBB.EMPL.FOCUS SHR REUSE
DYNAM ALLOC FILE EMPL2 DA AAAAABBB.EMPL1.FOCUS SHR REUSE
-RUN
TABLE FILE EMPL
PRINT EMPID EMPNAME EMPDEPT HDATE
ON TABLE HOLD AS HOLD1 FORMAT XFOCUS
END
-RUN
MODIFY FILE EMPL2
FIXFORM EMPID/25 EMPNAME/100 EMPDEPT/100 HDATE/8
DATA ON HOLD1
END
-RUN
-EXIT

Thnaks,
Rajesh
FOCUS 7.1.1 Z/OS

Rajesh, its very nice to hear that you're working hard and learning from everyone's posts. Good work.
First, imho it works best if your hold1 file is ON TABLE HOLD AS HOLD1 FORMAT ALPHA
and your modify is
MODIFY FILE MYDATABASE
FIXFORM FROM HOLD1
....
DATA ON HOLD1
END
and second, that MYDATABASE needs to be set up first as an XFOCUS database.
What you seem to be wanting to modify is just a HOLD2 file.
That's not a good idea.
You want your MODIFY to operate on the actual database you want to be building.
That means the master file must exist, with SUFFIX=XFOC in the first line. You can either write it by hand, or create a small version of the database first, using ON TABLE HOLD FORMAT XFOCUS INDEX var1 var2 etc..
and you can get the master that way.

Once you have a master, to create the db from scratch, use the CREATE command:
USE
.wherever././MYDATABASE.FOC NEW
END
CREATE FILE MYDATABASE
..

Hi, Focus guys (and Ladies as well)
In a forum state of mind, I was just wanting to ask wether XFOCUS had turned into a free Option.
Which greatly surprised me, by the way.
JG Master and his red ink made me know it was not at all the case.
This message is quite personal and highly unofficial (Forum State of mind)
Cordialement

JG, Are you an IBI cop?

I've been told that even MODIFY on a good old regular FOCUS DB requires an extra licence. I know a lot of clients that use it and have not gone to jail or have not been fined.

Not at all Francis,

However I do work for the company and so am obliged to make it clear to users and customers
when they may be breaking their license agreements.
(Actually I am required to inform IBI when this situation arises as it is part of my
contract of employment to protect the companies interests at all times).

By making the issue about XFOCUS very, very clear and removing any possibility that
the situation regarding the requirement for a license is vague or open to interpretation I
would hope that those people who need to ensure that their respective companies or clients
are aware of the license requirement, negating me having to do anything else.

With regard the Focus database, this does not to my understanding require a license
for the use of Modify IF the Focus database resides on the same machine as the Focus server
however it does need a licensed component (Read/Write adapter for FOCUS DBMS)
when it is on another remote server.

Maintain requires a license in all cases.

quote:

Originally posted by Francis Mariani:
JG, Are you an IBI cop?

I've been told that even MODIFY on a good old regular FOCUS DB requires an extra licence. I know a lot of clients that use it and have not gone to jail or have not been fined.

not been caught you mean

seriously though, although it may not be clear it is a company's responsibilty to ensure they are compliant so these things should be checked as a matter of course.

I'm not a cop, I'm a private.
Sorry chaps, i was 18 in 68, and all that makes me ... (searching a word for sad laugh ..)
Focusely yours
PS : "Salon de l'Auto- Paris" : An electric car of the (supposed) future is Cactus by Citroën. It reminded me of a time when Cactus was the (supposed) future of Focus (by Ford ?).
Sad laugh, I'm afraid I'm growing old ...

I would like to clarify an issue about MODIFY, and if it needs a license. No it does not. It is free with WebFOCUS. In FOCUS it is licensed. However, MAINTAIN in WebFOCUS needs a license. The difference is that MODIFY is a large volume 'batch' type of data input/update process, and MAINTAIN is a 'transaction' type of process.

bemoaning the death of the gerund