Consultor Eletrônico



Kbase P150107: Suppressing the no-integrity warning message using single-user connections
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   7/28/2009
Status: Unverified

GOAL:

Suppressing the no-integrity warning message using single-user connections

GOAL:

How to suppress the warning "** This session is being run with the no-integrity (-i) option. (512)" when connecting single-user ?

FACT(s) (Environment):

Progress/OpenEdge Product Family
All Supported Operating Systems
OpenEdge Category: Configuration

FIX:

In some cases, such as maintenance or migration jobs, it is desirable to run processing on a database in single-user mode to keep processing time minimal. Running with no-integrity is an option to further improve performance.

When a client makes a single-user connection using both the -1 -i parameters, this will raise the error "** This session is being run with the no-integrity (-i) option. (512)" on the client.

This warning cannot be suppressed if the connection is made on the client's command line.

However, it can be suppressed if the connection is made within the ABL code, by using the CONNECT ... NO-ERROR option.
In that case the warning will be registered on the ERROR-STATUS handle like any other message that is being suppressed.