Two Output Formats from One FEX Run

[LeonelSanchezJr]

I have one FEX which as both EXL2K and PDF output, but I have to run the FEX twice in order to get both formats.

Is it possible to run the FEX one time and without having to run the query within the FEX again, Output the second format?

Thanks,

Leo ;-)

 

[focwizard]

Sure, but the REAL answer may depend on WHERE you run it. After the first HOLD request (i.e. HOLD FORMAT EXL2K in the request), add, AFTER the END statement, HOLD FORMAT PDF, on a line by itself. The internal matrix will be reused, without having to re-retrieve the data.

NOTE that I say HOLD. If you're in the WebFocus world, you only can return ONE answer set to the client, so you have to pick which format you want returned. But, if you're keeping the results on the server, or running in batch, the above method will work.