Spectrum Writer

Spectrum Writer is also a powerful format utility that extracts mainframe data and formats it any way you need it-- for PC programs such as Excel, Access, Lotus etc. Or, for use in Oracle databases or other ASCII-based platforms. Spectrum Writer can even format your mainframe data as HTML for immediate viewing on your Internet or Intranet site.

Spectrum Writer accepts existing COBOL and Assembler record layouts so no data dictionary is required. Designed for both programmers and end users, it uses a simple free-format language. Spectrum Writer gives you "SQL-like" access to every file in your company. Written entirely in fast, efficient assembly language it uses far less CPU than other report writers.

Spectrum Writer's features include:

• access multiple input files in a single run
• produce multiple outputs (reports and/or files) in a single run
• mix and match data from flat files, VSAM files and DB2 tables
• create your own new fields
• more than 50 built-in math, date, time and string functions
• computes statistics
• summarizes data
• full customization of the output's appearance
• unlimited number of control breaks supported
• reports wider than 132 characters supported
• prints bar graphs
• validates numeric data to avoid SOC7 ABENDs.
• PC-formatting feature reformats "non-PC-friendly" fields (such as packed, binary, and hex numbers, Julian dates, and bit fields). Spectrum Writer easily converts these fields to standard ASCII (or EBCDIC) formats that PC programs can use.
• accepts existing reports as input (and creates comma-delimited or HTML files)
• automatically converts output to HTML-formatted "web reports", if desired

Operating Systems: z/OS, OS/390, MVS, VSE

Pricing: Click here for z/OS pricing or here for VSE pricing.

Attention Mainframe Software Vendors! Spectrum Writer is the ideal choice for adding custom reporting and file export functions to your own product. Call us about OEM, VAR and bundling opportunities.