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,

I was goinf to say multiverb request, but I think there is a hold format for it.

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...

One piece is: ON TABLE SET EXTRACT ON

I found this.

http://documentation.informati.../source/topic114.htm

Or the WebFOCUS 7.6.1 documentation version.

http://documentation.informati...g/source/topic96.htm

Thanks a Million Waz,

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...

I wouldn't have found it without ON TABLE SET EXTRACT ON.

FYI,

I used the ecl search engine.

Thanks Waz, for introducing me to "ed"

My pleasure.

Its just another one of IBI's hidden gems.