Kbase P27858: Getting error 1006 when SDO is using a data logic procedure
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Getting error 1006 when SDO is using a data logic procedure and is working with temp-tables
Database <db> not connected (1006)
The non-db proxy SDO is calling non-db proxy of data logic procedure
CAUSE:
non-db proxy for SDO is not used by the client
FIX:
Add a reference to any database table in SDO, anywhere in the code, using {&DB-REQUIRED-START} and {&DB-REQUIRED-END}. This will make the client to run non-db proxy side of the SDO.
Example:
{&DB-REQUIRED-START}
FIND FIRST order NO-LOCK NO-ERROR.
{&DB-REQUIRED-END}
The data logic procedure must have all the database references between
{&DB-REQUIRED-START} and {&DB-REQUIRED-END}.
Create non-db proxy for data logic procedure similar to SDO:
/* datalogic_cl.p begins */
&GLOB DB-REQUIRED FALSE
{datalogic.p}
/* datalogic_cl.p ends */
Compile datalogic.p and datalogic_cl.p.