Focal Point
[CLOSED] Store tables created in WebFocus in the database to which we are connected

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

April 08, 2014, 05:30 AM
mariapoo
[CLOSED] Store tables created in WebFocus in the database to which we are connected
Hi good morning, I'm new to WebFocus and I would like to know how can I store the Master files I created in my database not on the basis of FOCUS data.

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


WebFOCUS 8.07,
Windows, All Outputs
April 08, 2014, 05:58 PM
Waz
What is your database ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 09, 2014, 03:09 AM
mariapoo
My database is Oracle.


WebFOCUS 8.07,
Windows, All Outputs
April 09, 2014, 07:13 AM
Danny-SRL
Maria,
Do you mean you want to copy your MASTER files into your Oracle Database?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

April 09, 2014, 11:10 AM
mariapoo
Yes


WebFOCUS 8.07,
Windows, All Outputs
April 09, 2014, 05:26 PM
Waz
How did you create your "Master Files", is an ON TABLE HOLD... or something else ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

April 10, 2014, 03:02 AM
mariapoo
Yes, is an ON TABLE HOLD


WebFOCUS 8.07,
Windows, All Outputs
April 10, 2014, 06:59 AM
Danny-SRL
Maria,

Ok. Try this:
  
-SET &ECHO=ALL;
-* File maria01.fex
-* Example with the CAR file
TABLE FILE CAR
SUM SALES CNT.MODEL
BY COUNTRY
BY CAR
ON TABLE HOLD AS POO1
END
-RUN
FILEDEF MAS DISK POO1.MAS
-RUN
EX -LINES 4 EDAPUT MASTER,MAS,C,MEM
FILENAME=MAS, SUFFIX=FIX
 SEGNAME=MAS, SEGTYPE=S0
  FIELDNAME=MASLINE, ALIAS=MASLINE, FORMAT=A200, ACTUAL=A200, $
-RUN
-* Connect to your Oracle database
TABLE FILE MAS
PRINT MASLINE
-* Delete the followint -* in order to save your MASTER in the database
-*ON TABLE HOLD AS HP001 FORMAT SQLORA 
END



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

April 10, 2014, 07:08 AM
mariapoo
Thanks! I will take a look at that.


WebFOCUS 8.07,
Windows, All Outputs
April 10, 2014, 05:48 PM
Waz
Is it the master file description you want to store of the data ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

May 21, 2014, 07:30 AM
mariapoo
quote:
Originally posted by Waz:
Is it the master file description you want to store of the data ?



WebFOCUS 8.07,
Windows, All Outputs