SQLCODE IN GLOBDATA

Products

• Gen
• Gen - Workstation Toolset
• Gen - Host Encyclopedia
• Gen - Run Time Distributed

Issue/Introduction

We have a Gen program which we call from a started task. GLOBDATA is initiated with SPACES.  We want to evaluate the result from the called action block.

We extract the SQLCODE from the SQLCA area and want to display it, but it does not show. What needs to be done to display it?  

Environment

Release: KGNDDL99000-8.5-Gen-DBP Developer License
Component:

Resolution

The SQLCODE from the SQLCA area doesn't show since it is stored binary.

To be able to display it, you must apply formatting on the SQLCA area. The SQLCODE can be found as an integer (4 bytes) starting at position 13 in the SQLCA area.