Focal Point
[CLOSED] Focus table changes

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

February 01, 2011, 11:19 PM
Poryes
[CLOSED] Focus table changes
Hi All -

My requirement is to Add 2 new fields to input file and that input data is stored in focus table.

Pls let me know what are the necessary changes needs to done in focus table?

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


WebFOCUS 7.6.13

Mainframe
all output (Report in mainframe)
February 02, 2011, 05:18 AM
Ramkumar - Webfous
quote:
Add 2 new fields to input file


Input file - Is that the parameter screen that you mean ? Could you please be elaborate on this ?

2 new fields to input file - Trying to pass parameters or what ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
February 02, 2011, 06:08 AM
Tom Flynn
1. Copy OLD Master to New Master
2. Add the 2 new columns to the New Master
3. REBUILD
4. REORG
5. DUMP
6. OLD DATABASE NAME
7. NO
8. REBUILD
9. REORG
10. LOAD
11. NEW DATABASE NAME

Just like the manual states under Section 11 when you need to REORG your database...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 04, 2011, 03:41 PM
ira
Tom, great answer. I would answer one other note. Place the new fields at the end of the particular segment they are to be added in.

Ira


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
February 04, 2011, 11:04 PM
Doug
quote:
Just like the manual states under Section 11 when you need to REORG your database