skip to main content
OpenEdge Reporting: Query/Results for UNIX
Database Administration : Configuration options
Configuration options
The Language, Printer Setup, and Terminal Color Settings options on the Configuration menu let you establish the language, printer, and terminal device settings for your application.
One copy of Results can run in many different languages if RESLANG is installed with Results. Use the Language option to select the language version of Results for the current QC file. Then every time you start Results using this QC file, you see screens and messages in the language you choose (for example, German or French).
When Results starts, it searches the results.l file to find the language it should use. If there is no QC file built for the current database (or databases), it uses the default language specified in the results.l file for all system messages. If there is a QC file for the current database, Results uses the language specified.
You can edit your results.l file before you use the initial build to build the QC file with the default language you want. As Example 9–4 shows, you can change the following line in your results.l file.
Example 9–4: results.l
#edit the following line to set the default language for RESULTS
language= ’eng
You can access this file from the Progress Procedure Editor.
You can change the default option from eng (English) to any of the languages available on your system. The languages available on your system are listed in the results.l file. They also appear in a list on the screen when you select the Language option from the Administration module main menu. Multiple languages are only available if you installed RESLANG.
There are multiple versions for some languages (French and Greek) because these languages need to support different character sets. For example, French supports seven‑bit and eight‑bit character sets and Greek supports 928 and 437 code page versions. Be sure to select the appropriate language version.
Printer setup
Use the Printer Setup option to define output devices, such as TERMINAL, FILE, and PRINTER. You also use it to add new printer definitions. This section describes the menu choices listed in the Printer Setup option.
Add new output device
Use this to define a new output device. When you choose it, it prompts you for this information:
*Desc for listing — This is the prompt to select an output device. This is for display only.
*Device name — This is the logical system name of the output device. For example, the usual default system printer name for Windows is prn or lpt1 and UNIX is lp or lpr. If you are using the default printer, you enter those names here. If you are defining a terminal device, type in a terminal type from your Progress PROTERMCAP file, or leave it blank to use your current terminal settings.
*Maximum width — The maximum number of characters that the output device can print horizontally. Use this option to print reports wider than 80 characters. Reports will wrap if you output them to devices that are not wide enough to show all their information.
*Type — The type of output device, as selected from the Device Types list on the screen. You can enter one of the following:
*Term — This does an output to terminal paged. Use if the device you are adding is a terminal.
If wy60tw is a valid terminal type listed in your PROTERMCAP file, you can display output in the tall and wide format. For example, the text appears smaller and more columns of text fit on the width of one page. To setup a WYSE60 terminal for tall and wide format, enter wy60tw as the device name, and 132 as the maximum width.
*To — Use to send information directly to an output device, without sending it through a spooler or filter. For example, use this for DOS printer devices like LPT2 or LPT3 or to print directly to a UNIX device (bypassing a spooler).
*Thru — Use if you want your operating system to manage the information through a spooler or filter. This option is only supported when you run Results on an OS/2 or UNIX operating system.
Users enter the device name just as they would from the command line. For example, if you enter cat my-report | lpr -Plw, then use lpr -Plw as the device name. If you use lp -s -dlabel2 <report-x, then use lp -s -dlabel2 as the device name.
*View — Use if you want to send the output of a report, label or export definition to a file, and then automatically have an operating system access that file and display it on the screen. The operating system program is usually an editor or a listing program that lets you to scroll through the file. (You specify the program in the Device Name field). For example, you might use one of the following: the public domain utility list on DOS or view on UNIX. (These operating system programs are examples only. Use the appropriate commands for your system.)
If you need to run a program to print a file, you can use view instead of thru. For example, if you are on DOS and you want to print using the DOS spooler, you could use PRINT as the device-name.
Caution: PRINT must be run once before OpenEdge is started to install the resident portion, since PRINT is part TSR and part command.
*File — Use to prompt for the output destination filename. This option sends output to a text file. It also appends the output to an existing file. If the file already exists, Results prompts you to append to the file. If you do not append it, Results overwrites the file.
The default text filename is report.txt in the Reports module, label.txt in the Labels module, and export.txt in the Data Export module.
*Page—Use for enhanced output to a terminal where you can navigate around the screen using next page, prev page, and arrow keys. You can also scroll left and right to view wide reports. The output report appears on the screen with a box around it.
This option uses quoter, therefore the standard quoter utility must be in your PROPATH to use this option.
*Prog—Use to call a user’s program (u-print.p, for example). This passes the name of the generated program (report, data export, or label definition) and enables your program to determine the output destination. (Results includes the source code for a sample program called u-print.p.)
If you want to define your own printer menu, define only one output device and give it the type prog and set the device name to the name of the user print menu. When users select the Run option, your printer menu program runs and users do not see the default scrolling list of printer devices. See Chapter 10, “Integrating Results into Existing Applications,” for more details about defining your own print menu.
Choose device to edit
When you select this choice, a list of the currently defined output devices appears. After you select one of these, Results prompts you for the same information as in Add New Output Device field—the description, the logical name of the device, the width of the output in characters, and the device type as defined by the list on the screen. The existing values for the output device you selected appear as defaults.
General device characteristics
If you select this, Results prompts you for the same information as in Add New Output Device field—the description, the logical name of the device, the width of the output in characters, and the device type as defined by the list on the screen. For more information, see the “Add new output device” section.
Control sequences
Use this option to set printer control sequences. The Initialization field enables you to send a set of control sequences to the output device ahead of your information. Thus, you can control the format of your document. For example, you can change your document position from portrait to landscape, set margins, and add header and footer space. See your printer documentation to determine the control sequences you can use. The remainder of the fields in this option: Normal Print, Compressed, Bold ON, and Bold OFF, are reserved for future versions of Results.
Printer permissions
Select Printer Permissions after you use Add New Output Device or Choose Device To Edit to select the output device for which you want to set permissions. You set permissions by creating an IDLIST as described in the “Security options” section.
Delete current device
Use this option to delete any of the previously defined output devices.