copyright 2007, information builders. slide 1 dn 9602 000.0001 walter f. blood information builders...

Copyright 2007, Information Builders. Slide 1

DN 9602 000.0001

Walter F. BloodInformation Builders

1

FOCUS 7.6 Product Update

‘Highway Blues’ from the “Speaking Out” albumMark Seales, composer; Ernie Watts, saxophone


FOCUS Release 7.6 Product UpdateParade of New Features

&DBMSERR&DBMSLIST

&FOCFEXNAME&VAR.QUOTEDSTRING? SET BY CATEGORY

? SITECODE20% CPU reduction

256 segments2K fieldname

32k alpha fields32k bytes in TABLE

ADABAS dynamic CALLTYPEAdabas FETCHJOIN and SQL NULL

Business ViewsBY Hierarchy WHEN SHOW

BY Hierarchy for non-cube filesCHECK DB

CHKINDEX, CHKLRECLCluster JOINs

Compound EXL2K documentsCOMPUTES in Master FileCREATE FILE with DROP

DATETIME format extensionsDATETRAN function

DB_LOOKUP functionDEFINE FILE * CLEAR

Dialog Manager decimal precisionDYNAM for HFS

EDIT nested in DECODEEXL2K Named Ranges

EXL2K Table of ContentsFaster COMPUTEs in MODIFY

Filters in masterFML INDENT

FML LISTFML raised limit for rows

FMLINFO CAPTIONFMLINFO FORLIST

FOC227 continues processingFOCEXEC width unlimited

FOCREPLAYGROUP ELEMENTS

HOLD FORMAT FOCUS 3x fasterHOLD FORMAT FOCUS extensions HOLD Format PPT for Powerpoint

HOLD FORMAT SAME_DB IF LIKE/UNLIKE

-INCLUDE fully qualified filenameJOIN 63 files

Long DDNAMESMATCH FILE increased limit

MODIFY for FIX filesMODIFY STOP DBMS ERRORS

MODIFY UPDATE on fix filesMulti-dimensional index (MDI)

Multi-field JOIN for FOCUS/FIX filesMultilingual DESCRIPTION and REMARKS

Multiple NLS TITLES in MasterMultiple TX fields in FIXFORM

ON TABLE SET BYPANELORACLE 10G supportOUTER JOIN support

PASSRECS for Adabas, IMS, VSAMPLUS OTHER

PUTDDREC, CLSDDREC functionsRNK.

SAVB FORMAT INTERNALSET ACROSSLINESET CDN=QUOTEP

SET CNOTATION = EXPLICITSET CNOTATION = PRINTONLY

SET DATEDISPLAY=COMP SET DEFECHO=ON/ALL

SET DMPRECISIONSET EMPTYREPORT=ANSI

SET ERROROUT=OVERRIDESET KEEPFILTERSSET MAXLRECL=64

SET MODCOMPUTE=NATVSET OPTIMIZATION = NOAGGR

SET PDFLINETERMSET PERMPASS DBASET SHOWBLANKS

SET SUMMARYLINES=EXPLICITSettable LRECL for HOLD files

STRREP functionStructured HOLD files

Summaries on ACROSS fieldsSystem &variables in DEFINEs

TX-to-alpha assignmentsUnlimited FOCSORTWHERE optimization

XFOCUS for FDSXIRR and MIRR functions


FOCUS 7.6 Product Update - Over 100 New FeaturesPERFORMANCE BOOSTERS101 20% CPU reduction102 Unlimited FOCSORT103 HOLD FMT [X]FOCUS 3x faster104 WHERE optimization105 Faster COMPUTEs in MODIFY

OUTPUT MECHANISMS201 Structured HOLD files202 BY HIERARCHY for non-cubes 203 Settable LRECL for HOLD files204 FMLINFO FORLIST/CAPTION205 HOLD FORMAT PPT206 SET ERROROUT=OVERRIDE207 FML INDENT, LIST208 ON TABLE SET BYPANEL209 SET EMPTYREPORT=ANSI210 SAVB FORMAT INTERNAL211 EXL2K Table of Contents212 EXL2K Named Ranges213 SET DEFECHO=ON/ALL

OPERATING SYSTEM301 FOCREPLAY302 DYNAM for HFS303 Long DDNAMES

TABLE REPORTING401 DATETRAN function402 PLUS OTHERS403 Summaries on ACROSS fields404 IF LIKE/UNLIKE405 SET KEEPFILTERS 406 BY Hierarchy WHEN SHOW 407 XIRR and MIRR functions408 EDIT nested in DECODE409 SET ACROSSLINE410 SET CDN=QUOTEP411 FOC227 continues processing412 SET SHOWBLANKS413 &VAR.QUOTEDSTRING414 -INCLUDE fully qualified filename415 Summary command combinations 416 SET SUMMARYLINES=EXPLICIT417 PUTDDREC, CLSDDREC functs418 STRREP function419 &FOCFEXNAME420 ? SET BY CATEGORY

INTERFACES501 HOLD FORMAT SAME_DB502 Cluster JOINs503 Oracle 10G interface504 SET OPTIMIZATION=NOAGGR505 &DBMSERR, &DBMSLIST

DATABASE and MASTER601 XFOCUS for FDS602 Filters in MFD603 Multi-dimensional index (MDI)604 Business Views605 HOLD FORMAT FOCUS Extens606 DATETIME format extensions607 System &vars in mfd DEFINEs608 GROUP ELEMENTS609 Multilingual TITLE,DESC,REMARK610 Multi-field JOIN for FOCUS/Fix files

RAISED LIMITS701 MFD with 256 segments 702 JOIN 63 files703 MATCH 16 files704 Dialog Manager decimal precision705 32k bytes in TABLE 706 32k alpha fields707 2k-long fieldnames

MODIFY/MAINTAIN801 Multiple TX fields in FIXFORM802 DB_LOOKUP function803 MODIFY of FIX files804 SET PERMPASS=DBA


FOCUS 7.6 Product Update - Over 100 New FeaturesPERFORMANCE BOOSTERS

OUTPUT MECHANISMS214 SET PDFLINETERM

OPERATING SYSTEM304 ?SITECODE

TABLE REPORTING421 SET CNOTATION = EXPLICIT422 SET CNOTATION = PRINTONLY423 DEFINE FILE * CLEAR424 NEXTR and HMASK for datetime425 .RNK suffix for ranking

