Troubleshooting
DatabaseBridge converts SQL errors to COBOL file status where applicable. For those errors that don’t correspond to any known COBOL file status, a 9D file status is returned. The extended information returned along with the status 9D provides error description.
It’s possible to know which SQL query has been used by DatabaseBridge along with the exit status by tracing the Framework SQL activity. This kind of trace is obtained by adding 256 to the value of
iscobol.tracelevel.
The following configuration, for example, traces environment settings, programs life cycle, i/o and SQL in a file named iscobol.log under /tmp.
iscobol.logfile=/tmp/iscobol.log iscobol.tracelevel=267 |