[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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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 ?