I want to share one of mine recent experience on SQL -804 with SQLSTATE 7002. It a standalone COBOL/DB2 program with simple select from single db2 object with one predicate in WHERE clause.

There are some validation and padding is going for the predicate prior to invoke the sql exec. But it becomes really strange when invoking the SQL it provided the SQL error as mentioned which is really unusual for any kind simple SELECT execs for program which does not use SQLDA(using dynamic sqls). While doing RCA we found below point.

RCA :-

While RCA we found that the logic for padding the predicate variable is extending the memory location of WS and corrupting/over riding the SQLCA itself for which it gives the SQLDA error.

Hope it would help some others on digging. Also I think we need to have discuss on this on a forum for which posting.

Views: 256

Reply to This

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

DB2 Analytics Accelerator

User Groups

Blog Posts

IBM Db2 AI for z/OS and Db2 12 function level 503 available now!

Posted by Paul McWilliams on September 21, 2018 at 17:26 0 Comments


For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out…



  • Add Videos
  • View All

DB2 for z/OS APARS

PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service