INTERFACES506 Adabas dynamic CALLTYPE507 Adabas FETCHJOIN, SQL NULL508 PASSRECS for Adabas, IMS, VSAM509 IMS variable length segments510 DB2 foreign key support511 VSAM RRDS support

DATABASE and MASTER611 CHECK DB612 COMPUTES in MFD613 Outer JOIN support614 CHKINDEX615 CHKLRECL

RAISED LIMITS708 FML raised limit for rows709 LINREC/DATREC increase710 Read up to 64K record length711 32K-long amper variables712 FOCEXEC width unlimited

MODIFY/MAINTAIN805 CREATE FILE with DROP806 SET MODCOMPUTE = NATV


When it’s CPU charges!When it’s CPU charges!


Release 7.6


FOCUS 7.6 Product UpdateCPU Reduction

Average 20% faster than FOCUS 7.3 !!

New ‘C’ compiler for MVS and VM

Includes all new features of WebFOCUS 7.6

$ $ $ $ $ $ $ $


FOCUS 7.6 Product UpdateCPU Reduction

TestsLarge MODIFY Load

Large MODIFY UPDATE

REBUILD

Large TABLE SUM

Large TABLE WHERE

JOIN TABLE

MATCH

HOLD OUTPUT

MAINTAIN

TestsLarge MODIFY Load

Large MODIFY UPDATE

REBUILD

Large TABLE SUM

Large TABLE WHERE

JOIN TABLE

MATCH

HOLD OUTPUT

MAINTAIN

CPU Benchmark % of 7.6 Improvement

7.3.6 22%

30%

39%

7%

8%

18%

8%

44%

38%

7.3.6 22%

30%

39%

7%

8%

18%

8%

44%

38%

7.1.1 11%

23%

45%

16%

9%

13%

19%

47%

30%

7.1.1 11%

23%

45%

16%

9%

13%

19%

47%

30%

7.2.11 16%

26%

53%

16%

7%

10%

37%

37%

29%

7.2.11 16%

26%

53%

16%

7%

10%

37%

37%

29%

See White Paper for performance details

FOCUS 7.6 Product UpdateNew Product Performance Boosters

New WHERE optimizer

Faster COMPUTES in MODIFY

HOLD FORMAT [X]FOCUS redesigned, 3x faster

FOCUS 20% faster overall thanks to IBM/C compiler

Unlimited FOCSORT(>2gig, MORE, MATCH)

All ON by default


FOCUS 7.6 Product UpdateStructured HOLD FiIes

HOLD Files currently remove all structure

VSAM

FOCUSDB2

XFOCUS Oracle

VSAM DB2 Oracle

VSAM FOCUS XFOCUS

ON TABLE HOLD


FOCUS 7.6 Product UpdateStructured HOLD Files - Retain the Structure

Retains knowledge of one-to-many relationships of original file Use * to tailor field list with EXCLUDE

TABLE FILE PRINT A B C DIF C EQ 5ON TABLE HOLD FORMAT ALPHA

ON TABLE SET EXTRACT [ON or *]END

TABLE FILE PRINT A B C DIF C EQ 5ON TABLE HOLD FORMAT ALPHA

ON TABLE SET EXTRACT [ON or *]END

FOCUS Database

Plain HOLD File

A B C D

HOLD FORMAT optionsAlpha [X]FOCUS Binary

StructuredHOLD FileA

CB

D

C=5

A

CB

DE

Other SHF features will be added later


FOCUS 7.6 Product UpdateStructured HOLD Files - Move Data to the User

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

FOCUS 7.6 Product UpdateBusiness “View” of a Database

A VIEW into the original file – no new data, no separate extraction Reflect the business instead of physical field arrangement Have as many different Business Views as required. Direct via USE. BV recognized only for extract (TABLE[F], GRAPH, MATCH, MORE) JOIN a Business View to other files Limit the fields accessible in the main file, without DBA Make OS impose a View via security

MFDMFD

Business ViewOriginal

FILE=ORIG,SUFFIX=any

FILE=anyname,VIEW_OF=ORIG

FOCUS 7.6 Product UpdateBusiness “View” of a Database

FILE=ORIG, SUFFIX=FOC

SEGNAME=SEG1, …

FIELD=SOCSECNO, …

FIELD=NAME, …

FIELD=SALARY, …

SEGNAME=SEG2, PARENT=SEG1

FIELD=COMPANY, …

FILE=ORIG, SUFFIX=FOC

SEGNAME=SEG1, …

FIELD=SOCSECNO, …

FIELD=NAME, …

FIELD=SALARY, …

SEGNAME=SEG2, PARENT=SEG1

FIELD=COMPANY, …

FILE=BV, VIEW_OF=ORIG

SEGNAME=SEGMENT1

FIELD=FULLNAME,,BELONGS_TO=NAME,$

FIELD=SSN,,BELONGS_TO=SOCSECNO,$

FIELD=COMPANY,,TITLE=‘CO NAME’,$


SEGNAME=SEGMENT1




Rename/rearrange original fields without touching original fileEach Business View field relates (maps) to an original fieldTABLE with new field names translates to original names;

• attributes and relationships taken from original fieldNew DEFINEs permitted in Business View mfd

Business View omits SALARY

FOCUS 7.6 Product UpdateBusiness Views

SET FOCTRANSFORM = ON

TABLE FILE BV

PRINT FULLNAME BY SSN

END

SET FOCTRANSFORM = ON

TABLE FILE BV

PRINT FULLNAME BY SSN

END

Refer to field name in Business View Maps to field in original file BV supports TITLE to override original


SEGNAME=SEGMENT1





SEGNAME=SEGMENT1




Performs field mapping when different names are used.

Names the same? Turn OFF

FOCUS 7.6 Product UpdateSET DMPRECISION

Retain decimal places in Dialog Manager calculation resultsUp to 9 decimalsStored as characters, not internal decimal numbers

-SET &VAR1 = 1 + (2 / 3) ;

SET DMPRECISION = 5

-RUN

-SET &VAR2 = 1 + (2 / 3) ;

-TYPE VAR1=&VAR1 VAR2=&VAR2

VAR1=1 VAR2=1.66666

-SET &VAR1 = 1 + (2 / 3) ;

SET DMPRECISION = 5

-RUN

-SET &VAR2 = 1 + (2 / 3) ;

-TYPE VAR1=&VAR1 VAR2=&VAR2

VAR1=1 VAR2=1.66666

Don’t forget the –RUN !!

