Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] HOLD file formats - which one???
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] HOLD file formats - which one???
 Login/Join
 
Platinum Member
posted
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?
Thanks!

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


WebFOCUS 8.2.03
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 116 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
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

T



In FOCUS
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 
 
Posts: 5573 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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 :
 
Posts: 1639 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 116 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
How do I know which to choose?

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


   See you at Summit! In FOCUS Since 1983 ~ from PC FOCUS to WebFOCUS.
   Currrently using 8204 Gen 48 in Test and Production.
   KGPCo at CenturyLink. October 2017 to Present...
 
Posts: 2967 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Doug,
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
 
Posts: 116 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] HOLD file formats - which one???

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.