1
DN 9602 000.0001
Walter F. Blood Technical Director, FOCUS Division
Information BuildersFall, 2009
1
FOCUS in a WebFOCUS World: From FOCUS to WebFOCUS
2
From FOCUS to WebFOCUSFrom Many, One
Code merged FOCUS /WebFOCUS 7.6 Release
Common access via interfaces
WebFOCUSCommon functions based upon language
FOCUS
3
From FOCUS to WebFOCUSThe Same, Yet Different
WebFOCUS FOCUS
Interactive Web Batch/Interactive
Reporting based Transaction based
Graphic-rich Green-screen
Point-n-Click Editor based
4
DEVELOP
DEVELOP
From FOCUS to WebFOCUSFour Levels
WebFOCUS FOCUS
MAINTAIN
MAINTAIN
INTEGRATE
INTEGRATE
MIGRATE
5
From FOCUS to WebFOCUSMaintaining FOCUS Applications
For users who are maintaining existing FOCUS applications--
2. Operating system support and certification
3. Current application investment assurance
1. Continued support at their current FOCUS level
MAINTAIN
MAINTAIN
6
DEVELOP
DEVELOP
From FOCUS to WebFOCUSActive FOCUS Development
For users who are actively developing FOCUS applications--
EXL2K, PDFEXL2K, PDFDynamic reformattingDynamic reformatting
XFOCUS database and MDIXFOCUS database and MDI
New features to enhance the New features to enhance the development processdevelopment process
FOCLOGFOCLOGPerformance Improvement
7
From FOCUS to WebFOCUSDynamic Reformatting
COUNTRY RCOST DEALER_COST ENGLAND 32485 37853.0 FRANCE 3721 4,631 ITALY 39999 41235.00 JAPAN 5299 5512 W GERMANY 51895 $54,563.00
COUNTRY RCOST DEALER_COST ENGLAND 32485 37853.0 FRANCE 3721 4,631 ITALY 39999 41235.00 JAPAN 5299 5512 W GERMANY 51895 $54,563.00
DEFINE FILE CAR CFORMAT/A8 = DECODE COUNTRY('ENGLAND' 'F10.1' 'FRANCE' 'D10' 'ITALY' 'P10.2' 'JAPAN' 'I9' ELSE 'D10.2M'); END TABLE FILE CAR SUM RC0ST/F5 DEALER_COST/CFORMAT BY COUNTRY END
Dynamic
Static
F10.1
D10
P10.2
I9
D10.2M
8
From FOCUS to WebFOCUSXFOCUS Database Comparison Chart
FOCUS DATABASE 4K Page Size
Alpha fields up to A3964
Up to 2-Gig per physical file
Up to 255 2-Gig partitions
Up to ½ Terabyte total size
Segment names up to 8 chars
Index field names up to 12 chars
Page 1 contains FDT and data
XFOCUS DATABASE16K page size; 2X as many pages
Alpha fields up to A4096
Up to 16-Gig per physical file
Up to 1022 16-Gig partitions
Up to 16 Terabytes total size
Segment names up to 64 chars
Index field names up to 66 chars
Page 1 dedicated to FDT
More records per page
More pages per file
Larger files
Reduced I/O
Fewer partitions
TRUE DATA WAREHOUSE
9
From FOCUS to WebFOCUSXFOCUS – Replacing Legacy Files
FILE=filename, SUFFIX=FOCUS
SEGNAME=
FILE=filename, SUFFIX=FOCUS
SEGNAME=
FILE=filename, SUFFIX=XFOCUS
SEGNAME=
FILE=filename, SUFFIX=XFOCUS
SEGNAME=
Converting is easy!
Just REBUILD!
DUMP
LOAD
10
From FOCUS to WebFOCUSHigh Performance Multi-Dimensional Index – MDI
CARCAR
COUNTRYCOUNTRY
MODELMODEL
MDI provides virtually instant
access to the data you need
MDI provides virtually instant
access to the data you need
MDIs can have more than 3 dimensionsMDIs can have more than 3 dimensions
MDI has been in use for years in our FUSION
product
MDI has been in use for years in our FUSION
product
11
From FOCUS to WebFOCUSHigh Performance Multi-Dimensional Index - MDI
MASTER = CAR,$ DATA = ‘CARACX1 FOCUS M’,$ DATA = ‘CARACX2 FOCUS M’,$ DATA = ‘CARACX3 FOCUS M’,$ MDI = CARMDI , TARGET_OF = ORIGIN,$ DIM = CAR,$ DIM = COUNTRY,$ DIM = MODEL,$ DATA = ‘CARMDI MDI M’,$
ACCESS FILE
TABLE FILE CARPRINT BODYTYPE SEATSWHERE CAR EQ ‘JAGUAR’WHERE COUNTRY EQ ‘ENGLAND’END
Unlike RDBMS Clustered Index,MDI fields can be in any orderand all fields need not be used.
REBUILD MDINEXCreates new MDIs, or adds new partitions
to an existing MDI
12
FOCLOG – A New Product is Born
13
FOCLOG – A New Product is BornHow Does FOCLOG Work?
FOCUS Online User
FOCUS Online User
FOCUS Batch Job
FOCUS Batch Job
FOCUS Online User
FOCUS Online User
FOCUS Batch Job
FOCUS Batch Job
Memory MemoryMemory
Memory
LOG FILE(character flat file)
LOG FILE(character flat file)
FIN FINFIN
FIN
FOCLOG MFDFOCLOG MFD
FTP
Mainframe Analysis PC Analysis
MVS available now, VM coming shortly
14
FOCLOG – A New Product is BornUser Just Keeps On Going And Going And Going
“FOCLOG will never interfere with your session or job”
Log Full Log Not Accessible
Error writing
to log
Write contention
to logLog Full Log Not
AccessibleError
writing to log
Write contention
to log
Your session just keeps going and going and going …
15
FOCLOG – A New Product is BornAnalyze Activity Using WebFOCUS Tools
Dashboard, GraphicsDashboard, GraphicsWebFOCUS ReportsWebFOCUS Reports
Visual DiscoveryVisual DiscoveryExcel, HTML, PDFExcel, HTML, PDF
16
From FOCUS to WebFOCUSFOCLOG
LPAR 3 LPAR 4
LPAR 1 LPAR 2
FOCLOG
How much FOCUS usage?
17
FOCUSRelease 7.6
Up to 20% faster than FOCUS 7.3 !!
New ‘C’ compiler for MVS and VM
Includes all new features of
$ $ $ $ $ $ $ $
18
FOCUSRelease 7.6
Why switch compilers now?Recent compiler improvements by IBM
Remerged code with WebFOCUS in 7.2 and 7.3
Bonus – Absorb new features of
Why switch compilers now?Recent compiler improvements by IBM
Remerged code with WebFOCUS in 7.2 and 7.3
Bonus – Absorb new features of
19
Structured HOLD Files
20
Structured HOLD FiIesHOLD Flattens the Hierarchy
HOLD Files currently remove all structure
VSAM
FOCUSDB2
XFOCUS Oracle
VSAM DB2 Oracle
VSAM FOCUS XFOCUS
ON TABLE HOLD
21
Structured HOLD FilesNow Retain the Structure
Retains knowledge of one-to-many relationships of original file Structured data easily downloads off mainframe to WebFOCUS
TABLE FILE PRINT A B C DIF C EQ 5ON TABLE HOLD [ FORMAT HSA ]END
TABLE FILE PRINT A B C DIF C EQ 5ON TABLE HOLD [ FORMAT HSA ]END
FOCUS Database
Plain HOLD File
A B C D
HOLD FORMAT optionsHSA HSB HSX HREL HFOCHier Seq Alpha Hier Seq Binary Hier Seq Xml Hier Relational Hier Focus
StructuredHOLD FileA
CB
D
C=5
A
CB
DE
22
Structured HOLD FiIes Move Data to PC
Deliver structured mainframe data
to the pc for deeper analysis and
presentation via
Deliver structured mainframe data
to the pc for deeper analysis and
presentation via
A
CB
DE
23
Structured HOLD FiIes Content of the HOLD File
Structured HOLD file content is
Determined by structure of and relationships among the input files
Controlled with the FOCUS request syntax
TABLE FILE PRINT A.F1 B.F2 D.F3IF C.F4 EQ 5ON TABLE SET EXTRACT *FIELDS =ALL,$ENDEXTRACT ON TABLE HOLD FORMAT ALPHAEND
TABLE FILE PRINT A.F1 B.F2 D.F3IF C.F4 EQ 5ON TABLE SET EXTRACT *FIELDS =ALL,$ENDEXTRACT ON TABLE HOLD FORMAT ALPHAEND
A
CB
DE
24
DEVELOP
DEVELOP
From FOCUS to WebFOCUSActive FOCUS Development
For users who are actively developing FOCUS applications--
WebFOCUS features to enhance the WebFOCUS features to enhance the development processdevelopment process
StylesheetsStylesheets
FORECASTFORECAST
FML HierarchiesFML Hierarchies
25
From FOCUS to WebFOCUSStylesheet Enhancements
Cascading Stylesheets
Compound Reports in one PDF / PS file
GRID = ON / FILL / OFF
WRAP = ON / OFF
PAGECOLOR = color
STYLE = [+/-] UNDERLINESET
SET PSPAGESETUP = ON / OFF
SET STYLEMODE = PAGED
Row/Cell Borders With Style/Color
Stylesheet Macros
Conditional Styling
TOPGAP / BOTTOMGAP Around Report
Heading / Footing Element Alignment
Cascading Stylesheets
Compound Reports in one PDF / PS file
GRID = ON / FILL / OFF
WRAP = ON / OFF
PAGECOLOR = color
STYLE = [+/-] UNDERLINESET
SET PSPAGESETUP = ON / OFF
SET STYLEMODE = PAGED
Row/Cell Borders With Style/Color
Stylesheet Macros
Conditional Styling
TOPGAP / BOTTOMGAP Around Report
Heading / Footing Element Alignment
Styling capabilities of WebFOCUS are now in mainframe FOCUS
26
From FOCUS to WebFOCUSFORECAST - Prediction algorithms
TABLE FILE GGSALES SUM UNITS COSTBY CATEGORY BY PERIOD ON PERIOD RECAP MOVAVE/D10.1= FORECAST(COST, 1, 3, 'MOVAVE', 3);END
CATEGORY PERIOD UNITS COST MOVAVE-------- ------ ----- ------ ---------Coffee 01 61666 801123 801,123.0 02 54870 682340 741,731.5 03 61608 765078 749,513.7 10 57012 724412 703,545.0 11 51110 620264 691,667.7 12 58981 762328 702,334.7 13 0 0 694,975.6 14 0 0 719,879.4 15 0 0 705,729.9
CATEGORY PERIOD UNITS COST MOVAVE-------- ------ ----- ------ ---------Coffee 01 61666 801123 801,123.0 02 54870 682340 741,731.5 03 61608 765078 749,513.7 10 57012 724412 703,545.0 11 51110 620264 691,667.7 12 58981 762328 702,334.7 13 0 0 694,975.6 14 0 0 719,879.4 15 0 0 705,729.9
Forecast Field
Interval
Number of predictions
Method
Max number of points to average
Predictions beyond real data{
27
From FOCUS to WebFOCUSBY HIERARCHY
Use the simple BY HIERARCHY syntax --
JOIN SYS_ACCOUNT IN CENTGL TO ALL SYS_ACCOUNT IN CENTSYSF AS J1
TABLE FILE CENTGL SUM NAT_AMOUNT NAT_BUDGET BY GL_ACCOUNT_CAPTION HIERARCHY SHOW TO DOWN 3 ON TABLE SET STYLE * GRID=OFF,$END
JOIN SYS_ACCOUNT IN CENTGL TO ALL SYS_ACCOUNT IN CENTSYSF AS J1
TABLE FILE CENTGL SUM NAT_AMOUNT NAT_BUDGET BY GL_ACCOUNT_CAPTION HIERARCHY SHOW TO DOWN 3 ON TABLE SET STYLE * GRID=OFF,$END
PAGE 1 Month MonthCaption Actual Budget------- ------ ------ Profit Before Tax -320,109. -498,750. Gross Margin -4,146,295. -4,305,000. Sales Revenue -10,722,253. -10,605,000. Retail Sales -8,448,964. -8,400,000. Mail Order Sales -1,167,419. -1,155,000. Internet Sales -1,105,870. -1,050,000. Cost Of Goods Sold 6,575,958. 6,300,000. Variable Material Costs 4,957,331. 4,725,000. Direct Labor 1,072,250. 1,050,000.
PAGE 1 Month MonthCaption Actual Budget------- ------ ------ Profit Before Tax -320,109. -498,750. Gross Margin -4,146,295. -4,305,000. Sales Revenue -10,722,253. -10,605,000. Retail Sales -8,448,964. -8,400,000. Mail Order Sales -1,167,419. -1,155,000. Internet Sales -1,105,870. -1,050,000. Cost Of Goods Sold 6,575,958. 6,300,000. Variable Material Costs 4,957,331. 4,725,000. Direct Labor 1,072,250. 1,050,000.
INDENTON
LEVEL
TOP DOWN
3 LEVELS
28
From FOCUS to WebFOCUSDATETRAN Subroutine
For the ultimate control in date formatting Month and day translation Language Zero suppression and ordinal suffixes Date delimiters and punctuation
DEFINE FILE DTFILEDTDATE/YYMD = LEGACYDATE;FMTDATE/A15=DATETRAN (DTDATE,’(YYMD)’, ‘Btdo’,’EN’, 15, ‘A15’);ENDTABLE FILE DTFILEPRINT FMTDATE AMOUNTBY INOVICEEND
ALPHAMAXIMUM DATA SIZE
SMART DATE FIELD ONLY
SMART DATE FORMAT
DATETRAN FORMAT
LANGUAGE
INOVICE FMTDATE AMOUNT ------- ------- ----- 11111 Jan 4th 2005 $2,333.0011112 Feb 2nd 2005 $3,444.0011113 Mar 1st 2005 $4,555.00
INOVICE FMTDATE AMOUNT ------- ------- ----- 11111 Jan 4th 2005 $2,333.0011112 Feb 2nd 2005 $3,444.0011113 Mar 1st 2005 $4,555.00
29
From FOCUS to WebFOCUSHOLD into PowerPoint and Visual Discovery
GRAPH FILE CAR
SUM DCOST BY COUNTRY
ON TABLE HOLD FORMAT PPT
END
GRAPH FILE CAR
SUM DCOST BY COUNTRY
ON TABLE HOLD FORMAT PPT
END
Download as slide to pc and add to any PowerPoint presentation
TABLE FILE CAR
SUM DCOST BY COUNTRY
ON TABLE HOLD FORMAT VISDIS
END
TABLE FILE CAR
SUM DCOST BY COUNTRY
ON TABLE HOLD FORMAT VISDIS
END
Download data to pc and analyze in Visual Discovery
30
For users who are integrating FOCUS applications with WebFOCUS
INTEGRATE
INTEGRATE
From FOCUS to WebFOCUSIntegrating FOCUS and WebFOCUS
Existing features to enhance the Existing features to enhance the development process -Functionalitydevelopment process -Functionality
Heavy liftingHeavy lifting
FormattingFormatting
ServicesServices
31
For users who are integrating FOCUS applications with WebFOCUS
INTEGRATE
INTEGRATE
From FOCUS to WebFOCUSIntegrating FOCUS and WebFOCUS
Existing features to enhance the Existing features to enhance the development processdevelopment process
FOCUS Email OptionFOCUS Email Option
WebFOCUS Reporting AgentWebFOCUS Reporting Agent
32
From FOCUS to WebFOCUSMigrating FOCUS to WebFOCUS
For users who are migrating FOCUS applications to WebFOCUSM
IGRATEExisting features that enhance the Existing features that enhance the
migration processmigration process
Common FOCUS LanguageCommon FOCUS Language
Common Data InterfacesCommon Data Interfaces
Common codeCommon code
33
From FOCUS to WebFOCUS4th Degree - Migrating FOCUS to WebFOCUS
For users who are migrating FOCUS applications to WebFOCUS
MIGRATE
Existing features that require attention in Existing features that require attention in the migration processthe migration process
Interactive IssuesInteractive Issues
Execution IssuesExecution Issues
34
MIGRATE
From FOCUS to WebFOCUSLanguage Issues
Language Language IssuesIssues to Watch For to Watch For
--CRTFORMCRTFORM
PROMPTPROMPT
WINDOWWINDOW
HTMLHTML
XMLXML
SCRIPTSCRIPT
CRTFORMCRTFORMWINFORMWINFORM
35
MIGRATE
From FOCUS to WebFOCUSLanguage Issues
Language Language IssuesIssues to Watch For to Watch For
OS commandOS command
ALLOCATEALLOCATE
DYNAMDYNAM
OS RUNOS RUN
FILEDEFFILEDEF
SCRIPTSCRIPT
OS RUNOS RUN
OS commandOS command
APPAPP
36
MIGRATE
From FOCUS to WebFOCUSLanguage Issues
Language Language IssuesIssues to Watch For to Watch For
TALKTALKTechnologiesTechnologies
MODIFYMODIFY
TEDTEDFORECASTFORECAST
NOTEPADNOTEPAD
SCANSCAN
ANALYSEANALYSE
MAINTAINMAINTAIN
FSCANFSCAN
37
MIGRATE
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch ForExecution Issues to Watch For
38
MIGRATE
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch ForExecution Issues to Watch For
FOCUS
WebFOCUS
39
MIGRATE
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch ForExecution Issues to Watch For
Non-Persistent Connection IssuesNon-Persistent Connection Issues
DEFINE FUNCTIONDEFINE FUNCTION
DEFINEDEFINE
& and && variables& and && variables
SETSET
JOINJOIN
FILEDEFFILEDEF
40
MIGRATE
From FOCUS to WebFOCUSExecution Issues
Execution Issues to Watch ForExecution Issues to Watch For
Non-Persistent Connection IssuesNon-Persistent Connection Issues
-INCLUDE-INCLUDE
HOLD/SAVE filesHOLD/SAVE files
EXECEXEC
FILTERFILTER
41
DEVELOP
DEVELOP
MAINTAIN
MAINTAIN
From FOCUS to WebFOCUSFOCUS in the WebFOCUS World
WebFOCUS FOCUS
INTEGRATE
INTEGRATE
MIGRATE