5 decimal places

FOCUS 7.6 Product UpdateGroup the Other Values Into One More Row

PLUS OTHERS creates one more row of all records that do not fall into the explicit rows displayed

Works with RANKED, IN-GROUPS-OF, IN-RANGES-OF Does not work with TILES, BY TOTAL)

TABLE FILE

PRINT OFFICE

BY HIGHEST 5 SALES PLUS OTHERSEND

TABLE FILE

PRINT OFFICE

BY HIGHEST 5 SALES PLUS OTHERSEND

Office Sales

ABC 10,000

MNO 6,000

DEF 9,000

JKL 7,000

GHI 8,000

PQR 5,000

VWX 3,000

STU 4,000

Office Sales

ABC 10,000

MNO 6,000

DEF 9,000

JKL 7,000

GHI 8,000

PQR 5,000

VWX 3,000

STU 4,000

10,000 ABC

9,000 DEF

8,000 GHI

7,000 JKL

6,000 MNO

12,000 OTHERS

10,000 ABC

9,000 DEF

8,000 GHI

7,000 JKL

6,000 MNO

12,000 OTHERS

Sum of 5000+4000+3000

SET DIRECTHOLD=ONNew load algorithm is 2-3 times faster

FOCUS 7.6 Product UpdateHOLD FORMAT [X]FOCUS – Faster + Extended Unique’s

TABLE FILE CAR BY COUNTRY

COMPUTE LONG1/A1024 = ‘A’;

COMPUTE LONG2/A1024 = ‘B’;

COMPUTE LONG3/A1024 = ‘C’;

COMPUTE LONG4/A1024 = ‘D’;

ON TABLE HOLD FORMAT FOCUS

END

TABLE FILE CAR BY COUNTRY

COMPUTE LONG1/A1024 = ‘A’;

COMPUTE LONG2/A1024 = ‘B’;

COMPUTE LONG3/A1024 = ‘C’;

COMPUTE LONG4/A1024 = ‘D’;

ON TABLE HOLD FORMAT FOCUS

END FILE=HOLD, SUFFIX=FOCUS

SEGMENT=SEG01, SEGTYPE=S1

FIELD=COUNTRY,,A16

FIELD=LONG1,,A1024

FIELD=LONG2,,A1024

FIELD=LONG3,,A1024

SEGMENT=, PARENT=SEG01, SEGTYPE=U

FIELD=LONG4,,A1024

FILE=HOLD, SUFFIX=FOCUS

SEGMENT=SEG01, SEGTYPE=S1

FIELD=COUNTRY,,A16

FIELD=LONG1,,A1024

FIELD=LONG2,,A1024

FIELD=LONG3,,A1024

SEGMENT=, PARENT=SEG01, SEGTYPE=U

FIELD=LONG4,,A1024

3088 bytes + pointers < 3986

Overflow into new segment

Adds Unique segments if over

~4K of data in parent segment --

No more FOC error message

FOCUS 7.6 Product UpdateHOLD into PowerPoint and Visual Discovery

GRAPH FILE CAR

SUM DCOST BY COUNTRY

ON TABLE HOLD FORMAT PPT

END

GRAPH FILE CAR


ON TABLE HOLD FORMAT PPT

END

Download as slide to pc and add to any PowerPoint presentation

TABLE FILE CAR


ON TABLE HOLD FORMAT VISDIS

END

TABLE FILE CAR


ON TABLE HOLD FORMAT VISDIS

END

Download data to pc and analyze in Visual Discovery

FOCUS 7.6 Product UpdateMulti-Lingual MFD Attributes

FILE=LANGUAGE ,SUFFIX=FOC SEGNAME=ACCOUNTS, SEGTYPE=S1 FIELDNAME=PERSON, PERS, FORMAT=A12

TITLE = ‘Name', TITLE_SP = ‘Nombre', TITLE_FR = ‘Nom', DESCRIPTION = ‘Name of Person’,DESCRIPTION_IT = ‘Nome di persona’ ,$

FIELDNAME= …

FILE=LANGUAGE ,SUFFIX=FOC SEGNAME=ACCOUNTS, SEGTYPE=S1 FIELDNAME=PERSON, PERS, FORMAT=A12

TITLE = ‘Name', TITLE_SP = ‘Nombre', TITLE_FR = ‘Nom', DESCRIPTION = ‘Name of Person’,DESCRIPTION_IT = ‘Nome di persona’ ,$

FIELDNAME= …

TITLEs and DESCRIPTIONs and REMARKs in alternate languages, built right into the master

Selected for use automatically, based on current code page (SET LANG=) Select two-character code from documented language list

TITLEs and DESCRIPTIONs and REMARKs in alternate languages, built right into the master

Selected for use automatically, based on current code page (SET LANG=) Select two-character code from documented language list

FOCUS 7.6 Product UpdateThe New SETs – SET ACROSSLINE=OFF

SET ACROSSLINE = OFFSET BYPANEL ON/n (new: ON TABLE)

SET CDN = QUOTEPSET CNOTATION = EXPLICITSET CNOTATION = PRINTONLYSET DEFECHO = ON/ALLSET EMPTYREPORT = ANSISET KEEPFILTERS = ONSET MAXLRECL = 64KSET MODCOMPUTE = NATVSET OPTIMIZATION = NOAGGRSET PERMPASS = passwordSET PDFLINETERM = SPACESET SHOWBLANKS = ONSET SUMMARYLINES=EXPLICIT? SET BY CATEGORY



SET ACROSSLINE=SKIP *

TABLE FILE CARSUM SEATS BY CAR ACROSS MODELEND

PAGE 1MODELMOD1 MOD2 MOD3

CAR- - - - - - - - - - - - - - - - - - - - - - - -

The underline goes away

Skip SETs

BMW 530I 3.0SI 2002 2DR

*ACROSSLINE=OFF shows blank line

FOCUS 7.6 Product UpdateThe New SETs – SET BYPANEL = ON/n





ON TABLE SET BYPANEL ON

TABLE FILE CARSUM COMPUTEWIDE1/A40 = ‘ABC’;WIDE2/A40 = ‘DEF’;BY CARON TABLE SET BYPANEL ONEND

PAGE 1.1 PAGE 1.2CAR WIDE1 CAR WIDE2- - - - - - - - - - - - - - - - - - - -

ABC DEFSort field remains on screen

Sort field remains on screen

PF11

