-805 SQL code in an IMS program calling DB2 module

srikar tenali · New User Joined: 07 Feb 2007 Posts: 22 Location: hyderabad

Hi All,

A batch IMS program(PROGRAM1) is calling a non-IMS, non-DB2 program(PROGRAM2). this is inturn calling a DB2 module(PROGRAM3).
This is executed using DFSRRC00 utility with DFSESL DD statements passed.
this is giving an SQLCODE -805 during execution of SQL statements in the DB2 module.
What all programs needs to be compiled with DB2 option yes and binded?
Or is this problem due to anything with passing plan details?

thanks in advance,
Srikar

pankaj_kulkarni111 · New User Joined: 17 Aug 2006 Posts: 13 Location: Pune

In this case try binding the package involved in the DB2 module, as -805 indicates timestamp mismatch for the package