Posted: Sat Mar 13, 2010 9:46 pm Post subject: what to do if bind fails as column is not in table
If a query is performed on a column which no longer exists in table then the code fails in bind stage.I want to know if i can still execute the bind sucessfully without including the deleted column then how can i do it.is there any bind jcl parameter that can be changed for doing so
if there is sql which references a column that nolonger exists in the table,
remove the column reference from the sql. _________________ Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum