Db2

 View Only

DB2 LUW community edition precompiler broken for target ibmcob

  • 1.  DB2 LUW community edition precompiler broken for target ibmcob

    Posted Mon November 01, 2021 09:02 AM

    I'm testing DB2 LUW Community Edition on Windows 64. I've noticed that the precompiler is generating invalid COBOL code when using Multi-Row Fetch cursors. Also DB2 itself appears to be broken in that when it does fetch using a multi-row fetch, the SQLERRD(3) always returns a value of 1 even though multiple rows were returned.

    I have been testing using the GNUCOBOL compiler which uses the underlying MinGW C compiler. I've also tested using GNUCOBOL built with the Visual Studio 2019 C compiler.

    I would be happy to share the sample DELET program which I've modified to use a multi-row cursor. Some manual modification are required after running the precompiler as it generates some invalid COBOL code which is fairly easy to correct.



    ------------------------------
    Charles Haatvedt
    ------------------------------

    #Db2