Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Pune , India

    Exclamation Unanswered: Error While Visual Explain

    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
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    It looks like you should open a PMR with IBM on this.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts