HP ALLBASE/BRW (A.01.50) Software Update Notice For MPE/iX Systems ABCDE HP Part No. 35360-90204 Printed in U.S.A.
NOTICE The information contained in this document is subject to change without notice. HEWLETT-PACKARD PROVIDES THIS MATERIAL \AS IS" AND MAKES NO WARRANTY OF ANY KIND, EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
Contents 1. HP ALLBASE/BRW Software Update Notice Versions . . . . . . . . . . . . . . . . . . . . . . . . . . Product Update Overview . . . . . . . . . . . . . . . . . . Service Requests . . . . . . . . . . . . . . . . . . . . . . Documentation . . . . . . . . . . . . . . . . . . . . . . . Page Changes . . . . . . . . . . . . . . . . . . . . . . UPDATE PAGES . . . . . . . . . . . . . . . . . . . . . . Third-party Indexing . . . . . . . . . . . . . . . . . . . . Wildcard and Range Retrievals . . . . . . .
HP ALLBASE/BRW Software Update Notice This Software Update Notice describes the HP ALLBASE/BRW (Business Report Writer) release A.01.50 for MPE/iX. Functionality described in this Notice is available beginning with the A.01.50 Release. The information described in this Notice is NOT documented in the previous editions of the HP ALLBASE/BRW Reference Manual or the HP ALLBASE/BRW Tutorial . Note Pages from this Notice may be removed and inserted in the Reference Manual for your convenience.
Versions To use this release of HP ALLBASE/BRW, you must have at least version 4.0 of the MPE/iX operating system on the HP 3000. Do not attempt to install this release of HP ALLBASE/BRW under releases of MPE/iX earlier than 4.0.
Service Requests Responses to the following Service Requests (SRs) have been included in this release: Defect Fixes and Enhancements SR # Enhancements Description 1650-057539 1650-120501 9061-001206 D500-158337 D500-158345 D500-158352 D500-158766 no sr Be able to have a reduced report speci cation listing Add more details to the message \No data selected" Page numbers for 'Go to Page' function key of the Online Review Enhance compilation error to include the o ending ITEM and expression.
Documentation This Software Update Notice for A.01.50 has been added. The following part numbers and edition dates are the current numbers for this release: No existing manuals were replaced for this release. Customer Edition Order Number Date Title HP ALLBASE/BRW Reference Manual for MPE/XL HP ALLBASE/BRW Tutorial HP ALLBASE/BRW Software Update Notice for MPE/iX (MPE/iX Release 4.0) HP ALLBASE/BRW Software Update Notice for MPE/iX (BRW Version A.01.
Page Changes Here are the pages in the HP ALLBASE/BRW manuals that are a ected by this release: HP ALLBASE/BRW Reference Manual 6-20 6-23, 10-2, 10-3, 16-3, and 19-8 7-17 16-16 16-26 16-30 16-47 16-65 16-71 16-72 16-72 16-92 17-7 17-7 17-13 17-14 21-14 Third-party indexing feature added. New BRWSTOA utility provides more compact and simpli ed listing of BRW report de nition. Items and text can be enhanced with font changes, underlining, and boldface type using new escape sequence feature.
UPDATE PAGES The following pages can be used as a separate reference section or copies can be inserted in the HP ALLBASE/BRW Reference Manual or in the HP ALLBASE/BRW Tutorial . Each section of this Notice has a note describing which pages of the manuals are a ected by the new HP ALLBASE/BRW features.
Third-party Indexing As of MPE 4.0, HP supports a front end to third-party indexing (TPI) for IMAGE databases. TPI extensions allow any eld in any IMAGE database to support keyed access. In addition, the generic and keyword styles of keyed access provide greater exibility in keyed reads compared to IMAGE's hashed keyed access. This supersedes the information on page 6-20 of the HP ALLBASE BRW Reference Manual .
Examples of TPI Keyword Retrievals The following examples show TPI keyword retrievals: Selection Condition Parm Value (ship-date SATISFIES ?dateparm) dateparm = 04/@/93 (customer-name SATISFIES ?custparm) custparm ~smith or jones (SUBSTRING(order-no,1,3) SATISFIES ?parm1) AND (SUBSTRING(prod-no,4,2) SATISFIES ?parm2) parm1 = ABC,XYZ parm2 = UX,HP Result Return everything shipped in April, 1993 (assumes that dates are stored internally as YYYYMMDD or YYYY/MM/DD).
To enable TPI keyed reads on all new reports: 1. Start BRWSETUP. : BRWSETUP 2. Go to the Speci cation Values screen. 3. Place an X in the Enable Third Party Indexing eld. d a c b This screen is described on page 17-13 of the HP ALLBASE/BRW Reference Manual for MPE/XL . The Enable Third Party Indexing eld is new to this screen. To enable TPI keyed reads on a specific report only: 1. Start BRW. : BRWXL 2. Go to the De ne Report screen. 3. Place an X in the Enable Third Party Indexing eld.
d a c b To disable third-party indexing for a speci c report, remove the X from the eld. The De ne Report screen is described on page 16-26 of the HP ALLBASE/BRW Reference Manual for MPE/XL . The Enable Third Party Indexing eld is new to this screen. RSPEC les with third-party indexing enabled are not usable by versions of BRW/iX prior to A.01.50.
Execution Statistics The user can determine what, if any TPI generic or keyword reads were used by BRW through information provided by the execution statistics that are listed to the $STDLIST when the report is executed. To print execution statistics: 1. Start BRWSETUP and go to the Execution Values screen. 2. Type an X in the Print Execution Statistics eld. d a c b When the report is run, the execution statistics are listed to $STDLIST.
Examples of Execution Statistics If no TPI index was used for a particular dataset, the execution statistics look like this example: read-dset serial CUSTOMERS,TOYDB.PUB If a generic TPI key was used, BRW lists one or more itemname/parameter pairs, like this: read-tpi generic CUSTOMERS,TOYDB.PUB ZIPCODE = ?ZIPPARM The item name will be the TPI key, which may not be the same name as the associated IMAGE data item.
Using Laser Escape Sequences (SR D500-158345, SR D500-158352) Laser escape sequences let you format your BRW reports using standard printer commands for your printer. These commands include (but are not limited to) font changes, underlining, paper source, and paper orientation. This feature was not described in the HP ALLBASE/BRW Reference Manual for MPE/XL or in the HP ALLBASE/BRW Tutorial .
3. Associate the item name with a value for the printer escape sequence you want to use: Enter special symbols by using the listed text: Text Description ESC SI SO # escape code shift in shift out a place holder for a numeric code To nd the correct escape sequences for your printer, look in the printer reference manual. For instance, for escape sequences for the HP LaserJet III, see the LaserJet III Printer Technical Reference Manual .
To use escape sequences in a report: 1. Type the escape sequence name in the Item column of the De ne Lines screen. Pre x the name by an ampersand (&) as shown in the example below: d a c b The De ne Lines screen is described on page 16-6 of the HP ALLBASE/4GL Reference Manual . Using escape sequences in the Item column is a new feature. 2.
In the following example, notice the item name, &TYPEFACE(6): d a c b In the above example, the number 6 replaces the wildcard (#) in the escape sequence TYPEFACE (ESC '(s#T'). 3. Give the escape code a position, line, and length setting that covers the text or item you want to a ect by the code. In the previous example, for instance, &TYPEFACE(6) and &BOLD are placed so that they a ect the title, CUSTOMER REPORT, on line 2. Escape codes are designed so they can overlap other text or items.
To use the LASER option: 1. When you request the report, change the CCTL/NO/LASER eld to LASER by pressing the Prev Values or Next Values function keys. NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN d a c b NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN 2. Press Start Report . This screen is described on page 16-65 of the HP ALLBASE/BRW Reference Manual for MPE/XL . The functions described here are new.
The Online Review Screen (SR 9061-001206) The Online Review screen now shows line (or page) and column numbers and also allows you to \go to" a selected line or page. The following gure shows the Online Review screen for reviewing print les without CCTL codes (NO or LASER). Notice the prompt line (above the function key labels) that shows line and column numbers: d a c b (Notice that the Online Review screen does not have a screen name. All you see is the text from the report you are reviewing.
Print Device Default (SR D500-158766) The default value for the print device on the Execution Values screen in BRWSETUP is now extended so that any print device eld in BRW takes its value from the Default Print Device eld on this screen.
Compiler Error Messages (SR D500-158337) Most compiler errors can now display some context information about the location of an error. For instance: If an error happens in the Data Access portion of the report, the active Access File is referenced by the error message. If an error happens in the Layout part of the report, BRWCOMP reports the active lineset and line number at the time of the error. If the error occurs while evaluating a calc item, BRWCOMP reports the name of the calculated item.
Prompts for Modifying and Deleting (SR 9061-001305) HP ALLBASE/BRW now provides a prompt for saving changes to a report and a con rmation prompt when deleting a report. Modifying Report Prompt If you are working in one report and decide to open to another report, the following prompt is displayed: Current report modified. Do you want to save changes? Y (Y/N) The default is to save the changes. Press 4Enter5 to save. To abandon changes, type N and press 4Enter5.
Deleting Source Table Prompt If you change or remove the name of an existing source table, you see this prompt: Confirm deletion of source table TABLE_NAME Press F8 to cancel the deletion or con rm the deletion by pressing 4Enter5. Previously, no prompt appeared. This updates information on page 16-30 of the HP ALLBASE/BRW Reference Manual .
Improvements to VERIFY Function (no SR) The BRWXL.PUB.SYS program now gives full version availability information. This improvement assists developers who distribute BRW reports to a number of sites running di erent versions of BRW. NNNNNNNNNNNNNNNNNNNN The Verify function key on the Select Report screen now lists which versions of BRW are required to modify or execute a given report, along with a detailed list of any advanced features used in the report that require recent versions of BRW.
Additional Information on Use Items Screen (no SR) The Use Items screen now shows the data type options (N,S,I,D,T,R) and the length for string types. d a c b For instance, in the example above, CUSTOMER-NAME is a string data type, 30 characters in length. Data types are: N S I D T R numeric string integer date time real For more information about data types, see chapter 1 of the HP ALLBASE/BRW Reference Manual .
Improved RSPEC Lister with BRWSTOA (SR 1650-057539) This release introduces a new utility called BRWSTOA (\speci cation le to ASCII"). This utility provides a more compact and simpli ed listing of the BRW report de nition than you currently get with BRWLIST.PUB.SYS or than you get when you use the List Report key on the Select Report screen. NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN BRWSTOA is a new feature with this release and is not described in the HP ALLBASE/BRW Reference Manual for MPE/XL .
BRWSTOA Conventions for Lineset Definitions In the Lineset De nitions section of the BRWSTOA report, the following conventions apply: Text is treated as a pseudo item. The positioning information goes before the text, for example: TEXT 1,3 `Customer Name:' In this example, the text item is positioned in the rst column of line 1. The text itself is enclosed in single quotes. No length is given because the length of the text can be seen.
<<--------------------------------------------------------------------------->> << B R W R E P O R T L I S T I N G >> << CUSTREP2.WATSON.
JOIN ORDER-TABLE.PRODUCT-NO, PRODUCTS.PRODUCT-NO PROJECT ORDER-TABLE.CUSTOMER-NO, ORDER-TABLE.ORDER-DATE, ORDER-TABLE.ORDER-NO, PRODUCTS.PRICE, PRODUCTS.PRODUCT-LINE, PRODUCTS.PRODUCT-NAME, PRODUCTS.PRODUCT-NO, ORDER-TABLE.QUANTITY, ORDER-TABLE.SHIPMENT-DATE, PRODUCTS.TABLE-REC-NUMBER << << << << << << << << << << UNPROJECT ORDER-TABLE.PRODUCT-NO, PRODUCTS.QUANTITY, ORDER-TABLE.
BREAK LEVEL 3 BREAK ON ORDER-NO CALC ITEM ORDER-TOTAL: NUMERIC { PRICE * QUANTITY << This item finds the total value of an order by multiplying the price of the product by the quantity ordered.
ITEM PRICE 30, 1, 8 EDIT MASK 'ZZZZ9', '.
LINE SUPPRESS 6 { not (order-no = no_value) << Suppress this line, which warns if a customer has NO orders, if the customer has an order.
Index A absolute page position, 8-10 absolute position for break footing, 7-12 ABS, standard function, 15-58 ACCDEF le de ning Time and Date items, 18-40 access authorization HP ALLBASE/SQL tables, 14-7 access blocks, 6-26 access methods for data, 6-26 access sequence, 6-20 de ning, 6-27 for HP ALLBASE/SQL reports, 14-3 for join on HP ALLBASE/SQL, 6-11 for SQL tables, 6-27 Tune Access screen, 6-11 access sequence numbers HP ALLBASE/SQL, 14-10 ACCESS statements with Report/V, 22-4 account and group-level co
integrating reports, 12-19 BEGINPARMS, 11-14, 11-16 block mode, 20-3 PASCAL program, 20-5 body of the report job le, 11-21 boolean operations, 15-17 boolean operators, 15-18 boolean operators, exception value handling, 15-24 break footing absolute position, 7-12 break footing linesets, 7-16 break footings, 7-9 break heading linesets, 7-15 break headings, 7-9 repeating, 7-11 break level numbers, 7-5 BREAK-LEVEL, standard item, 15-60 break linesets, 7-15 breaks, 8-2, 8-4 change degree for, 8-6 BRWACCSD progra
calculating an item on another lineset, 7-34 calculation language special uses, 15-25 calculations, 15-2 arguments, 15-2 column, 7-26, 15-2 condition, 15-3 exception algorithm, 15-24 expressions, 15-2 formula, 15-4 function arguments in , 15-34 layout, 7-26 operator/operation, 15-3 resetting at break levels, 7-28 result type, 15-4 row, 7-32 row based on column calculations, 7-34 syntax rules for, 15-67 terms, 15-2 using source levels, 7-28 calendar date, 18-10 carriage control codes, S94-18 $CCTL, 20-19, 20
integer, 15-19 numeric, 15-19 real, 15-19 string, 15-19 time, 15-19 types, 15-19 conversion functions Standard Conversion Functions Table, 15-19 converting reports creating BRWDIC, 22-5 creating groups, 22-5 de ning Date and Time items, 22-5 de ning les and elements, 22-4 de ning passwords, 22-7 errors, 22-8 example, 22-14, 22-17 le lockwords, 22-7 incompatible features, 22-9 Inform/V, 22-3, 22-8 running BRWCONV, 22-5 sets, 22-6 translation rules, 22-11 using BRWCONV, 22-4 verifying item names, 22-4 COS, st
DAY OF MONTH, standard function, 15-21, 15-58 DAY OF WEEK, standard function, 15-21, 15-58 DAY OF YEAR, standard function, 15-21, 15-58 DAYS DIFF, standard function, 15-22, 15-58 DBASE, 12-12 DBEnvironments modifying, 14-10 multiple, 14-2 deadlocks, 17-9 decimals, 18-10 Default Date Item Edits screen, 17-20 Default Integer Item Edits screen, 17-19 Default Item Edits screens, 17-15 Default Numeric Item Edits screen, 17-17 Default Real Item Edits screen, 17-18 default report speci cations, 17-13 defaults exec
DICT option checking dictionary, 22-4 DIF le type, 16-51 Digit Extraction Function, 15-45 disk space freeing, 12-10 DIVIDE BY ZERO, 15-23 DIVISION parameter, 20-12 documentation, S94-4 DSG/3000, 12-12 dummy account, 18-7 duplicate key entries, 18-26 E editing text and items, S94-15 editing elds, 3-3 editing items, 7-17, 7-18 editing report job les, 21-6 editing standard job les, 21-6 edit masks, 7-19, 7-20 for date items, 7-23 for print numeric and integer, 7-21 in ACCSDEF le, 18-45 edit part of ACCSDEF le
EXP, standard function, 15-58 extensions HP System Dictionary, 18-17 F features of release, S92-1 eld editing, 3-3 le codes, 21-3 FILE command, 11-22, 18-16 le equations, 18-6, 18-7 when converting reports, 22-5 with dictionaries, 18-29 le layout Quoted BASIC (QB) les, 12-12 le lockwords converting reports, 22-7 le mnemonics, 21-3 FILENAME parameter, 20-14, 20-17 le names, 21-3 table , 21-3 les, 18-8 amending the standard job le, 11-10 ARRAYDEF and SYNDEF, 18-31 con guration, 21-4 con guration:transferring
HOUR OF, standard function, 15-58, 15-69 HOURS DIFF, standard function, 15-58, 15-70 HP 3000, 18-28 HP 3000 format, 18-21, 18-22, 18-27, 21-6 HP ALLBASE/SQL access sequence numbers, 6-20 data dictionary not needed, 18-2 open join example, 6-11 query example, 6-11 HP ALLBASE/SQL access authorization, 14-7 access sequence, 14-3 access sequence numbers, 14-10 keyed reads for, 14-3 names and datatypes, 14-10 NO VALUE, 14-12 NULL values, 14-12 passwords, 14-7 performance considerations, 14-10 system catalog, 14-
integrating reports with batch processing, 12-19 intermediate report les, 12-7 de ning, 12-5 multi-pass reporting, 12-4 REMPTY deletes all records from, 12-8 using, 12-7 intrinsics, 20-2 BRWCLOSE, 20-14, 20-23 BRW COMAREA, 20-18 BRWEXEC, 20-14, 20-22 BRWINFO, 20-14, 20-18 BRWINITREQUEST, 20-7, 20-8 BRWOPEN, 20-14, 20-17 BRWSTARTREQUEST, 20-3, 20-7, 20-10 BRWSTOPREQUEST, 20-7, 20-13 BRWSTREAM, 20-14 diagrams, 20-15 execution, 20-14 FILENAME parameter, 20-17 HP Desk, 13-3 request report, 20-6 transferring rep
L language support, 14-13 laser escape sequences, S94-15 laser printer codes, S94-18 laser printers printing options, S94-18 layout de ning, 7-2 functions, 15-4 source table changed, 18-65, S92-69 Layout Calc Item Formula screen, 7-33 Layout Calc Item Screen, 16-33 layout calculated item formula, 15-30 layout calculated items, 7-32, 15-29 de nition, 15-2 formula, 15-29 formula screen description, 16-36 Performance Notes, 15-30 restrictions, 15-29 row calculations, 7-33 screen description, 16-35, 16-84 Layo
MONTHS DIFF, standard function, 15-22, 15-58 MPE les, 14-2, 18-14 sequential and relative, 18-27 transferrring reports, 21-14 MPE login, 4-2 MPE or KSAM les, 21-6 MPE V operating system, 21-2 MPE XL operating system, 21-2 multi-pass reporting, 12-2, 12-3 column calculations, 12-4 dictionary output les, 12-4, 12-9 intermediate report les:, 12-4 output les, 12-4 quoted BASIC les, 12-4 multiple BRWDICs, 18-6 multiple data dictionaries, 18-5 multiple HP ALLBASE/SQL DBEnvironments, 14-2 multiple open joins, 6-8
MATCHES, 15-49 MOD, 15-49 NOT, 15-49 Operators Table, 15-49 OR, 15-49 SATISFIES, 14-12, 15-49, 15-53 tilde, S94-9 ordering manuals, S94-4 OR operator, 15-49 other keys function key, 3-4 $OUTPRI, 20-19, 20-22 output les, 12-2, 12-4 multi-pass reporting, 12-4 sending with HP Desk, 13-8 to remove the use of, 12-6 using, 12-14 Output File screen, 12-10, 12-17, 16-48{53 OVERFLOW, 15-23, 18-21 overlays de ning, 18-28 overview of this update, S92-1 P packed numeric, 18-9, 18-21 page absolute position, 8-10 length
print device default, S94-23 print execution statistics, 17-10 Print Execution Statistics eld, S94-13 print le temporary RPRINT le, 18-5 print le parameter, 11-22 printing array items, 7-17 printing a zero number, 7-22 printing options, S94-18 to use a laser printer, S94-18 printing parameters, 7-17 printing report speci cations, 17-28 printing values as bar graphs, 15-55 priority of arguments, 15-6 process info, 20-9 set by prior call to BRWINITREQUEST, 20-11 projecting items, 6-21, 6-22 Project Items sc
report heading lineset, 7-13 report job le, 20-14, 20-17 body, 11-21 header, 11-14 parameters in header, 11-21 report job les, 11-11, 20-6, 21-7 editing, 21-6 parameters, 11-11 transferring reports, 21-8, 21-15 report layout de ning, 7-2 report linesets, 7-10 reports bundling, 12-3, 12-16 compiling, 10-2, 16-3 consolidating (bucketing), 7-41 converting, 22-4 creating, compiling and executing HP ALLBASE/SQL reports, 14-3 creating, overview, 5-2 for pre-printed forms, example, 7-43 requesting, 13-9 requesting
Default Real Item Edits screen, 17-18 Default String Edits screen, 17-16 Default Time Item Edits screen, 17-21 De ne Breaks, 7-45 De ne Breaks and Pagination, 8-3 De ne Esceape Sequence, S94-15 De ne HPDesk Con guration, 16-12 De ne Lines, S94-17 De ne Lines for report heading, 7-13 De ne Lines screen, 7-3, 7-18 De ne Lines screen for page footing, 7-46 De ne Lines screen for page headings, 7-10 De ne Lines screen for report footing, 7-14 De ne Lines softkeys, 7-3 De ne Relation, common item example, 6-11 D
automatic upgrade, 18-66, S92-70 manual upgrade, 18-66, S92-70 Speci cation Values screen, 17-13, S94-11 splitting across page boundries, 8-9 splitting the report with HP Desk, 13-6 SQL data dictionary not needed, 18-2 SQL databases, 21-8 SQL les, 21-8 SQL transaction isolation level, 14-3 SQR, standard function, 15-58 SQRT, standard function, 15-58 standard deviation, 15-57 Standard Functions, Summary of, 15-58 standard items, 15-59 PAGE and LINE, 7-38 standard job les, 20-14, 20-17, 21-4, 21-7 amending, 1
example, 15-28 formula, 15-28 Performance Notes, 15-30 restrictions, 15-27 screen, 15-28 screen description, 16-82 table function formula screen, 15-32 screen description, 16-86 table functions example, 15-31 restrictions, 15-31 screen , 15-32 screen description, 16-37{85 what is, 15-4, 15-31 table lock mode HP ALLBASE/SQL, 14-8 table owner with HP ALLBASE/SQL, 14-7 TABLE-REC-NUMBER, 6-29 tables de ning for HP ALLBASE/SQL, 14-3 HP ALLBASE/SQL table, open join example, 6-11 nested, 6-8 owner name for HP ALLB
for HP ALLBASE/SQL tables, 14-4 tuning data access, 6-26 turnover, 18-60 typeface, S94-15 U UDCs, 18-6 underlining, S94-15 UNIQUE attributes, 18-26 UNIQUE, extension to System Dictionary, 18-17 UNIQUE KEY item options, 18-60 update overview, S94-2 update pages, S94-7 updates, S94-2 upgrade speci cation les when BRWDIC changed, 18-66, S92-70 upshift, 20-20 Use Items screen, S94-31 $USER, 20-19, 20-20 user-de ned dictionary, 18-2 BUILD statement, 18-61 creating the BRWDIC, 18-64, S92-52 REDEFINED statement,