Kbase P133205: What is PRGRS_PREVALIDATE -Dsrv parameter for OE SQL Server DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/01/2009 |
|
Status: Unverified
GOAL:
What is PRGRS_PREVALIDATE -Dsrv parameter for OE SQL Server DataServer?
GOAL:
What is PRGRS_PREVALIDATE parameter?
GOAL:
Waht is -Dsrv PRGRS_PREVALIDATE?
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
OpenEdge 10.1C02
MS SQL DataServer
MS SQL
FIX:
Because of the architecture difference on how the SQL Server DataServer stores schema information on the OpenEdge client, SQL Server DataServer is able to utilize the schema information in advance of the bad write to the database to prevent the write from ever happening. Thus, in the case of SQL Server DataServer, you cannot rely on an OpenEdge trigger to correct a bad value before the server write executes.
The only way to resolve this is to not do error checking in advance of the write operation so the trigger would have a chance to correct the problem before the write took place. In order to turn off this expected behavior, a new -Dsrv parameter is introduced on OE10.1C02 and higher OE SQL Server DataServer for the customer who what to voluntarily turn off this feature to make uniform behavior in both the SQL Server DataServer and Oracle DataServer for the write trigger operation. By default the pre-validation is on as it is an expected behavior of the SQL Server DataServer. In order to disable the pre-write validation before trigger operation, you need to use the PRGRS_PREVALIDATE parameter with -Dsrv switch on the client startup as
-Dsrv PRGRS_PREVALIDATE,0