1 / 21

DN 9602 000.0001

FOCUS 7.7 Product Update. Walter F. Blood June, 2008. ‘Highway Blues’ from the “Speaking Out” album Mark Seales, composer; Ernie Watts, saxophone. DN 9602 000.0001. 1. FOCUS. Web. WebFOCUS. FOCUS. Coming in 7.7. FOCUS 7.7 Product Update Business view of a database. NU VIEW 4 U.

sven
Download Presentation

DN 9602 000.0001

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FOCUS 7.7 Product Update Walter F. Blood June, 2008 ‘Highway Blues’ from the “Speaking Out” album Mark Seales, composer; Ernie Watts, saxophone DN 9602 000.0001 1

  2. FOCUS Web WebFOCUS FOCUS Coming in 7.7

  3. FOCUS 7.7 Product UpdateBusiness view of a database NU VIEW 4 U • Business View limits read access to database based on business requirements • Defined in Master File • Standard FOCUS extract functionality applies. • Multiple views to file offers additional security

  4. FOCUS 7.7 Product UpdateCollation Support for Sorting and Filtering U-SET SORT FILTER 2! • SET COLLATION to handle case-insensitive data! • SET COLLATION to deal with special sort sequences! • SET COLLATION to move between ASCII and EBCDIC!

  5. FOCUS 7.7 Product Update FOCUS/XFOCUS now supports 1024 partitions 1024 MAX • FOCUS/XFOCUS databases now support up to 1024 partitions! • Maximum XFOCUS database reaches 16 Terabytes! • Maximum FOCUS database tops at 2 Terabytes.

  6. FOCUS 7.7 Product UpdateFile Concatenation Supported on SU SINKS LINKS • Longstanding limitation on the concatenation of datafiles on the sink being removed! • MAINTAIN to get new functionality • USE …ON … AS…OK!

  7. FOCUS 7.7 Product Update HOLIDAY File Now Supports FILEDEF Holiday Anywhere • HOLIDAY file no longer stuck in ERRORS • FILEDEF or ALLOC where you want! • Multiple versions easy to maintain!

  8. FOCUS 7.7 Product UpdateFOCUS/XFOCUS Interface with Unicode Support X/FOCUS UNICODE -IFICATION • New FOCUS/XFOCUS Interface provides full support for Unicode! • Ultimate solution for localization issues. • Unicode support includes collation, filtering, user functions.

  9. FOCUS 7.7 Product UpdateSorting with Variable sized Ranges All RANGES Not Equal • User defined RANGES available in IN-RANGES-OF grouping. • Range name also set-able. • IN-RANGES-OF <value1, label1> … <valuen, labeln>

  10. FOCUS 7.7 Product Update HOLDATTR to include DESCRIPTIONS in HOLD file DESCRIPTIONS TO THE HOLD FILES! • SET HOLDATTR will now include DESCRIPTIONS from Master Files in HOLD files. • New value to include Descriptions with TITLE and ACCEPT. • Available in WebFOCUS to tools using trees and POPUPDESC

  11. FOCUS 7.7 Product UpdateFOCUS TX fields support MISSING TX MISSING? • IS MISSING and IS-NOT MISSING now supported with TX fields. • Interface Varchars can be translated to TX or to AnV in HOLD. • Added to support of Alpha to TX and TX to Alpha conversion in DEFINE.

  12. FOCUS 7.7 Product UpdateSupport for Mainframe zIIP Processors zIIP-PI-DEE-DO-DA • FOCUS and WebFOCUS on Mainframe now make use of the zIIP engine. • Offload cpu cycles to cheaper processor • Help you control your software maintenance bills!

  13. FOCUS 7.7 Product UpdateNew JPTRANS Function to convert SBCS to DBCS New S.U.B.S. For D.B.C.S. • JPTRANS to convert between single-byte (SBCS) and double-byte (DBCS) • DEDIT to provide standard EDIT function for DBCS data. • DSUBSTR to give subtring capability to users with double-byte data.

  14. FOCUS 7.7 Product UpdateMAINTAIN supports FOCUS TX fields MAINTAIN TX! • MAINTAIN adding support for FOCUS TX fields. • Available for use locally and on SU.

  15. FOCUS 7.7 Product UpdateConditional Styling for BY Fields IF IT'S TUESDAY THIS MUST BE BELGIUM! • Conditional styling specifically for sort fields • Based on sort value, control display in graphs, pie charts, tables… • Complete styling capabilities

  16. FOCUS 7.7 Product UpdateNew Display for Accordian Reports COLUMNS 2 ROWS • New display option for single verb requests. • Requests using WITHIN to get new option to display sort columns as stacked rows.

  17. FOCUS 7.7 Product UpdateNew Multi-Verb presentation COLUMNS 2 RoWS - 2 • New SET for Multi-Verb requests to control layout. • Sort fields common to all verbs displayed as stacked rows rather than columns.

  18. FOCUS 7.7 Product UpdateStored Procedure Support for DB2 STORED PROCEDURES OPEN 4 BUSINESS • New FOCUS DB2 interface using CLI • Provides access to DB2 Stored Procedures • Master files generated dynamically on access through the interface.

  19. FOCUS 7.7 Product UpdateNew Subroutines Available SUBS DEBUT • PATTERN – translates field value to pattern of “A”,’a’,’9’ and others. • REVERSE -> ESREVER • Implementation of ISO standard week numbering in H subroutines

  20. FOCUS 7.7 Product UpdateDialogue Manager IN FILE IN FILE IN DM • Compare &Variable to list of literals stored in file. • Referenced with “IN FILE” syntax. • Use with –SET.

  21. FOCUS 7.7 Product UpdateThe Future of FOCUS The Future of FOCUS

More Related