Choosing Output File Formats

Reference:

You can select from a wide range of output formats to preserve your report output for use in any of the following ways:

For details on each of the supported formats, including the commands that support them (HOLD, PCHOLD, SAVE) and the operating environments in which they are available, see the reference topics for the following formats.

AHTML

AHTMLTAB

ALPHA

APDF

BINARY

CLIP

COMMA

COM

COMT

DB2

DBASE

DFIX

DHTML

DIF

DOC

EXCEL

EXL07

EXL2K

EXL2K FORMULA

EXL2K PIVOT

EXL97

FLEX

FOCUS

GIF

HTML

HTMTABLE

INGRES

INTERNAL

JPEG

JSCAHRT

LOTUS

PDF

POSTSCRIPT (PS)

PPT

REDBRICK

SQL

SQL_SCRIPT

SQLDBC

SQLINF

SQLMAC

SQLMSS

SQLODBC

SQLORA

SQLPSTGR

SQLSYB

SYLK

TAB

TABT

VISDIS

WK1

WP

XFOCUS

Tip: To ensure that you will be able to open a format type in your browser see Specifying MIME Types for WebFOCUS Reports.


Top of page

x
Reference: FORMAT AHTML

Description: Saves report output as an active report (HTML file that can be used for offline analysis and interactive functions without any connection to a server). All of the data and JavaScript code are stored within the HTML file, which also makes the output highly compressible for email and transparent to security systems. For more information about active reports, see the Active Technologies User's Guide.

Use: For offline analysis of data.

Supported with the commands: HOLD, PCHOLD, SAVE.

Available in: WebFOCUS, FOCUS, Developer Studio.


Top of page

x
Reference: FORMAT AHTMLTAB

Description: Creates an output file that contains only data and parameters used in an HTML active report. The output produced is not a complete HTML active report. However, the file can be included in another HTML document using the Dialogue Manager command -HTMLFORM. For details, see the documentation on Dialogue Manager in the Developing Reporting Applications manual.

Note: When issuing HOLD AS name FORMAT AHTMLTAB to embed an HTML active report into another HTML document, you must include Active Technologies JavaScript code into the HTML BODY using:

<BODY>
!IBI.OBJ.ACTIVEREPORTJS;

Use: For embedding HTML active reports into an existing HTML document.

Supported with the commands: HOLD, SAVE.

Available in: WebFOCUS, Developer Studio.


Top of page

x
Reference: FORMAT ALPHA

Description: Saves report output as fixed-format character data and can be created as a HOLD file.

ALPHA is the default SAVE format. The output file contains data only.

Text fields are supported in ALPHA-formatted files. See Using Text Fields in Output Files.

To control missing data characters that are propagated to fields with the MISSING=ON attribute, use the SET HNODATA command. For more information, see the Developing Reporting Applications manual.

Use: For display in a text document. For further reporting in FOCUS, WebFOCUS, or Developer Studio. As a transaction file for modifying a data source.

Supported with the commands: HOLD, PCHOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT APDF

Description: Saves report output as an Adobe® Flex® report (Adobe® Flash® file) embedded in a PDF file. The resulting PDF active report can be used for offline analysis and interactive functions without any connection to a server.

In order to run a report created using the APDF format, Adobe Reader 9 or higher is required so the Flash run-time code included in the Acrobat client can render the Flash content.

Use: For offline analysis of data.

Supported with the command: HOLD, PCHOLD, SAVE.

Available in: FOCUS, WebFOCUS, Developer Studio, InfoAssist.


Top of page

x
Reference: FORMAT BINARY

Description: Saves report data and stores numeric fields as binary numbers. When created as a HOLD file, also creates a Master File.

BINARY is the default format for HOLD files. When created in BINARY format:

The output file contains data only.

Use: For further reporting in FOCUS, WebFOCUS, or Developer Studio. As a transaction file for modifying a data source.

Supported with the commands: HOLD, PCHOLD

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT CLIP

Description: Copies the report text in tab delimited format to the Windows Clipboard, from which you can paste the output into any Windows application that supports pasting from the Clipboard.