FOCUS 7.6 Product UpdateThe New SETs – SET CDN = QUOTEP


SET CDN = QUOTEPSET CNOTATION = EXPLICITSET CNOTATION = PRINTONLYSET DEFECHO = ON/ALLSET EMPTYREPORT = ANSISET KEEPFILTERS = ONSET MAXLRECL = 64KSET OPTIMIZATION = NOAGGRSET PERMPASS = passwordSET PDFLINETERM = SPACESET SHOWBLANKS = ONSET SUMMARYLINES=EXPLICIT? SET BY CATEGORY


SET CDN = QUOTEPSET CNOTATION = EXPLICITSET CNOTATION = PRINTONLYSET DEFECHO = ON/ALLSET EMPTYREPORT = ANSISET KEEPFILTERS = ONSET MAXLRECL = 64KSET OPTIMIZATION = NOAGGRSET PERMPASS = passwordSET PDFLINETERM = SPACESET SHOWBLANKS = ONSET SUMMARYLINES=EXPLICIT? SET BY CATEGORY

SET CDN = QUOTEP

CDN = RESULT .

OFF 16,000.99

ON 16.000,99

SPACE 16 000.99

QUOTE 16’000,99

QUOTEP 16’999.99

Quote and period

FOCUS 7.6 Product UpdateThe New SETs – SET CNOTATION=EXPLICIT / PRINTONLY





SET CNOTATION = EXPLICIT

TABLE FILE CAR PRINT MPG NOPRINT SEATS/D4.1 RCOSTCOMPUTE WEIRD = C1 * C2; BY CAREND

CNOTATION = ALL (default)CAR MPG SEATS SEATS RCOST WEIRD

CNOTATION = EXPLICITCAR MPG SEATS SEATS RCOST WEIRD

CNOTATION = PRINTONLYCAR MPG SEATS SEATS RCOST WEIRD

Which columns are chosen?

Sort column is never counted

Redefine builds 2nd

column in matrix

FOCUS 7.6 Product UpdateThe New SETs – SET DEFECHO = ON / ALL





SET DEFECHO = ON/ALL

Default setting for ECHOSpans focexecs thruout session

SET DEFECHO=ON-RUN

-DEFAULT &ECHO=ALL

-SET &ECHO=ALL;

EX PROC123 ECHO=ALL

TABLE FILE CAR …

Force ECHO to ON unless overridden

locally

Local overrides

Local overrides

Local overrides

FOCUS 7.6 Product UpdateThe New SETs- SET EMPTYREPORT = ANSI





SET EMPTYREPORT = ANSI

TABLE FILE CARHEADING “HEADING”FOOTING “FOOTING”PRINT CAR MPG IF CAR EQ ‘XYZ’END

NUMBER OF RECORDS IN TABLE= 0 LINES= 0

PAGE 1 HEADING CAR MPG ------- -------

PAGE 1 HEADINGCAR MPG------ -------. FOOTINGNote the dot

and Footing

FOCUS 7.6 Product UpdateThe New SETs – SET KEEPFILTERS = ON





SET KEEPFILTERS = ON

Preserves activated FILTERS through a non-persistent session.

Applicable to WebFOCUS only

FILTER FILE fileFILT1 = boolean expression ;END

SET FILTER FILT1 IN file ONTABLE FILE file….

FOCUS 7.6 Product UpdateThe New SETs – SET MAXLRECL = 64





SET MAXLRECL = 64K

Maximum input file width was 32K including OCCURS clauses.

New maximum record length is 64K. But still can read up to 32K bytes of data from any one record.

FOCUS 7.6 Product UpdateThe New SETs – SET MODCOMPUTE = NATV





SET MODCOMPUTE = NATV

Activates the native MODIFY expression compiler

No need to recompile MODIFYs

Some expression components are not compiled

FOCUS 7.6 Product UpdateThe New SETs – SET OPTIMIZATION = NOAGGR





SET OPTIMIZATION = NOAGGR

Optimize JOIN’s and DEFINE’s

NOW, do not optimize SUM’s

Only for SQL engines

SQL DB2 SET OPT... = NOAGGR

FOCUS 7.6 Product UpdateThe New SETs – SET PERMPASS = password





SET PERMPASS = password

Only .PRF ?

FOCUS 7.6 Product UpdateThe New SETs – SET PDFLINETERM = SPACE





SET PDFLINETERM = SPACE

To transport a PDF via the specific ftp configuration of mainframe-thru-unix-to-pc.

Adds a space before delimiter.“STANDARD” is default.

Not for OCOPY users.

MAINFRAME

PC

Unixserver F T P

F T P

FOCUS 7.6 Product UpdateThe New SETs – SET SHOWBLANKS = ON





SET SHOWBLANKS = ON

Preserves leading blanks in HTML and EXL2K outputs by inserting multiple &nbsp’s (no backspace)

Preserves trailing blanks in headings/footings that use default alignment

FOCUS 7.6 Product UpdateThe New SETs – SET SUMMARYLINES = EXPLICIT





SET SUMMARYLINES = EXPLICIT

FOCUS 7.3 added SET SUMMARYLINES=ONto allow prefixes in summary

lines like:SUBTOTAL field1 MAX. field2

field3

Now, EXPLICIT allows • SUBTOTAL at one level, and• SUMMARIZE at another level

space

FOCUS 7.6 Product UpdateThe New SETs - ? SET BY CATEGORY





? SET BY CATEGORY

? SET BY CATEGORY? SET CATEGORY categoryname

C a t e g o r y N a m e sMEMORY DATES SECURITY POOLTABLE SINK SEND COMPUTATION MDI EXTERNALSORTFOCCALC

ENVIRONMENTWEBFOCUS

REPORTGRAPH

STYLESHEETRETRIEVAL

HOLDPLATFORM

MAINFRAMEMSWINDOWS


FOCUS 7.6 Product UpdateXFOCUS Database for Legacy FOCUS Applications

FOCUS DATABASE

4K page size

512 pages per partition

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 DATABASE

16k page size

1024 pages per partition

Up to 16-gig per physical file

Up to 255 16-gig partitions

Up to 4 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 partition

Reduced I/O

Fewer partitions

MODIFY keeps working!

-

-

-

-

-

-

-

-


FOCUS 7.6 Product UpdateXFOCUS Database Now Available on SU/FDS

All FOCUS syntax and capabilities work with XFOCUS files XFOCUS and FOCUS files can be COMBINED –

