Hi , When I issue BInd with explain(YES) getting the following warning :
DSNX105I -DBD9 BIND SQL WARNING
USING abcde AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=pg1000
STATEMENT=700
SQLCODE=220
SQLSTATE=01546
TOKENS=FUNC_VERSION.fghi.DSN_FUNCTION_TABLE
I had check the error code 220 and the explanation is 'An error occurred during the insertion of a row into an optional explanation table' .
I had checked the privileges and there is an alias created on fghi.DSN_FUNCTION_TABLE for abcde as owner and given all privileges to PUBLIC on the base table.
'TOKENS' I'm not exactly sure about this but presume it refers to 'column name' that has the issue ? As DSN_FUNCTION_TABLE is standard table can anyone shade some light on what can go wrong here. I know this is just a warning and explain(no) will remove the warning but would like to understand the issue. Also I tried to locate STATEMENT =700 but there are no statement no 700 in the package.
Thanks in advance.