CA Datacom SQL External Procedure -533 S806 DBSQLP

Products

• Datacom
• DATACOM - AD
• Datacom/DB
• INFOCAI MAINTENANCE

Issue/Introduction

Executing a CA Datacom COBOL SQL external procedure gets error:

SQLCODE = -533, SQLSTATE=09S01
MESSAGE = TRIG SYSUSR.proc_name: ABNORMAL END - S806                                        


CEE3501S The module DBSQLP was not found.                                                                             
         From compile unit proc_name at entry point proc_name at compile unit offset +nnn at entry offset +nnn

Environment

Release : 15.1

Component : CA DATACOM SQL

Resolution

DBSQLP does not exist as a separate module, it is an entry point in module DBXPIPR. The linkedit has to include the following:

INCLUDE CEELIB(CEEUOPT)
INCLUDE OBJLIB(DBXHVPR)
INCLUDE OBJLIB(DBXPIPR)

The problem can also occur if the COBOL program has the DYNAM compile option.
It will cause a dynamic call at runtime for load module DBSQLP which doesn't exist so returns the S806.
Change to use the NODYNAM compile option instead so it will use the DBSQLP entry point in DBXPIPR.

Additional Information

See documentation section for Sample JCL