-
Title
Getting ""ERROR [56038] [IBM][DB2] SQL0969N There is no message text corresponding to SQL error. -
Description
Several of my coworkers and I have started to encounter the following error in Toad for Data Analysts. When we attempt to edit table data (in the "Data" tab, after selecting "View Details" for a table), we sometimes receive the following error:
"ERROR [56038] [IBM][DB2] SQL0969N There is no message text corresponding to SQL error "-4700" in the message file on this workstation. The error was returned from module "DSNHSM2V" with original tokens "". SQLSTATE=56038"
This only occurs when attempting to edit data for certain tables. For any given table, we appear to either always receive this message or never receive this message.
-
Cause
In general, Toad does not support a z/OS subsystem running in Compatibility mode.
-
Resolution
If possible, switch the subsystem's operating mode to Full Function mode. If this is not possible, Toad now provides a message when you connect to subsystem, informing you of that the subsystem is running in compatibility mode and that some features might not be available.