Use: For display in a text document.

Supported with the command: HOLD.

Available in: Developer Studio.


Top of page

x
Reference: FORMAT COMMA

Description: Saves the data values as a variable-length text file, with fields separated by commas and with character values enclosed in double quotation marks. All blanks within fields are retained. This format is the industry standard comma-delimited format.

This format does not have the safety feature of the double quote added within a text field containing a double quote.

The extension for this format is PRN. This format type does not create a Master File.

Note:

The output file contains data only.

Use: For further processing in a database application. This format type can be imported into applications such as Excel or Lotus.

Supported with the commands: HOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT COM

Description: Saves the data values as a variable-length text file with fields separated by commas and with character values enclosed in double quotation marks. Leading blanks are removed from numeric fields, and trailing blanks are removed from character fields. To issue a request against this data source, the setting PCOMMA=ON is required.

This format also includes a built-in safety feature, which allows embedded quotes within character fields. A second double quote (") is inserted adjacent to the existing one. For example, if you input Joe "Smitty" Smith, the output is Joe ""Smitty"" Smith.

The extension for this format is CSV. A Master File is created for this format type when the command used to create the output file is HOLD. The SUFFIX in the generated Master File is COM.

Note:

Use: For further processing in a database application. This format type can be imported into applications such as Excel or Lotus.

Supported with the commands: HOLD, SAVE, PCHOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT COMT

Description: Saves the column headings in the first row of the output file. It produces a variable-length text file with fields separated by commas, and with character values enclosed in double quotation marks. Leading blanks are removed from numeric fields, and trailing blanks are removed from character fields. This format is required by certain software packages such as Microsoft Access.

This format also includes a built-in safety feature, which allows embedded quotes within character fields. A second double quote (") is inserted adjacent to the existing one. For example, if you input Joe "Smitty" Smith, the output is Joe ""Smitty"" Smith.

The extension for this format is CSV. A Master File is created for this format type when the command used to create the output file is HOLD. The SUFFIX in the generated Master File is COMT.

Note:

Use: For further processing in a database application. This format type can be imported into applications such as Excel or Lotus.

Supported with the commands: HOLD, SAVE, PCHOLD.

Available in: FOCUS, Developer Studio, WebFOCUS.


Top of page

x
Reference: FORMAT DB2

Description: Creates a DB2 table, if you have the Adapter for DB2 and permission to create tables.

Use: For further processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT DBASE

Description: Creates an extract file in dBase format that includes column headings in the first row.

Note: Blank field names display as blank column titles. This may result in an error when attempting to use the file as input to various applications.

Use: For importing data to Windows-based applications such as MS Access and Excel.

Supported with the command: HOLD.

Available in: Developer Studio.


Top of page

x
Reference: FORMAT DFIX

Description: Creates a delimited output file. You can specify the delimiter, whether alphanumeric fields should be enclosed within a special character such as a double quotation mark, and whether the file should be generated with a header record containing the field names.

For more information, see Creating a Delimited Sequential File.

Use: For importing data to Windows-based applications such as MS Access and Excel.

Supported with the command: HOLD, PCHOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT DHTML

Description: Provides HTML output that has most of the features normally associated with output formatted for printing such as PDF or PostScript output. You can create an HTML file (.htm) or a Web Archive file (.mht). The type of output file produced is controlled by the value of the HTMLARCHIVE parameter. HTMLARCHIVE=ON creates a Web Archive file.

Some of the features supported by format DHTML are:

Note:

Use: For display as a webpage.

Supported with the commands: HOLD, PCHOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT DIF

Description: Captures the entire report output, excluding headings, footings, subheads, and subfoots, and creates a character file that can be easily incorporated into most spreadsheet packages.

For example, running a TABLE request with HEADING/FOOTING and ON TABLE PCHOLD FORMAT DIF does not display the report output with headings and footings. As a workaround, use another format (such as HTML, PDF, or EXL2K).

Note: Microsoft Excel SR-1 is no longer supported for HOLD FORMAT DIF. To open these reports, use either Microsoft Excel SR-2 or Microsoft Excel 2000.

Use: For display or processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD, SAVE.

The PCHOLD variation transfers the data from a web server to a browser.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT DOC

Description: Captures the entire report output, including headings, footings, and subtotals, and creates a text file with layout and line breaks that can be easily incorporated into most word processing packages. DOC format uses a form-feed character to indicate page control information.

Note: A request that contains ON TABLE PCHOLD FORMAT DOC results in a blank first page in the report when displayed in Microsoft XP Office. To eliminate this, include SET PAGE=NOPAGE in your request.

Use: For display in a text document.

Supported with the commands: HOLD, PCHOLD, SAVE.

The PCHOLD variation transfers the data from a web server to a browser.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT EXCEL

Description: Captures report output as a Microsoft Excel spreadsheet file, including data and column titles, but without report headings, footings, subheadings, or subfootings. If the report request contains an ACROSS phrase and specifies FORMAT EXCEL, column titles are not included in the output. If you wish to have the ACROSS column titles appear, use HOLD/PCHOLD FORMAT EXL2K.

Text and varchar (AnV) fields are not supported with FORMAT EXCEL. To include them, use HOLD FORMAT EXL2K. To use FORMAT EXL2K, you must have Excel 2000 installed.

Leading zeros do not appear for FORMAT EXCEL.

Since only single-line (single-cell) column titles are supported in format EXCEL reports, any additional column title rows are treated as data. For example, if you have a report with a multi-line (multi-cell) column title and you sort the column, the second (and so on) column title rows are sorted with the data. To avoid this, only select the data instead of the entire column when you select sorting options in Excel.

Note:

Use: For display or processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.

In FOCUS, the recommended transfer mechanism is FTP in binary mode. On a PC, the extension of the resulting file should be .xls.

Note: If drill-downs are included in a WebFOCUS report in Excel format, and the drill-down reports fail to open, you must check the "Browse in same window" option for XLS file types. If this setting is not selected, a WebFOCUS report in Excel format will be unable to pass cookies to drill-down reports, and the reports will fail to open. To check the "Browse in same window" option for XLS file types, perform the following steps:

  1. Access Windows Explorer.
  2. From the Tools menu, click Folder Options.
  3. Select the File Types tab.
  4. Select the XLS extension and then click Advanced.
  5. Select the Browse in same window check box and then click OK.
  6. Click Close to exit the Folder Options window.

Top of page

x
Reference: FORMAT EXL07

Description: Generates fully styled reports in Excel 2007 XML format. You must have Excel 2007 or higher installed to use this output format. For details, see Choosing a Display Format.

An Excel 2007 worksheet can contain 1,048,576 rows by 16,384 columns. WebFOCUS will generate worksheets larger than these defined limits, but Excel 2007 will have difficulty opening the resulting workbook, and the data that exceeds the Excel 2007 limits will be truncated.

For information about creating overflow worksheets for the additional rows when the number of rows becomes too high for a single worksheet, see Overcoming the Excel 2007 and 2010 Row Limit Using Overflow Worksheets.

Use: For display or processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD, SAVE.

For Internet Explorer, the PCHOLD variation launches Excel 2007 in the browser. For details, and for information about working with EXL07 files, see Choosing a Display Format.

Available in: WebFOCUS, Developer Studio.


Top of page

x
Reference: FORMAT EXL2K

Description: Generates fully styled reports in Excel 2000 HTML format. You must have Excel 2000 installed to use this output format. For details, see Choosing a Display Format.

ACROSS column titles are supported for EXL2K output format.

For EXL2K output format, a report can include 65,536 rows and/or 256 columns. Rows and columns in excess of these limits are truncated from the worksheet when opened in Excel.

For information about creating overflow worksheets for the additional rows when the number of rows becomes too high for a single worksheet, see Overcoming the Excel 2003 65K Row Limit Using Overflow Worksheets.

Use: For display or processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD, SAVE.

For Internet Explorer, the PCHOLD variation launches Excel 2000 in the browser. For details, and for information about working with EXL2K files, see Choosing a Display Format.

Available in: WebFOCUS, Developer Studio.


Top of page

x
Reference: FORMAT EXL2K FORMULA

Description: Specifies that the report will be displayed as an Excel 2000 spreadsheet, with WebFOCUS totals and other calculated values translated to active Excel formulas. For details, see Choosing a Display Format.

Use: For display or processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD, SAVE.

Available in: WebFOCUS, FOCUS, Developer Studio.


Top of page

x
Reference: FORMAT EXL2K PIVOT

Description: Generates fully styled reports in Excel 2000 HTML format, with added pivoting capabilities. Requires Excel 2000 on your PC. For details, see Choosing a Display Format.

Use: For display or processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD, SAVE.

For Internet Explorer, the PCHOLD variation transfers the data from a web server to a browser, which launches Excel 2000.

Available in: WebFOCUS, FOCUS, Developer Studio.


Top of page

x
Reference: FORMAT EXL97

Description: Enables you to view and save reports in Excel 97 that include full styling. For details on working with Excel formats, see Choosing a Display Format.

Leading zeros do not display for FORMAT EXL97.

Use: For display or processing in a spreadsheet application.

Supported with the command: HOLD, PCHOLD, SAVE.

Available in: FOCUS, WebFOCUS, Developer Studio.


Top of page

x
Reference: FORMAT FLEX

Description: Saves report output as an active report in an Adobe Flash player compatible (.swf) file that can be used for offline analysis and interactive functions without any connection to a server. Internet Explorer, Mozilla Firefox, and Opera internet browsers recognize an active report in the Adobe Flex format as a Shockwave Flash Object.

In order to run a report created using the Active Technologies for Adobe Flash player (FLEX) format, Adobe Flash Player 9.0.28 or higher is required.

Use: For offline analysis of data.

Supported with the command: HOLD, PCHOLD, SAVE.

Available in: FOCUS, WebFOCUS, Developer Studio.


Top of page

x
Reference: FORMAT FOCUS

Description: Creates a FOCUS data source. Four files result: a HOLD data file, a HOLD Master File, and two work files. See Holding Report Output in FOCUS Format.

Text fields are supported for FOCUS output files. See Using Text Fields in Output Files.

Use: For further processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT GIF

Description: Saves the output of a graph request as a GIF file.

Use: The resulting GIF file can be embedded in the heading/footing or body of a PDF or HTML report. This technique is useful when you want to create a single PDF or HTML report that contains multiple outputs, such as output from a TABLE request and a GRAPH request. You can distribute this type of report using ReportCaster.

When running graphs in GIF format on a UNIX platform with the HEADLESS configuration, the graph may not display properly. You may see a red X instead of your image. This is due to Sun's methodology of creating images without a head, which does not currently support GIF graphics.

Supported with the commands: HOLD.

Available in: WebFOCUS, Developer Studio.

For details see Creating a Graph.


Top of page

x
Reference: FORMAT HTML

Description: Creates a complete HTML document that can be viewed in a web browser. The PCHOLD variation transfers the data from a web server to a browser.

The following StyleSheet features are supported with HTML: JAVASCRIPT (drill down to JavaScript), TARGET, COLSPAN, HEADALIGN, IMAGEALIGN, IMAGEBREAK, GUTTER, BACKIMAGE, BACKCOLOR, IMAGE, GRIDS.

Use: For display as a webpage.

Supported with the commands: HOLD, PCHOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT HTMTABLE

Description: Creates an output file that contains only an HTML table. The output produced is not a complete HTML document.

However, the file can be included in another HTML document using the Dialogue Manager command -HTMLFORM. For details see the documentation on Dialogue Manager in the Developing Reporting Applications manual.

Note: When issuing HOLD AS name FORMAT HTMTABLE, you must specify a different name than the .htm filename used in the -HTMLFORM name.

The following StyleSheet features are supported with HTML: JAVASCRIPT (drill down to JavaScript), TARGET, COLSPAN, HEADALIGN, IMAGEALIGN, IMAGEBREAK, BACKCOLOR, IMAGE, GRIDS.

Internal cascading style sheets (CSS) are supported for FORMAT HTMTABLE. The CSS code is placed immediately before the TABLE command.

Use: For embedding reports and graphs in an existing HTML document.

Supported with the commands: HOLD, PCHOLD, SAVE.

The PCHOLD variation also transfers the data from a web server to a browser.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT INGRES

Description: Creates an Ingres table, if you have the Adapter for Ingres and permission to create tables.

Use: For further processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS when used as a client to the WebFOCUS Reporting Server.


Top of page

x
Reference: FORMAT INTERNAL

Description: Saves report output without padding the values of integer and packed fields. See Saving Report Output in INTERNAL Format.

Use: For accurate processing by 3GL programs.

Supported with the command: HOLD, SAVB.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT JPEG

Description: Saves the output of a graph request as a JPEG file.

Use: The resulting JPEG file can be embedded in the heading/footing or body of a PDF or HTML report. This technique is useful when you want to create a single PDF or HTML report that contains multiple outputs, such as output from a TABLE request and a GRAPH request. You can distribute this type of report using ReportCaster. JPEG files behave the same as GIF files.

Supported with the commands: HOLD.

Available in: WebFOCUS, Developer Studio.

For details, see Linking From a Graphic Image and Adding an Image to a Report.


Top of page

x
Reference: FORMAT JSCHART

Description: Saves the output of a graph request as an HTML5 graph.

Use: The charts are rendered in the browser as high quality interactive vector graphics using a built-in JavaScript engine. Note that older browsers do not support all of the features of the HTML5 standard. You must include both of the following commands to create an HTML5 graph:

ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH PCHOLD FORMAT JSCHART

Supported with the commands: ON GRAPH PCHOLD.

Available in: WebFOCUS, Developer Studio.

For details, see Creating an HTML5 Graph.


Top of page

x
Reference: FORMAT LOTUS

Description: Captures all the columns of the report in a character file that LOTUS 1-2-3 can then import. All alphanumeric fields are enclosed in quotation marks. Columns are separated by commas.

Use: For display and processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD, SAVE (WebFOCUS only).

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT PDF

Description: Saves the report output in Adobe Portable Document Format (PDF), which enables precise placement of output (all formatting options such as headings, footings, and titles) correctly aligned on the physical page, so the report looks exactly as it does when printed.

In WebFOCUS, PDF format also supports StyleSheets that contain drill down parameters, links to arbitrary URLs, and embedded GIF or JPEG images in report, page, and sort headings and footings.

PDF format does not support OLAP reports since Java applets cannot be embedded inside PDF documents. However, an OLAP report can drill down to a PDF-formatted report. PDF does not support drill downs when sorting across column. When you drill down from one report to another report, do not use the following characters: + (plus sign); # (number sign); & (ampersand); \ (backslash).

A PDF object is a page, hyperlink, or image. The Portable Document Format (PDF) limits the number of objects that a PDF document can contain. WebFOCUS imposes the following object limits for each PDF report:

Object

Limit

Pages

10,000

Images

900

Hyperlinks per page

500

Total pages with hyperlinks

100

Total hyperlinks

44,500

PDF format retains all formatting options, such as a headings, footings, and titles.

The following fonts are supported: Courier (fixed width), Times (proportional width), and Helvetica (proportional width). PDF format maps all fonts to Courier, Helvetica, or Times. The font styles that can be used are Normal (default), Bold, Italic, Underline, and combinations of these.

The following StyleSheet features are supported with PDF: PAGESIZE, ORIENTATION, UNITS, TOPMARGIN, BOTTOMMARGIN, LEFTMARGIN, RIGHTMARGIN, POSITION, SQUEEZE, FOCEXEC (drill down to FOCEXEC), URL (drill down to URL), HGRID, VGRID, BACKCOLOR. Note when you use BACKCOLOR with PDF reports, extra space is added to the top, bottom, right, and left of each cell of data in the report. This is for readability and to prevent data truncation.

Use: For display as a printed document.

Supported with the commands: HOLD, PCHOLD, SAVE (WebFOCUS only).

Available in: WebFOCUS, Developer Studio, FOCUS.



x
Reference: FORMAT PDF OPEN/CLOSE

Description: Saves multiple reports into one PDF report.

Use: For combining multiple reports into a single PDF file, also known as a compound report. For complete details, see Laying Out the Report Page.

Supported with the command: PCHOLD.

Available in: WebFOCUS, Developer Studio, FOCUS


Top of page

x
Reference: FORMAT POSTSCRIPT (PS)

Description: Creates an output file in PostScript format, which supports headings, footings, and totals.

PS is an abbreviation for POSTSCRIPT.

PostScript format supports headings, footings, and totals. PS supports ISO Latin font encoding.

Use: For display as a printed document.

Supported with the command: HOLD, PCHOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT PPT

Description: Creates an output file in PowerPoint® format in which each page of report output becomes a separate slide in the file with all styling applied.

Use: For use in a slide presentation.

Supported with the command: HOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT REDBRICK

Description: Creates a Red Brick table, if you have the Adapter for Redbrick and permission to create tables.

Use: For further processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS when used as a client to the WebFOCUS Reporting Server.


Top of page

x
Reference: FORMAT SQL_SCRIPT

Description: Creates an SQL subquery file or a file of data values with a corresponding synonym.

When used in a request against a relational data source, the HOLD FORMAT SQL_SCRIPT command generates the SQL SELECT statement needed to execute the current query and stores it in the application folder as a file with a .sql extension along with the Master and Access File pair that describes the SQL answer set.

When used in a request against any other type of data source, the HOLD FORMAT SQL_SCRIPT command executes the current query and stores the retrieved values in the application folder as a sequential file with a .ftm extension along with the Master File that describes the retrieved data.

Use: You can use the output from HOLD FORMAT SQL_SCRIPT as the target file for the DB_INFILE function. For information about the DB_INFILE function, see the Using Functions manual.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT SQLDBC

Description: Creates a Teradata table, if you have the Adapter for Teradata and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT SQLINF

Description: Creates an Informix table, if you have the Adapter for Informix and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS when used as a client to the WebFOCUS Reporting Server.


Top of page

x
Reference: FORMAT SQLMAC

Description: Creates a Microsoft Access table, if you have the Adapter for Microsoft Access and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio.


Top of page

x
Reference: FORMAT SQLMSS

Description: Creates a Microsoft SQL Server table, if you have the Adapter for Microsoft SQL and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS when used as a client to the WebFOCUS Reporting Server.


Top of page

x
Reference: FORMAT SQLODBC

Description: Creates an SQLODBC table if you have the current Adapter for ODBC and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS when used as a client to the WebFOCUS Reporting Server.


Top of page

x
Reference: FORMAT SQLORA

Description: Creates an Oracle table, if you have the Adapter for Oracle and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT SQLPSTGR

Description: Creates a PostgreSQL table, if you have the Adapter for PostgreSQL and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS when used as a client to the WebFOCUS Reporting Server.


Top of page

x
Reference: FORMAT SQLSYB

Description: Creates a Sybase table, if you have the Adapter for Sybase and permission to create tables.

Use: For processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS when used as a client to the WebFOCUS Reporting Server.


Top of page

x
Reference: FORMAT SYLK

Description: Captures all the columns of the report request in a character file for Microsoft's spreadsheet program Multiplan. The generated file cannot have more than 9,999 rows.

Use: For display and processing in a spreadsheet application.

Supported with the command: HOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT TAB

Description: Creates an output file in tab-delimited format. The TAB format includes a built-in safety feature, which allows embedded quotes within character fields. A second double quote (") is inserted adjacent to the existing one. For example, if you input Joe "Smitty" Smith, the output is Joe ""Smitty"" Smith. The TAB format also includes the following features:

Note: To create a variable-length comma- or tab-delimited HOLD file that differentiates between a missing value and a blank string or zero value, use the SET NULL=ON command. For more information, see the Developing Reporting Applications manual.

Use: For importing data to Windows-based applications such as MS Access and Excel.

Supported with the command: HOLD, SAVE, PCHOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT TABT

Description: Creates an output file in tab-delimited format that includes column headings in the first row. The TABT format includes a built-in safety feature, which allows embedded quotes within character fields. A second double quote (") is inserted adjacent to the existing one. For example, if you input Joe "Smitty" Smith, the output is Joe ""Smitty"" Smith. The TABT format also includes the following features:

Note:

Use: For importing data to Windows-based applications such as MS Access and Excel.

Supported with the command: HOLD, SAVE, PCHOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT VISDIS

Description: WebFOCUS has a data visualization tool called Visual Discovery that creates graphs using a tab-delimited data file as input. The first record of the data file contains the column titles for the data values. The next record can contain the Visual Discovery field formats. If this record is not present, Visual Discovery attempts to determine the formats of the data fields by reading the first 50 records from the data file, a process that is not guaranteed to create accurate representations of the WebFOCUS formats.

The following table identifies format conversions for HOLD FORMAT VISDIS:

FOCUS Format

Visual Discovery Format

Integer

I

Decimal/Packed

R

Alphanumeric

S

Date format (smart date)

D%format%format%format (for example, D%Y%M%D). If the year is not a four-digit year, the format returned is S.

Other

S

Note: No Master File is created for format VISDIS.

Use: HOLD FORMAT VISDIS creates a tab-delimited output file with the extension .txt in which the first record has the column titles and the second record contains Visual Discovery formats based on the FOCUS field formats of the data.

Supported with the command: HOLD, SAVE, PCHOLD

Available in: WebFOCUS, FOCUS.



x
Reference: FORMAT WK1

Description: Captures all the columns of the report in a character file that LOTUS 1-2-3 Release 2 can then import.

Use: For display and processing in a spreadsheet application.

Supported with the commands: HOLD, PCHOLD.

Available in: Developer Studio.


Top of page

x
Reference: FORMAT WP

Description: Captures the entire report output, including headings, footings, and subtotals, and creates a text file that can easily be incorporated into most word processing packages.

Text fields are supported in WP format. See Using Text Fields in Output Files.

To control whether a carriage control character is included in column 1 of each page of the report output, use:

[ON TABLE] HOLD AS filename FORMAT WP [CC|NOCC]

NOCC excludes carriage control characters. The position reserved for those characters remains in the file, but is blank. CC includes carriage control characters and, in z/OS, creates the HOLD file with RECFM VBA. To include page control information in the WP file, you can also specify the TABPAGENO option in a heading or the SET PAGE=OFF command. The character 1 in the column 1 indicates the start of a new page.

The following rules summarize FORMAT WP carriage control options:

Tip: HOLD FORMAT WP does not change the number of lines per page. In order to do so, issue one or a combination of the commands SET PRINT=OFFLINE, SET SCREEN=PAPER, or SET SCREEN=OFF.

The WP file is created with a record format of VB in z/OS when the carriage control character is omitted and with a record format of VBA when the carriage control character is inserted.

The maximum record length for HOLD FORMAT WP is 358 characters, 356 of which can represent data. For larger output, use PCHOLD FORMAT WP.

If you need the report width to remain fixed across releases for later processing of the output file, you can set the width you need using the SET WPMINWIDTH command. This parameter specifies the minimum width of the output file. It will be automatically increased if the width you set cannot accommodate the fields propagated to the output file in the request. The LRECL of the output file will be four bytes more than the report width on z/OS because the file is variable length and needs an additional four bytes to hold the actual length of each record instance. In other operating environments, the length of the record is the value of WPMIDWIDTH.

FORMAT WP retains headings, footings, and subtotals.

Use: For display in a text document.

Supported with the commands: HOLD, PCHOLD, SAVE.

Available in: WebFOCUS, Developer Studio, FOCUS.


Top of page

x
Reference: FORMAT XFOCUS

Description: Creates an XFOCUS data source.

Use: For further processing in a database application.

Supported with the command: HOLD.

Available in: WebFOCUS, Developer Studio, FOCUS.


WebFOCUS