Please refresh me on this... How would I create a Multi-Segmented HOLD file such as the infamous CAR file, from code which may start out being something like this:
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON TABLE HOLD {blah blah blah]
END
I'm already thanking you for this refresher [Thanks Waz] (even for pointing me to the answer)...
BTW: the source file for this TABLE FILE request is from a JOIN which looks like this:
NUMBER OF ERRORS= 0
NUMBER OF SEGMENTS= 4 ( REAL= 1 VIRTUAL= 3 )
NUMBER OF FIELDS= 138 INDEXES= 0 FILES= 4
TOTAL LENGTH OF ALL FIELDS= 5920
SECTION 01
STRUCTURE OF GNTINT FILE SOSTORES ON 10/24/11 AT 20.35.46
sostore>
01 S4
**************
*store **
*field1 **
*field2 **
*field3 **
* **
***************
**************
I
+-----------------+-----------------+
I I I
I sopayro> I sodaily> I sodaily>
02 I KU 03 I KU 04 I KU
.............. .............. ..............
:store :K :store :K :store :K
:field4 : :field7 : :field10 :
:field5 : :field8 : :field11 :
:field6 : :field9 : :field12 :
: : : : : :
:............: :............: :............:
JOINED SOPAYROLL JOINED SODAILYACTJOINED SODAILYACTBYTYPE
So, I want to HOLD selected records from this in the same file structure.This message has been edited. Last edited by: Doug,
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
October 24, 2011, 09:49 PM
Waz
I was goinf to say multiverb request, but I think there is a hold format for it.
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!
October 24, 2011, 09:50 PM
Doug
Me too...
quote:
but I think there is a hold format for it
Now, If we can only think of what that hold format is...
I did this with that info in mind using a multverb request (one for each segment) and wrapped it up with a "ON TABLE HOLD FORMAT FOCUS AS REPORTFILE".
The bummer is that "ON TABLE SET EXTRACT ON" chrashes my server or just gives me a (FOC217) THE SEGMENT NAME IS A DUPLICATE AND NOT THE SAME AS PREVIOUS.
So, I get my 11k records into a hierarchical HOLD file in LE 3 seconds. I'll leave it at that.
==================================================================================
==== Doug's StopWatch Started at 21.28.30 on Oct 24, 2011
==================================================================================
NUMBER OF RECORDS IN TABLE= 11543 LINES= 11543
NUMBER OF ERRORS= 0
NUMBER OF SEGMENTS= 4 ( REAL= 4 VIRTUAL= 0 )
NUMBER OF FIELDS= 33 INDEXES= 0 FILES= 1
TOTAL LENGTH OF ALL FIELDS= 2980
SECTION 01
STRUCTURE OF FOCUS FILE REPORTFI ON 10/24/11 AT 21.28.33
SEG01
01 S1
**************
*store **
*tvvoidamt **
*instockpctv>**
*corercptamt **
* **
***************
**************
I
I
I
I SEG02
02 I S3
**************
*payrolltype **
*empname **
*jobdesc **
*hours **
* **
***************
**************
I
I
I
I SEG03
03 I S4
**************
*date **
*transtype **
*transno **
*transtime **
* **
***************
**************
I
I
I
I SEG04
04 I S10
**************
*store **
*payrolltype **
*empname **
*jobdesc **
* **
***************
**************
NUMBER OF RECORDS IN TABLE= 11543 LINES= 11543
==================================================================================
==== Doug's StopWatch Started at 21.28.30 / Ended at 21.28.33 on Oct 24, 2011
==== It took 3 seconds to get to this point in this procedure.
==================================================================================
Thanks Waz, for pointing me in the right direction...
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
October 24, 2011, 10:48 PM
Waz
I wouldn't have found it without ON TABLE SET EXTRACT ON.