windows 2000
db2 8.2.7

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

It looks like you should open a PMR with IBM on this.

Andy