Focal Point
Maintain/Add records in FOUCS file

This topic can be found at:

January 31, 2013, 04:04 PM
Maintain/Add records in FOUCS file
Hello All,

We have a request to add some new warehouse codes into an existing file (Fouce/FDS). The file is located in the MR report server EDASERVE. I can see the format and sample data, but cannot figure out how to add some new records into file. Can someone help me?

Appreciate any help or idea.


February 05, 2013, 11:51 AM
Hi Guang,

From our technicals: There are all sorts of techniques and examples on the support site using both MODIFY and MAINTAIN. Please review the following examples.

How to use MODIFY procedure to update FOCUS with SEGTYPE=S0

How to insert / updates records in Multi-Segment FOCUS file

How to add to an existing value in a FOCUS database?

[URL=MNT: Use Maintain to load a FOCUS database from a flat file ][/URL]

These should get you started. If you have additional questions, please open a case with Customer Support Services for assistance. You may call 1-800-736-6130, or access online at InfoResponse.



Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
February 11, 2013, 02:41 PM
Also in the current production Release 7.7.05 from the Data Management Console or Web Console you can right click on the synonym name and select Data Management > Show/Modify Data. Then click Insert to add new rows.