Unanswered: Error While Visual Explain
Many times i have observed that while performing visual explain from command editor, it starts giving error SQL0104N , even when the query is getting executed correctly
Then i have to give blank spaces at the starting of each line which sometimes helps , mostly dont.
It becomes more frustating when the query is big and i have to spend lot of time just editing
even though the following query is giving resultset when i do visual explain it returns following
Part of query....
timestampdiff(256,char(current timestamp -TPM.DATEOFBIRTH )) >=16 ))
order By yeargroup, age
[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "order" was found following "ar(current timestamp". Expected tokens may include: ")". SQLSTATE=42601
Certified DB2 9 DBA / Application Developer