5 Database Utilities

The DBUTIL utility

Introduction

Database changes are defined in a file using the DBUTIL script language. This makes it possible for a software vendor to provide a control script to a customer to perform database changes without manual interaction.

NOTE: The DBUTIL utility included with Eloquence A.06.00 is different than the one included with Eloquence A.05.xx. It does currently neither support database restructuring nor does it provide a dialog based user interface.

The following actions can be performed:

r Create or delete users, change user passwords

r Grant or revoke user properties

r Create or delete database specific access groups

r Grant or revoke group specific properties

r Assign users with access groups

r Grant or revoke data set specific access rights to an access group

DBUTIL commandline arguments

   usage: dbutil [options] file
   options:
    -help   = show usage (this list)
    -v      = verbose          (batch mode only)
    -e cnt  = abort processing after encountering cnt errors
    -t tmp  = where temporary files are stored
    -d flg  = set debug flags

-v[v]

Specifying the -v option will cause dbutil to output a summary of changes after analyzing the control file and some descriptive text during the database restructuring.

Specifying two -v options will cause dbutil to echo the control file to stdout as it is analyzed.

-e cnt

Abort processing the control file after encountering the given number of syntax or validation errors.

-t tmp

This option makes it possible to specify where temporary files will be created. If the -t argument is not specified, dbutil will allocate temporary files at the default location of the operating system.

-d flags

This is used internally to debug dbutil itself. You should not use this option.

file

The name of a script file to use by dbutil. Specifying the file name - will use stdin.

DBUTIL script file syntax

• Everything after a hash character (#) is considered a comment and will be ignored.

• dbutil does recognize keywords in either upper or lower case (but not mixed).

• Each statement must be delimited by a semicolon (;)

• The EXIT statement can be used to stop processing of a script file before the end of file is reached.

• Strings must be enclosed in double quotes. To include a quote character in a string, the quote character must be preceded by a backslash (\) character.

• A statement may span multiple lines.

• All keywords are given in upper case.

• Optional syntax elements are enclosed in brackets.