Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     MODIFY command for loading the data in FOCUS file.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
MODIFY command for loading the data in FOCUS file.
 Login/Join
 
Syed
Platinum Member
posted
Hi
I am using CREATE command along with MODIFY to create a new FOCUS databse.
The code used is:
CREATE FILE
-RUN
-EXIT
USE
/usr/lpp/IWAYEPTA/ibi/apps/irs_dev/.foc
END
-RUN
MODIFY FILE
FIXFORM FROM
MATCH
ON NOMATCH
INCLUDE
ON MATCH
UPDATE
DATA ON
END

The problem is that in the first time (when there exists no FOCUS file), the time taken by the code to execute is around 17 minutes, whereas next time(when the FOCUS file has been created), it runs in just 30 seconds.
Can you please let me know why is there somuch of a difference in the two loads. FYI the no. of records fetched in the first load is approximately 14000. In the ongoing loads, it is much less.

Regards
Syed Arij
Using WF 7.1.4 though CITRIX.


Using WF 7.1.7/Dev Studio
 
Posts: 189 | Location: Boston, MA | Registered: July 12, 2005Report This Post
Alan B
Virtuoso
posted Hide Post
Syed

Firstly, is the time consumed on the CREATE portion or the MODIFY?

Make sure that when you issue the CREATE you have NEW appended to the USE statement.

The order of the data coming into the load is very important. If the data is not in key field sequence then the load will take progressively longer the more records there are. Maybe run a TABLE on the data to sort it before loading. Usually you get an message out to that effect, so look at the load output.

What does the MFD look like? Is it simple S1 segments, or are there multiple key fields? Are there a lot of indices? Load with alternate mfd and REBUILD the indices can reduce load times.

If everything is at it should be, the load should be pretty fast.

if you can answer these, then we may be able to help more.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
ptp
Silver Member
posted Hide Post
Shouldn't the USE be before the CREATE?

Good Luck,
P
 
Posts: 42 | Location: UK | Registered: October 23, 2005Report This Post
susannah
Expert
posted Hide Post
touche, ptp.
and be sure to comment out the CREATE and remove the NEW after the 1st run.
and your filenames don't seem to exist
eg:
lpp/IWAYEPTA/ibi/apps/irs_dev/.foc
omits the filename, as do your CREATE statement, your FIXFORM FROM and your DATA ON
statements. but that was probably intentional, right? and the -EXIT after your CREATE, why?

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



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Syed
Platinum Member
posted Hide Post
quote:
Make sure that when you issue the CREATE you have NEW appended to the USE statement.

Hi
I am trying Alan's approaches:
To answer your questions- Make sure that when you issue the CREATE you have NEW appended to the USE statement. - This was done previously.
There are multiple key fields - I am trying to supress the INDEX fields in the initial load and the use REBUILD to create the indices later.
Is it simple S1 segments - Yes
Are there a lot of indices? - Yes (14 in all)
The order of the data coming into the load is very important.- We are sorting the data and then holding it in a HOLD file, which is then used to load the data through MODIFY command.

The updated code is as follows:

USE
/usr/lpp/IWAYEPTA/ibi/apps/irs_dev/irs_fin_adj_smry.foc NEW
END
-RUN
CREATE FILE &IRS_FIN_ADJ_SMRY_TGT
-RUN

-LBL_CREATED
USE
END
-RUN
MODIFY FILE test
FIXFORM FROM TEMP
MATCH K1 k2.....k14
ON NOMATCH
INCLUDE
ON MATCH
UPDATE k15 k16
DATA ON TEMP
END

Please let us know how to go about it.

Regards
Syed Arij
Using WF 7.1.4 though CITRIX


Using WF 7.1.7/Dev Studio
 
Posts: 189 | Location: Boston, MA | Registered: July 12, 2005Report This Post
Alan B
Virtuoso
posted Hide Post
Syed

Oh, okay. You see, theoretically, this should load very quickly. So I am a little confused, so am just trying to clarify everything.

When you say you are trying to suppress the index fields, are you doing it this way:

-LBL_CREATED
USE CLEAR *
END
USE
-* alternateMaster is an MFD without indices.
/usr/lpp/IWAYEPTA/ibi/apps/irs_dev/irs_fin_adj_smry.foc AS alternateMaster
END
MODIFY FILE alternateMaster
.
.
END
USE CLEAR *
END
USE
/usr/lpp/IWAYEPTA/ibi/apps/irs_dev/irs_fin_adj_smry.foc
END
REBUILD
INDEX
irs_fin_adj_smry

If your SEGTYPE is S1, as you say, are you actually just matching the key field, I notice you use

MATCH K1 k2.....k14

which is not correct.

On the data load, from the HOLD file sorted on the key field, are there any messages in the output window that may help.

Try adding CHECK 99999 after the MODIFY statement, this might help.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Syed
Platinum Member
posted Hide Post
Hi Alan
Your approach worked just fine for me. Thanks a lot.
Just one more requirement in the same lines -
-* alternateMaster is an MFD without indices.
/usr/lpp/IWAYEPTA/ibi/apps/irs_dev/irs_fin_adj_smry.foc AS alternateMaster
END
MODIFY FILE alternateMaster
In the above code, mentioned by you, alternateMaster is a separate MFD without indices. What I am looking for is to achieve the same functionality (disabling the indexes and the rebuilding) without having two Master Files. Hence, my query boils down to - whether I can use the same .mas file to drop and rebuild indexes? If yes, then how can I do it programmatically?
Please suggest!

Regards
Syed Arij


Using WF 7.1.7/Dev Studio
 
Posts: 189 | Location: Boston, MA | Registered: July 12, 2005Report This Post
Alan B
Virtuoso
posted Hide Post
Syed
Glad that this is better for you.

There is not a way I know of to avoid having 2 MFDs, you cannot just switch indexing on or off.

You could -READ and -WRITE an MFD, removing the indices, but that is really messy, unless someone else can help here.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Syed
Platinum Member
posted Hide Post
Thanks a lot Alan,
Your suggestion worked and I was able to use MODIFY to drop and recreate indexes.

Thanks again
Syed


Using WF 7.1.7/Dev Studio
 
Posts: 189 | Location: Boston, MA | Registered: July 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     MODIFY command for loading the data in FOCUS file.

Copyright © 1996-2020 Information Builders