Use the page size appropriate for application XFOCUS can be MAINTAINed and MODIFY’ed XFOCUS files can be used on the Sink Machine –

Now also known as FOCUS Data Server (FDS)

The larger-than-2GB XFOCUS partition gives extended life to FOCUS applications

The larger-than-2GB XFOCUS partition gives extended life to FOCUS applications

FOCUS 7.6 Product UpdateHigh 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


MASTERNAME CAR DATANAME 'CARACX1 FOCUS M' DATANAME 'CARACX2 FOCUS M' DATANAME 'CARACX3 FOCUS M' MDILOCATION CARMDI

TARGET_OF ORIGINDIMENSION CAR DIMENSION COUNTRY MAXVALUES 100DIMENSION MODELDATANAME 'CARMDI MDI M'

FOCUS 7.6 Product UpdateMDI - Syntax

REBUILD MDINDEX creates new MDIs, or adds new partitions

to an existing MDI

REBUILD MDINDEX creates new MDIs, or adds new partitions

to an existing MDI

TABLE FILE CARPRINT BODYTYPE SEATSWHERE CAR EQ 'JAGUAR'WHERE COUNTRY EQ 'ENGLAND'END

Unlike RDBMS Clustered index, MDI fields can be in any order and all fields need not be used

ACCESS FILE


FOCUS 7.6 Product UpdateRaised FOCUS Limits

MATCH FILE 16 filesJOIN 63 filesFOCSORT Unlimited size, dynamic growthMASTER FILE 256 segmentsRECORD LENGTH Read up to 64KTABLE 32K bytes of displayed fieldsALPHA FIELDS 32K long each, TXT translationAMPER (&) VARS 32K long eachFIELDNAMES 2K long eachFOCEXEC WIDTH Unlimited width (use IEDIT to

edit)

MATCH FILE 16 filesJOIN 63 filesFOCSORT Unlimited size, dynamic growthMASTER FILE 256 segmentsRECORD LENGTH Read up to 64KTABLE 32K bytes of displayed fieldsALPHA FIELDS 32K long each, TXT translationAMPER (&) VARS 32K long eachFIELDNAMES 2K long eachFOCEXEC WIDTH Unlimited width (use IEDIT to

edit)


Maximum 2GB

FOC920: FOCSORT HAS REACHED ITS PAGE LIMIT

FOCUS 7.6 Product UpdateUnlimited FOCSORT

SYSTEM SORT

FOCSORT

Required forMulti-verb requestsACROSS or DST.

MATCH FILE Table MORE

No size limitation

FOCSORT limited by available disk space


FOCUS 7.6 Product UpdateDATETRAN 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 INVOICEEND

Alpha value -Maximum data size

Smart Date field only

Smart Date format

DATETRAN format

Language

INVOICE FMTDATE AMOUNT ------- ------- ----- 11111 Jan 4th 2005 $2,333.0011112 Feb 2nd 2005 $3,444.0011113 Mar 1st 2005 $4,555.00

INVOICE FMTDATE AMOUNT ------- ------- ----- 11111 Jan 4th 2005 $2,333.0011112 Feb 2nd 2005 $3,444.0011113 Mar 1st 2005 $4,555.00


FOCUS 7.6 Product UpdateBY HIERARCHY

For data that can be described as a parent/child hierarchy--

CHART OF ACCOUNTS

10000 ASSETS11000 xxxxxxx11100 xxxxxxx11200 xxxxxxx

CHART OF ACCOUNTS

10000 ASSETS11000 xxxxxxx11100 xxxxxxx11200 xxxxxxx

BILL OF MATERIALS

1A1A PART ASSEMBLY 22222 PART1 SUBASSEMBLY 1 PART1 DIV8786 PART1 SEP33333 PART1 SUBASSEMBLY 298765 PART 1 ABS PART 1 AMB

BILL OF MATERIALS

1A1A PART ASSEMBLY 22222 PART1 SUBASSEMBLY 1 PART1 DIV8786 PART1 SEP33333 PART1 SUBASSEMBLY 298765 PART 1 ABS PART 1 AMB

TIME

YEAR 2005 QUARTER 1 MONTH January DAY 1 DAY 2 . . . MONTH February

TIME

YEAR 2005 QUARTER 1 MONTH January DAY 1 DAY 2 . . . MONTH February

SALES ORGANIZATION

Eastern Sales RegionDistrict 1

Office New YorkOffice Boston

District 2Office WashingtonOffice Charlotte

SALES ORGANIZATION

Eastern Sales RegionDistrict 1

Office New YorkOffice Boston

District 2Office WashingtonOffice Charlotte

Intrinsic

Logical

Natural

Artificial



The parent/child hierarchy can be described in the Master

FILE=CENTGL ,SUFFIX=FOC SEGNAME=ACCOUNTS, SEGTYPE=S1 FIELDNAME=GL_ACCOUNT, ALIAS=GLACCT, FORMAT=A7, TITLE='Ledger,Account', FIELDTYPE=I, $ FIELDNAME=GL_ACCOUNT_PARENT, ALIAS=GLPAR, FORMAT=A7, TITLE=Parent, PROPERTY=PARENT_OF, REFERENCE=GL_ACCOUNT, $ FIELDNAME=GL_ACCOUNT_TYPE, ALIAS=GLTYPE, FORMAT=A1, TITLE=Type,$ FIELDNAME=GL_ROLLUP_OP, ALIAS=GLROLL, FORMAT=A1, TITLE=Op, $ FIELDNAME=GL_ACCOUNT_LVLNO, ALIAS=GLLEVEL, FORMAT=I3, TITLE=Lev, PROPERTY=LEVEL_NUMBER, REFERENCE=GL_ACCOUNT, $ FIELDNAME=GL_ACCOUNT_CAPTION, ALIAS=GLCAP, FORMAT=A30, TITLE=Caption, PROPERTY=CAPTION, REFERENCE=GL_ACCOUNT, $

