Using Tokens in the Database Viewer Command Line

The Database Viewer is an external application that is started from the Vector AM Console using a Command Launch operation. Use the following tokens in the command line of command launch operations to pass information to the Database Viewer when it is launched.

$DSNNAME

The name of the ODBC DSN for the current Site

$DSNUSER

The username, if any, associated with database-level logon

$DSNPWD

The Password, if any, associated with database-level logon

$DSNACCESS

All of the above DSN information to identify the Site in the standard command format for the Database Viewer and SQLWizard.

$DATE

The current date in dd-mmmm-yyyy format (for example, 28-February-2004)

$DDMMYY

The date in dd-mm-yy format (for example, 28-02-04)

$MMDDYY

The date in mm-dd-yy format (for example, 02-28-04)

$YYMMDD

The date in yy-mm-dd format (for example, 04-02-28)

$TIME

The current time (for example, 10:59)

$NODE

The Client name.

$NODE(n)

Passes the first n characters of the Client name, where n is a number. For example, if you specify $NODE(5) and the Client name is ACCOUNTS1, then only ACCOU is passed as an argument.

$RESOURCE

A disk or share name of a Client PC.

$RESOURCE(n)

The first n characters of disk or share name.

$RSCUSER

The User name used to access a disk or share.

$RSCPASS

The Password used to access a disk or share.

$IPADDRESS

 The TCP/IP address (such as 90.0.0.40).

Related Topics

Generating HTML Reports Automatically

Starting the Database Viewer