View Single Post
  #2 (permalink)  
Old 01-05-09, 17:21
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 4,258
A plan is not predefined for any specific objects, so I don't think that is your problem. You will need to post the structure from working storage that you are referencing in the SQL. You also need to post the DDL for the table.

I have never seen a space between the ":" and the variable name, but I suppose that is not the problem?
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote