Focal Point
[CLOSED] HOLD file formats - which one???

This topic can be found at:

February 26, 2019, 04:14 PM
[CLOSED] HOLD file formats - which one???
I've noticed with 8203 that InfoAssist will let us save HOLD files in an array of different types: Binary (*.ftm), FOCUS (*.foc), csv, Plain Text (*.ftm), Tab delimited, Database Table (*.sql), SQL Script (*.sql), XML and JSON. How do I know which to choose? And is there a material difference between different types that show the same file extension?

This message has been edited. Last edited by: DWaybright,

WebFOCUS 8.2.03
AppStudio, InfoAssist
Windows, All Outputs
February 27, 2019, 04:46 AM
Tony A
These formats have always been available even if not shown in the GUI.

You can get a generalised idea of what format to use when by searching the documentation - link - and specifically - link


since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 27, 2019, 05:32 AM
I sincerely doubt that the format "Database Table" has a file extension; that writes to a database table, doesn't it?

Or is that a difference between ON TABLE SAVE and ON TABLE HOLD?

WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
February 27, 2019, 08:34 AM
Tony, thanks for the links. I managed to miss those looking on my own. However, the " Choosing Output File Formats" doesn't list all of the options found in IA. It does list many others apparently available when coding by hand.

Wep5622 -- if you read the "Choosing Output File Formats" you will find the table formats include this information: "Creates a table if you have the Adapter and permission to create tables."

WebFOCUS 8.2.03
AppStudio, InfoAssist
Windows, All Outputs
February 27, 2019, 09:05 AM
How do I know which to choose?

That depends on what it is that you want to do with the held file.

   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
February 27, 2019, 09:59 AM
You aren't wrong. The "Choosing Output File Formats" helps, but I think running tests with different formats to see which gives the best performance will be part of our process.

WebFOCUS 8.2.03
AppStudio, InfoAssist
Windows, All Outputs