Appendix A: RIS Report Writer Environment Variables AA - 3
__________________________________________________________________________________________________________________________________________________
Appendix A
RIS Report Writer Environment Variables
This section lists the environment variables that can be used by RIS Report Writer.
DBA_AUTOCOMMIT Determines whether RIS Report Writer can turn
autocommit off. See the file
c:\win32app\ingr\risrpt\doc\autocomm.txt. Default = NO
DBA_BG_COLOR Specifies the background color for the raster display
when raster graphics mode is active. Default = 15
DBA_BLANK_PAD Controls whether report output lines are padded with
blanks to the length specified by columns per page. Default = NO
DBA_DEBUG Causes the script debugger to be automatically
activated upon startup. The command line switch -D can also be used.
DBA_BUTTON_SCRIPT Used to specify a script call when a button is pressed. See
c:\win32app\ingr\risrpt\doc\butkey.txt for more details.
DBA_CODE_SORT If YES, code lists are sorted by ascending code text.
If NO, code lists are sorted by ascending code number. Default = NO
DBA_CONVERT_INPUT Specifies a script call that converts column values input by the user before passing them to the database, so that the user can work with units other than those stored in the database. See
c:\win32app\ingr\risrpt\doc\convert.txt.
DBA_CONVERT_OUTPUT Specifies a script call that converts column values from the database for output on menus and reports, so that the user can work with units other than those stored in the database. See
DBA_DAP_FILE Defines the text file that is used to associate the report index number stored in a Displayable Attribute with the name of a report to run. There should be one report name on each line of this file.
DBA_DB_NUMBERS Controls whether table and column specifications in
dialog and report templates are written out as names (the default) or numbers (used in conjunction with mscolumns for schemas where table and column names will be translated).
DBA_DEBUG Causes the script debugger to be automatically
activated upon startup. The command line switch -D can also be used.
DBA_ERROR_LOG Redirects messages from the Errors Detected form to
the specified file.
DBA_FG_COLOR Specifies the foreground color for the raster display
when raster graphics mode is active. Default = 0
DBA_FORMS_COLORS Controls whether Native or Shamrock fields are used
(see doc/native.txt for details). 0 — fields are
Windows native controls unless the Field PLUS check box is selected from the Dialog Builder. 1 — fields are always Windows native controls. 2 — fields are always Shamrock custom controls.
DBA_FORMS_MODE Causes DM/DBA to take on the CLIX look-and-feel.
Setting this variable sets DBA_FORMS_COLORS and DBA_NATIVE_MODE to 2.
DBA_HL_COLOR Specifies the highlight color for the raster display
when raster graphics mode is active. Default = 4
DBA_INITIAL_SCRIPT Specifies a script function to execute when DB Access starts. This can be used to initialize global variables.
DBA_JOIN_TO_MANY Causes DB Access to process secondary selects on
outer and multi-schema joins when process query or universe review commands are issued to add duplicate rows caused by multiple hits in the secondary table. It increases processing times for these joins, and should be used only when one-to-many or many-to- many relationships exists. This flag is not necessary for standard, single schema joins or for any report joins.
Appendix A: RIS Report Writer Environment Variables AA - 5
DBA_KEY_SCRIPT Specifies a script call when a key is pressed.
See
c:\win32app\ingr\risrpt\doc\butkey.txt for more details.
DBA_LIB Set to the template library DBA will use initially.
Default = none
DBA_LIB_LIST List the template libraries to search when loading
templates Default = none
DBA_LINK_MODE Determines type of linkage to be written to graphic
elements by the Attach Linkage command, or read from graphic elements by the Review Element and Locate Graphics commands.
Set to RIS for eight-word RIS (user data) linkages, or DMRS for standard four-word DMRS linkages. Default = "RIS"
DBA_LOG_MESSAGE Causes DB Access to redirect all messages (normally
displayed in the message field or message gadget) to the file specified by the DBA_LOG_ERROR shell variable.
Default = NO
DBA_MCE_RESTRICT This environment variable exists, you cannot invoke
placement, manipulation, or subprocess commands, effectively making the design file read-only.
Default is unrestricted.
DBA_MENU Sets dialog template name that RIS Report Writer or
RIS Report Writer Runtime invokes initially. Default = none
DBA_MESSAGE_STRIP If NO, standard message strip is not displayed while
dialogs are processed. Default = YES
DBA_MSLINK Specifies his own MSLINK column, to be used in
linking database rows to MicroStation elements, or as a key column, or for DBA-driven incrementing of the key column upon inserts of new rows. The column must be an integer, and should be uniquely indexed. Default = mslink
DBA_NATIVE_MODE Controls whether Native or Shamrock fields are used (see doc/native.txt for details). 0 — fields are
Windows native controls unless the Field PLUS check box is selected from the Dialog Builder. 1 — fields are always Windows native controls. 2 — fields are always Shamrock custom controls.
DBA_NO_MSCATALOG Forces DB Access to build its table list from
RISTABLES instead of MSCATALOG even if it exists. Default = NO
DBA_NORMAL_TEXT Forces dialog text display style to be normal. Normal
text displays considerably faster under X Windows, especially on PCs.
Default = NO
DBA_NO_READ_LOCK NFS-mounted template libraries are not be locked
when reading (loading templates), if true. Useful for read-only sessions when NFS file locking is not desired. WARNING setting true may cause bad reads if other users are writing to the library. Default = NO
DBA_NO_SCALING Overrides automatic resizing of forms and dialogs
based on screen size and based on resizing and moving the main dialog.
Default = NO
DBA_NO_STOP Disables the STOP sign on the RIS Report Writer
message strip.
Default = NO (STOP sign enabled.)
DBA_OBJECT_LIB Specifies the template library that compiled script
objects are written to. If not defined, they are written to DBA_LIB.
DBA_OPTIMIZE Optimizes response for large databases.
See c:588ngr\risrpt\doc\optimize.txt for details and operational differences. Default = NO
DBA_OPTIONS The name of an options template, used for setting
active design options such as font name and body size, grid lock, color, line style, line weight, line depth, default CR mode, text justification, text style, verbose mode, text size, or lines and columns per report page.
Appendix A: RIS Report Writer Environment Variables AA - 7
DBA_PARTITION_BITS Determines the number of bits to be ignored in the occurrence number in DMRS linkages to partitioned entities on graphic elements (can be determined by using DMRS on the VAX DMRS database, LIST e.!, where e is the entity number, use the Partition Number value). Can also be used to mask out the reuse counter, if set to zero (0).
Default = 8
DBA_PAUSE Specifies an interval (in seconds) between inputs
when using the DBA_PLAYBACK_FILE option. Default is 1
DBA_PLAYBACK_FILE Specifies a file (created by DBA_RECORD_FILE) for
playing back all input from a previous RIS Report Writer session.
DBA_PLOT_QUEUE Provides a queue name for the plot command
whenever a Plot Window button is selected. Default = ilp811
DBA_PRINT Provides a format string for the print command issued
whenever a PRINT button is selected (the %s in the string is replaced with the filename).
Default = windows print dialog
DBA_RASTER Specifies the name of the raster graphics control file.
Previously this was done with the -d switch; this environment variable is now the preferred method. DBA_RASTER_PATH Specifies a default pathname to search for raster files,
this applies to the cosmetic and dynamic raster gadgets.
DBA_RECORD_FILE Specifies a file for recording all input in a RIS Report Writer session. This file can then be used in a subsequent playback session (see
DBA_PLAYBACK_FILE).
DBA_REPORT_MEMORY Used to preset report memory to be allocated so that
large reports do not fragment memory by repeatedly adding small chunks. Set it to the number of bytes required to store all rows in memory (# of report rows times bytes per row, as specified by the Error
allocating report memory ... error message). Default is 100000
DBA_REPORT_NULLS Causes DBA to print an error message whenever a
script or a numeric field references a NULL column value.
DBA_SCHEMA Set to the schema name DBA connect to initially. Default = none
DBA_SCHEMA_LIST Set to a string of schemas for multi-database joins.
Default = none
DBA_SCRAP Causes characters deleted from DBA fields to be put
on the EnvironV scrap (so they may be accessed by other I/Forms applications). Setting this variable slows down field editing noticeably.
Default = NO
DBA_SHELL Provides a command string for the SHELL button on
the DBA Message Strip. Default = "xterm -shell"
DBA_STORE_SCRIPT Causes DB Access to write a compiled script object to
DBA_OBJECT_LIB or DBA_LIB whenever a script is compiled. DB Access then reads this object in future sessions instead of recompiling the script again. Compiled objects are only read from
DBA_OBJECT_LIB or DBA_LIB. Default = NO
DBA_SUPPORT Sets to the DB Access support directories. (Only
necessary when using multiple support paths. Separate paths with colons).
Default = /usr/ip32/risrpt/support
DBA_SYNC_MENUS Causes DB Access to update all of the same table
when a menu’s current row is changed. Default = NO
DBA_TABLE_ORDER Lets you select order in which table lists are sorted. Default = mscatalog.entitynum (if mscatalog exists), or ristables.table_name (if mscatalog does not exist).
DBA_TEXT_SIZE Presets Report Builder and Output text size (1-5, from
the Text Size form). If this shell variable is not defined the default is 3.
DBA_TIMESTAMP_FORMAT Overrides the default input/output format for timestamp columns.
See
c:\win32app\ingr\risrpt\doc\timestamp.txt for format details.
Appendix A: RIS Report Writer Environment Variables AA - 9
DBA_TMP_OUTPUT When set, this flag causes all report output to be
placed in TMPDIR (usually /usr/tmp) with a unique name. This makes it easy to clean up report output as well as eliminating multiple user file conflicts.
DBA_TOPMOST Controls the window priority of DBA dialogs. If not
set, DBA dialogs are normal priority. If set, DBA dialogs are always on top of nontopmost windows. This is useful when running DBA from MicroStation.
DBA_USE_SERVER Forces all DBA RIS commands to be channeled
through a DBASRV connection. This option requires the -n <node> command line switch. It is useful to prevent DBA_NFM applications from creating an extra connection to the NFM database.
DBA_WRITE_ACCESS Set to YES for database write access, or NO for read-
only.
Default = YES
Certain global variables need only to be set to evaluate to true: DBA_AUTOCOMMIT DBA_BLANK_PAD DBA_CODE_SORT DBA_DB_NUMBERS DBA_OPTIMIZE For example: set DBA_DB_NUMBERS=
The equal sign (=) is required. You can also specify a value, such as:
set DBA_DB_NUMBERS=YES
If these environment variables are not exported, they default to NO.
The environment variable DBA_WRITE_ACCESS defaults to YES. You must set this variable to NOand export it to specify a condition other than the default. For example: