Descriptive SQL and DB Errors from Runtime

Idea created by WayneMorgan on Mar 14, 2018
    New
    Score8
    • DeerHunter
    • niconico
    • jeubeda
    • Dean_Eshleman
    • varun.chopra.2
    • CesarGHorna
    • AndyHebert
    • Reiner.Schatt

    When Processing SQL (or other databases) they provide diagnostic errors when DB operations Fail  - Although these are available with a lot of source code API's to interrogate - it would make more sense for the Runtime (for each language) pass the Error code and Text Description back from the DBmgr object and make available in the *Environment Variable - in addition to the Standard 'ERR' in the *Returned Status - the DB Runtime must already have this information when setting the 'ERR' so it should be faily easy to set the one of the *Environment  variables with the code and message 

    Ref Case  00959437