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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Maintain/Add records in FOUCS file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Maintain/Add records in FOUCS file
 Login/Join
 
Member
posted
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.

Thanks,

Guang
 
Posts: 29 | Registered: April 16, 2012Report This Post
Expert
posted Hide Post
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 ]https://techsupport.informationbuilders.com/sps/33042529.html[/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.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Guru
posted Hide Post
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.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Maintain/Add records in FOUCS file

Copyright © 1996-2020 Information Builders