Drop and Dropall Commands Messages

The following messages appear in response to the DATABridge Client drop or dropall commands.

We recommend that you create a separate directory for each data source. When you need to drop a data source, make sure that the current directory is the directory where the script files reside and then use the drop command (not dropall) to drop each individual data source. This ensures that dbutility will be able to locate the required scripts.

Begin processing configuration file "name"

This message, which only appears if the -v option is enabled, confirms that the Client is reading the specified text-based configuration file.

Cleaning up table 'name'

This message indicates that the Client is deleting selective records from the specified table instead of dropping the table. This action is only taken in special cases, such as when tables that contain non-DMSII data are populated by the Client. The drop command cannot drop the table; instead, it removes all the records that the Client created.

Client exit code: dddd[(nnn)] - exit_code_text

This message displays when the command completes. On UNIX, the 8-bit exit code is shown only if it differs from the actual exit code.

Configuration information read from binary file "name"

This message, which only appears if the -v option is enabled, confirms that the Client has successfully read the specified binary configuration file.

Deleting control table entries for DataSource name

This message indicates that all of the client control table entries related to the specified data source are being removed.

Drop of all DATABridge tables successfully completed

This message indicates the following:

All tables for the various data sources defined in the client control tables have been removed from the relational database.

All of the corresponding scripts have been deleted from the current directory.

All of the client control tables have been removed from the relational database.

Drop of DataSource name partially completed

The drop/dropall command deletes all tables, stored procedures, and scripts for each table.

If no error occurs, the drop/dropall command proceeds to delete the client control table entries corresponding to the specified data source.

If an error occurs while deleting the client control table entries, the drop/dropall command continues trying to delete the client control table entries for the data source from the remaining tables. In this case, you must manually remove the remaining tables, stored procedures, and/or scripts, as well remove the corresponding entries in the client control tables.

Drop of DataSource name successfully completed

This message indicates that the tables and associated stored procedures for this data source have been removed, as well as the data source entry in the client control tables. In addition, scripts for this data source were deleted from the current directory.

Dropping control table 'name

This message is used by the dropall command to indicate that the client control table in question is being removed from the relational database in the final stages of the command.

Dropping table 'name'

This message, which only appears if the -v option is enabled, indicates that the specified table and its associated stored procedures are being removed from the relational database. This message is also used by the dropall command to indicate that the client control table in question is being removed from the relational database in the final stages of the command.

End processing configuration file "name"

This message, which only appears if the -v option is enabled, confirms that the specified text-based configuration file has been successfully processed.

Loading control tables for datasource

This message indicates that client control tables are being loaded for the data source that you specified (with the drop or dropall command).

Oracle version: major_vers.minor_vers

This message, which is only written to the log file when using Oracle client, shows the Oracle version.

Removing bulk load scripts for table 'name'

This message indicates that the script for launching bcp (load.table.cmd) and its associated bcp control file (bcp_table.ctl) are being removed from the current directory for the specified table.

Removing scripts for table 'name'

This message, which only appears if the -v option is enabled, indicates that the scripts for the indicated table are being removed from the current directory.

SQL Server version: major_vers.minor_vers

This message, which is only written to the log file when using the Microsoft SQL Server client, shows the SQL Server version. Note that SQL Server 2005 is version 9, SQL Server 2008 is version 10, and SQL Server 2008 R2 is version 10.5.

Starting drop of DataSource name

This message indicates that the drop (dropall) command has begun for the specified data source.