Recent content by mmiles

The name of the FOCEXEC that you have the -INCLUDE in isn't the same name as the FOCEXEC you are including is it?

Case: 32261090 Product: MF Release: 706 Primary OS: MVS Date: 98/08/24 Case information refers to the Product, Release, and OS for which this question was asked. The solution may apply to other Products, Releases, and Operating Systems. Symptom: How to print a report that will contain...

Put a trailing comma at the end of each title to suppress under-lines under the headers. TABLE FILE CAR PRINT TYPE AS 'Type,' BY COUNTRY AS 'Country,' ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ ENDSTYLE END

(FOC1379) MAXIMUM STORED PROCEDURE PARAMETERS - %1%2%3%4 Maximum number of parameters allowed for Oracle stored procedure.

I goofed...try this (or something like it) instead. TABLE FILE CAR SUM TYPE BY COUNTRY ON COUNTRY PAGE-BREAK ON TABLE HOLD END -RUN DEFINE FILE CAR ADD TPAGE/I6 = &LINES; END SET PAGE=OFF TABLE FILE CAR HEADING "<TABPAGENO OF <TPAGE PAGES" PRINT TYPE BY COUNTRY ON COUNTRY PAGE-BREAK END

One last thing to try SET PAGE=NOPAGE

TABLE FILE CAR PRINT TYPE BY COUNTRY ON COUNTRY PAGE-BREAK ON TABLE HOLD END -RUN DEFINE FILE CAR ADD TPAGE/I6 = &RECORDS; END SET PAGE=OFF TABLE FILE CAR HEADING "<TABPAGENO OF <TPAGE PAGES" PRINT TYPE TPAGE BY COUNTRY ON COUNTRY PAGE-BREAK END

Why are you doing the define after the TABLE FILE request? This is code that I used to populate a drop down box. DEFINE FILE COMPANY OPTCOMPANY/A80 = '<OPTION VALUE="' | CMPY_NUMBER || '">' | CMPY_NAME; END TABLE FILE COMPANY SUM OPTCOMPANY BY CMPY_NAME NOPRINT &COMPWHER WHERE...

Syntax: How to Specify a Base URL SET BASEURL=url where: url Is the fully-qualified directory in which additional HTML files, graphics files, and Java applet CLASS files reside. The URL must begin with http:// and end with a closing delimiter (/). Example: Specifying a Base URL The...

Try SET PAGE=OFF or SET PAGE=NOLEAD.

Have you tried extracting data from both files and using MATCH FILE logic with the appropriate OLD-NOT-NEW, OLD-AND-NEW, etc.

Try setting the FONT size smaller via stylesheet commands. ON TABLE SET STYLE * TYPE=REPORT, SIZE=9,GRID=OFF, LEFTMARGIN=.25, RIGHTMARGIN=.25, FONT=COURIER, $ ENDSTYLE

There are certain commands (Dialog Manager) that need to have the hypnen. Other SET commands (non-Dialog Manager) do not require them.

DEFINE FILE CAR SUBA/I6 = 55; SUBB/I6 = 75; END TABLE FILE CAR PRINT SUBA SUBB COMPUTE PCT/D6.2 = ((SUBB - SUBA)/SUBB) * 100; BY COUNTRY ON COUNTRY RECOMPUTE ON COUNTRY SUB-TOTAL IF RECORDLIMIT EQ 5 END Returns PAGE 1 COUNTRY SUBA SUBB PCT ENGLAND 55 75 26.67 *TOTAL...

Are you using -SET ALL=PASS or SET ALL=PASS (without the leading hyphen?