FILE=CENTGL ,SUFFIX=FOC SEGNAME=ACCOUNTS, SEGTYPE=S1 FIELDNAME=GL_ACCOUNT, ALIAS=GLACCT, FORMAT=A7, TITLE='Ledger,Account', FIELDTYPE=I, $ FIELDNAME=GL_ACCOUNT_PARENT, ALIAS=GLPAR, FORMAT=A7, TITLE=Parent, PROPERTY=PARENT_OF, REFERENCE=GL_ACCOUNT, $ FIELDNAME=GL_ACCOUNT_TYPE, ALIAS=GLTYPE, FORMAT=A1, TITLE=Type,$ FIELDNAME=GL_ROLLUP_OP, ALIAS=GLROLL, FORMAT=A1, TITLE=Op, $ FIELDNAME=GL_ACCOUNT_LVLNO, ALIAS=GLLEVEL, FORMAT=I3, TITLE=Lev, PROPERTY=LEVEL_NUMBER, REFERENCE=GL_ACCOUNT, $ FIELDNAME=GL_ACCOUNT_CAPTION, ALIAS=GLCAP, FORMAT=A30, TITLE=Caption, PROPERTY=CAPTION, REFERENCE=GL_ACCOUNT, $



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



TABLE SYNTAX

SUM [FROLL.] measure_field ...BY hierarchy_field [ HIERARCHY

[ WHEN expression_using_hierarchy_fields ; ][ SHOW [ TOP | UP n ] [ TO { BOTTOM | DOWN m } ] [ byoption [ WHEN condition ] ...] ]

…[ WHERE expression_using_dimension_data ]…[ ON hierarchy_field HIERARCHY

[ WHEN expression_using_hierarchy_fields ; ][ SHOW [ TOP | UP n ] [ TO BOTTOM | DOWN m ][ byoption [ WHEN condition ] ... ] ]

SUM [FROLL.] measure_field ...BY hierarchy_field [ HIERARCHY

[ WHEN expression_using_hierarchy_fields ; ][ SHOW [ TOP | UP n ] [ TO { BOTTOM | DOWN m } ] [ byoption [ WHEN condition ] ...] ]

…[ WHERE expression_using_dimension_data ]…[ ON hierarchy_field HIERARCHY

[ WHEN expression_using_hierarchy_fields ; ][ SHOW [ TOP | UP n ] [ TO BOTTOM | DOWN m ][ byoption [ WHEN condition ] ... ] ]


FOCUS 7.6 Product UpdateACROSS Summarization

TABLE FILE GGSALESSUM UNITS DOLLARS BY PRODUCT BY REGIONBY DATEWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';ON DATE SUB-TOTAL AS 'REGION TOTAL'ON TABLE SUB-TOTALEND

TABLE FILE GGSALESSUM UNITS DOLLARS BY PRODUCT BY REGIONBY DATEWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';ON DATE SUB-TOTAL AS 'REGION TOTAL'ON TABLE SUB-TOTALEND

You know the effect of SUB-TOTAL on a BY field…

PRODUCT REGION DATE UNITS DOLLARS------- ------ ---- ----- -------Capuccino Northeast 1997/08/01 1473 19486

REGION TOTAL 1997/08/01 1473 19486.. REGION TOTAL 1997/12/01 1188 13668*TOTAL REGION Northeast 11551 144742.

PRODUCT REGION DATE UNITS DOLLARS------- ------ ---- ----- -------Capuccino Northeast 1997/08/01 1473 19486

REGION TOTAL 1997/08/01 1473 19486.. REGION TOTAL 1997/12/01 1188 13668*TOTAL REGION Northeast 11551 144742.



TABLE FILE GGSALESSUM UNITS OVER DOLLARSBY PRODUCT ACROSS REGION ACROSS DATEON DATE SUB-TOTAL AS 'REGION'ON TABLE SUB-TOTALWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';END

TABLE FILE GGSALESSUM UNITS OVER DOLLARSBY PRODUCT ACROSS REGION ACROSS DATEON DATE SUB-TOTAL AS 'REGION'ON TABLE SUB-TOTALWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';END

Now see the effect of SUB-TOTAL on an ACROSS field…

REGION Midwest West TOTAL MNTHPRODUCT NOV DEC REGION NOV DEC REGION ------- --- --- ------ --- --- ------ -----Capuccino UNITS . . . 2535 4051 6586 6586 DOLLARS . . . 31153 57421 88574 88574Espresso UNITS 2186 1752 3938 3088 3732 6820 10758 DOLLARS 27526 22281 49807 36123 51400 87523 137330 TOTAL UNITS 2186 1752 3938 5623 7783 13406 17344 DOLLARS 27526 22281 49807 67276 108821 176097 225904



TABLE FILE GGSALESSUM UNITS DOLLARS OVERCOMPUTE DOLLPER/I6 = DOLLARS/UNITS; AS 'UNIT PRICE'BY PRODUCT BY REGIONBY DATEWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';ON DATE SUMMARIZE AS 'REGION TOTAL'ON TABLE SUMMARIZEEND

TABLE FILE GGSALESSUM UNITS DOLLARS OVERCOMPUTE DOLLPER/I6 = DOLLARS/UNITS; AS 'UNIT PRICE'BY PRODUCT BY REGIONBY DATEWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';ON DATE SUMMARIZE AS 'REGION TOTAL'ON TABLE SUMMARIZEEND

You know the effect of SUMMARIZE on a BY field…

PRODUCT REGION DATE UNITS DOLLARS UNIT PRICE------- ------ ---- ----- ------- ----------Capuccino Northeast 1997/08/01 1473 19486 13

REGION TOTAL 1997/08/01 1473 19486 13..REGION TOTAL 1997/12/01 1188 13668 11*TOTAL REGION Northeast 11551 144742 12

PRODUCT REGION DATE UNITS DOLLARS UNIT PRICE------- ------ ---- ----- ------- ----------Capuccino Northeast 1997/08/01 1473 19486 13

REGION TOTAL 1997/08/01 1473 19486 13..REGION TOTAL 1997/12/01 1188 13668 11*TOTAL REGION Northeast 11551 144742 12



TABLE FILE GGSALESSUM UNITS DOLLARS OVERCOMPUTE DOLLPER/I6 = DOLLARS/UNITS; AS 'UNIT PRICE'BY PRODUCT ACROSS REGION ACROSS DATEON DATE SUMMARIZE AS 'REGION'ON TABLE SUMMARIZEWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';END

TABLE FILE GGSALESSUM UNITS DOLLARS OVERCOMPUTE DOLLPER/I6 = DOLLARS/UNITS; AS 'UNIT PRICE'BY PRODUCT ACROSS REGION ACROSS DATEON DATE SUMMARIZE AS 'REGION'ON TABLE SUMMARIZEWHERE DATE FROM 19970801 TO 19971231;WHERE PRODUCT EQ 'Capuccino' OR 'Espresso';END

Now see the effect of SUMMARIZE on an ACROSS field…

REGION Midwest West TOTAL MNTHPRODUCT NOV DEC REGION NOV DEC REGION ------- --- --- ------ --- --- ------ -----Capuccino UNITS . . . 2535 4051 6586 6586 DOLLARS . . . 31153 57421 88574 88574 UNIT PRICE . . . 12 14 13 13Espresso UNITS 2186 1752 3938 3088 3732 6820 10758 DOLLARS 27526 22281 49807 36123 51400 87523 137330 UNIT PRICE 12 12 12 11 13 12 12 TOTAL UNITS 2186 1752 3938 5623 7783 13406 17344 DOLLARS 27526 22281 49807 67276 108821 176097 225904 UNIT PRICE 12 12 12 11 13 13 13

REGION Midwest West TOTAL MNTHPRODUCT NOV DEC REGION NOV DEC REGION ------- --- --- ------ --- --- ------ -----Capuccino UNITS . . . 2535 4051 6586 6586 DOLLARS . . . 31153 57421 88574 88574 UNIT PRICE . . . 12 14 13 13Espresso UNITS 2186 1752 3938 3088 3732 6820 10758 DOLLARS 27526 22281 49807 36123 51400 87523 137330 UNIT PRICE 12 12 12 11 13 12 12 TOTAL UNITS 2186 1752 3938 5623 7783 13406 17344 DOLLARS 27526 22281 49807 67276 108821 176097 225904 UNIT PRICE 12 12 12 11 13 13 13

SUB-TOTALSUBTOTALSUMMARIZERECOMPUTE


FOCUS 7.6 Product UpdateCluster JOINS

JOIN fld1 IN DB21 TO fld1 IN DB22 AS J1JOIN fld2 IN DB21 TO fld2 IN DB23 AS J2JOIN fld3 IN DB21 TO fld3 IN CA-IDMS1 AS J3JOIN fld4 IN DB21 TO fld4 IN CA-IDMS2 AS J4JOIN fld5 IN DB21 TO fld5 INIMS AS J5

TABLE FILE DB21

DB23CA-IDMS2

CA-IDMS1

IMS

DB22

DB21

FROM:

Static JOINS among databases – relational / nonrelational


FOCUS 7.6 Product UpdateCluster JOINS

Static JOINS among databases – relational / nonrelational

TABLE FILE DB21

TO:Cross Reference Segments in MASTER SEGNAME=table2, [SEGSUF=branchsuffix,] SEGTYPE=relationship, PARENT=table1 [,CRFILE=crfile2][,$] FIELD=name,...,$

JOIN fields in ACCESS fileSEGNAME=DB21,TABLENAME=DB21,KEYS=1,$SEGNAME=DB22,TABLENAME=DB22,KEYS=1, KEYFLD=fld2, IXFLD=fld2,$

DB23CA-IDMS2

CA-IDMS1

IMS

DB22

DB21


FOCUS 7.6 Product UpdateFOCREPLAY

Test Your Interactive FOCUS Applications

IN BATCH !!

for MVS and VM

Quickly test a new FOCUS release or service pack-Test your critical interactive applications before your users get it.Test end-of-year reporting NOW against a new FOCUS release, or

a new operating system release, or a new database release.

Quickly test a new FOCUS release or service pack-Test your critical interactive applications before your users get it.Test end-of-year reporting NOW against a new FOCUS release, or

a new operating system release, or a new database release.

*Records session activity only when FOCUS controls the dialog; does not capture operating system interactivity.

Build scripts interactively*once, then run them in batch; Repeatable! Verifiable!Replays scripts at batch speed – no physical screen, no human interaction.Designed for simplicity - Just Allocate or Filedef, and run FOCUS – that’s it!Run it online up to any point, then step manually to vary testing scenarios.

Build scripts interactively*once, then run them in batch; Repeatable! Verifiable!Replays scripts at batch speed – no physical screen, no human interaction.Designed for simplicity - Just Allocate or Filedef, and run FOCUS – that’s it!Run it online up to any point, then step manually to vary testing scenarios.


FOCUS 7.6 Product UpdateHOLD FORMAT SAME_DB

TERADATADB2ORACLE

Do your HOLD files use different DBMS’s for Temporary Tables, depending on the source?

ORACLE DB2 TERADATA


FOCUS 7.6 Product UpdateHOLD FORMAT SAME_DB

Verb objects, sorts and COMPUTES included in Master File Keys created on BY fields Better than &variable substitution for dbms type PERSISTENCE determines type of file created -

• Permanent• Global Temporary• Volatile

TABLE FILE DB2FILEPRINT CURR_SAL AS ORIG_SAL COMPUTE NEWSAL/D12.2=CURR_SAL * 1.10; BY LAST_NAMEON TABLE HOLD AS NEWSALS FORMAT SAME_DB

PERSISTENCE VOLATILE END

TABLE FILE DB2FILEPRINT CURR_SAL AS ORIG_SAL COMPUTE NEWSAL/D12.2=CURR_SAL * 1.10; BY LAST_NAMEON TABLE HOLD AS NEWSALS FORMAT SAME_DB

PERSISTENCE VOLATILE END

FILENAME=NEWSALS, SUFFIX=SQLDB2,$ SEGNAME=NEWSALS, SEGTYPE=S0,$ FIELDNAME=LAST_NAME,ALIAS=LAST_NAME, USAGE=A10, ACTUAL=A10,$ FIELDNAME=ORIG_SAL,ALIAS=ORIG_SAL,USAGE=D12.2, ACTUAL=D8,$ FIELDNAME=NEWSAL,ALIAS=NEWSAL,USAGE=D12.2,ACTUAL=D8,$

FILENAME=NEWSALS, SUFFIX=SQLDB2,$ SEGNAME=NEWSALS, SEGTYPE=S0,$ FIELDNAME=LAST_NAME,ALIAS=LAST_NAME, USAGE=A10, ACTUAL=A10,$ FIELDNAME=ORIG_SAL,ALIAS=ORIG_SAL,USAGE=D12.2, ACTUAL=D8,$ FIELDNAME=NEWSAL,ALIAS=NEWSAL,USAGE=D12.2,ACTUAL=D8,$

Master

SEGNAME=NEWSALS, TABLENAME=NEWSALS,KEYS=1,$SEGNAME=NEWSALS, TABLENAME=NEWSALS,KEYS=1,$Access

FOCUS 7.6 Product UpdateSET ERROROUT=OVERRIDE

SET ERROROUT=OFF / ON / OVERRIDE/filename OFF (default) continues processing at the next control point ON stops processing – RC8 in &FOCERRNUM OVERRIDE/filename - alternative error handling for specific messages

1) Create override file as an ERRORS file (read at FOCUS startup)

2) Change selected errors to warnings, or warnings to errors

Syntax in file: error# E(rror) / W(arning)

Example: 205 E makes a FOC205

warning react like an error

SET may be placed in FOCPARM for site-wide applicability(Not permitted with ON TABLE SET)

FOCUS 7.6 Product UpdateGROUP Elements

FILE= SEGMENT= FIELD= GROUP=groupname, ALIAS=, FORMAT=A9, ACTUAL=A9 FIELD=field1,, A3,$ FIELD=field2,, A4,$ 9 characters FIELD=field3,, A2,$

GROUP=groupname, ALIAS=, FORMAT=A??, ACTUAL=A?? FIELD=field1,, A1,$ FIELD=field2,, D12.2,$ how many characters?? FIELD=field3,, I9,$

ELEMENTS=3

FOCUS 7.6 Product UpdateEven Dialog Manager Gets Better!!

&var.QUOTEDSTRING-SET &VAR1= ABCD; -SET &VAR2= 'AB‘ 'CD'; -TYPE &VAR1 &VAR2-TYPE &VAR1.QUOTEDSTRING &VAR2.QUOTEDSTRINGABCD AB'CD‘ABCD‘ 'AB‘ 'CD’

&FOCFEXNAME-INCLUDE TEST2

-TYPE &|FOCFOCEXEC = &FOCFOCEXEC

-TYPE &|FOCFEXNAME = &FOCFEXNAME

&FOCFOCEXEC = TEST2&FOCFEXNAME = TEST

-INCLUDE fully qualified filename

-INCLUDE ‘XYZ FOCEXEC B’-INCLUDE MYID.FOCEXEC.DATA(XYZ) -INCLUDE ‘c:\dir1\subdir2\xyz.fex’

System &’s in Master DEFINEs

FILE= SEGMENT= FIELD= DEFINE XYZ=&??? * 2 ;….

Need quotes?

After text is done, collect entire 4 boxes and add

transition:

Appear Wheel Fast 8-Spoke

Which vars?

FOCUS 7.6 Product UpdateFILTER in the Master File Description

FILE = filename SEGMENT = FIELD=FIELD1,, A3,$ FIELD=FIELD2,, A4,$ DEFINE DEFFIELD/A7 = FIELD1 | FIELD2 ; ,$

FILTER FILTFIELD = FIELD1 NE FIELD2; ,$

TABLE FILE filenamePRINT FIELD1 FIELD2 DEFFIELD

WHERE FILTFIELDEND

MASTER

FOCEXEC

Put your global filters into the metadata for general availability *

No operator, no expression

Filter format is I1

* Works independently of FILTER FILE syntax

Expression must resolve to 0 or 1

(false or true)

FOCUS 7.6 Product UpdateDB_LOOKUP in another data source

DB_LOOKUP ( infile, sourcefield1, lookupfield1,

sourcefield2, lookupfield2, returnfield )

Retrieve a value from a data source without JOIN or COMBINE

Use in DEFINE or COMPUTE

Match on as many field pairs as needed (up to 63)

If multiple matches, only first is returned

More efficient than using JOIN ????

SFLD1

SFLD2

SFLD3 LOOK1

LOOK2

LOOK3

RETURN

SFLD1 SFLD2 RETURN

B141 SCONE FOOD

F103 COFFEE POT GIFT

Lookup file

FOCUS 7.6 Product UpdateLoad Fixed Format Sequential Files

MODIFY FILE fixfile

FIXFORM …

MATCH …

ON NOMATCH INCLUDE

DATA …

… FILE=fixfile, SUFFIX=FIX, …

SEGMENT=…

Records are added to the end of the file INCLUDE only; UPDATE/DELETE not supportedEnables data types shy to HOLD FORMAT

INTERNAL

FOCUS 7.6 Product Update “RNK.” Prefix for RankingTABLE FILEPRINT FIRSTNAME RNK.SALARYBY YRS_SERVICE UNDER-LINE BY HIGHEST SALARY

WHERE TOTAL RNK.SALARY LE 2END

RANK YRS_SERVICE SALARY FIRSTNAME SALARY

15 $115,000 MOE 1

$92,000 LARRY 2

16 $99,000 CURLY 1

17 $87,000 SHEMP 1

$83,000 JOE 2RNK.field must be a BY field in the requestNot usable in IF/WHERE; only IF/WHERE TOTAL

FOCUS 7.6 Product UpdateSTRREP Function for Replacing Character Strings

TABLE FILEBY LASTNAME SUM CURR_SAL COMPUTE CS_ALPHA/A15=FTOA(CURR_SAL,’(D12.2M)’,CS_ALPHA); NOPRINT

CS_USD/A18=STRREP(15,CS_ALPHA,1,’$’,4,’USD ’,18,CS_USD);END

LASTNAME CURR_SAL CS_USD

CROSS $29,700 USD 29,700

IRVING $45,000 USD 45,000

SMITH $51,200 USD 51,200

STEVENS $99,000 USD 99,000

Supports replacing null strings too (…,0,’’,3,’ABC’,…)

Note blank

Replace ‘$’ with ‘USD’

FOCUS 7.6 Product UpdateLeft Outer JOIN

12

Venn Diagram

Inner JOIN

12

1Left Outer JOIN

JOIN [ LEFT_OUTER | INNER ] field IN hostfile TO crfield IN crfile

Same asSET ALL=OFF

Supports DEFINE-based JOINs

Supports Conditional JOINs

Same asSET ALL=ON

12

John Venn1834 - 1923

Venn Diagram

12

Inner JOIN

1Left Outer JOIN

JOIN [ LEFT_OUTER | INNER ] field IN hostfile TO crfield IN crfile

Supports DEFINE-based JOINs

Supports Conditional JOINs

Same asSET ALL=ON

Same asSET ALL=OFF


FOCUS 7.6 New Features

copyright 2007, information builders. slide 1 dn 9602 000.0001 walter f. blood information builders...

Documents

set modcompute

explicit set cnotation

quotep set cnotation

natv set optimization

ansi set errorout

comp set defecho

printonly set datedisplay

table set bypanel oracle