CODEWITHSUNDEEP
db2cobolmainframeserena
Sanyo Alexis
Sanyo Alexis

Reputation: 11

Bind in Promotion/Demotion of changeman package failing

I was trying to promote a COBOL program and the package in changeman. The BIND parameters in the package has QUALIFIER option in it. But while promoting I get the error "INVALID QUALIFIER SUPPLIED'

So I removed the QUALIFIER option from the BIND parameters and added and QUALIFIER in the SELECT query of the COBOL program. And when promoted it was successful. But when trying to demote, I get the same error which I got before i.e. BIND failed due to INVALID QUALIFIER supplied.

The qualifier used is a valid one in the DB2 subsytem I use. Is there any way to find out why the QUALIFIER is reported as invalid. Is it registered anywhere in SYSIBM tables may be ? I tried to query SYSIBM.SYSSCHEMAAUTH, but couldn't find any useful info. Can anyone shed some light on this.

Upvotes: 0

Views: 1221

Answers (0)

Related Questions