Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA Enterprise SCADA

TABLE OF CONTENTS

Database lister/loader

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedApr 24, 2025
  • 2 minute read

The dbll command allows you to print a list of the contents of a RealTime table to an ASCII text file or load a RealTime table with the contents of an ASCII input file. You can create an ASCII file of RealTime table configurations using any editor, work processor, spreadsheet, or database.

Prior to upgrading your system, you can create a list of the contents of all RealTime database (RTDB) tables and then immediately populate new RealTime tables. Listed RealTime data can also be passed to other 4GL packages.

Lister/loader options

With dbll, all inputs must be specified on the command line. Typing dbll in Windows PowerShell displays the options described below. The Lister/Loader on the hot RealTime service provides the following options:

Option

Description

template

This option is used to create a default template file.

flat

This option is used to create a flat file containing comma-separated data.

tabular

This option is used to generate a report-style output. The generated output can be used as input load file.

list

This option is used to generate a vertical list output. The generated list can be used as input load file.

load

This option is used to quickly load a table without data validation. This should be used only on a non-hot system.

safeload

This option is used to load a table with the contents of an input file.

Important: Exercise extreme caution when using the dbll safeload option on a live system. "Runtime" fields, such as the analog table's curspt field or the status table's lastKrunchTime field, should never be included in the ASCII data file. The file should include only configuration fields, such as the analog table's units field or the status table's run.doit field. Use of this utility should be limited to those with a thorough understanding of the system.

bulkfastload

Bulk load a database without performing validation. Same as load processing, except the bulk list of input (INIT, L) files is passed in.

bulklist

Lists databases that are specified in the bulk list file.

bulktemplate

Bulk dump a template for all specified databases. It is similar to the template option, except that the list of tables that the template file is generated from is specified through the bulk list file.

Notes: Unless some sort of a remote login tool is available, dbll should be run from a RealTime server.

The remote, connection and remconnjoin entries must be consistently updated when dbll is used. If you use dbll to save database contents, then modify the values in the files before using dbll to reload the values, you must ensure that:

  1. Any remote name change must be applied to the remconnjoin rname field for all remconnjoin records with the remote name.

  2. Any connection name change must be applied to the remconnjoin cname field for all remconnjoin records with the connection name.

  3. Any remote dataset change must be applied to all remconnjoin records with the remote name.

    Note: The Advanced Database Editor (ADE) is the recommended tool to use for changing remconnjoin data.