Topic
5 replies Latest Post - ‏2014-02-17T02:44:38Z by YuanFeng
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic SQL -104 trying to filter tables with Z/OS Db2 10

‏2013-01-02T21:08:59Z |
Hi -

With IBM® Data Studio Version 3.1.1.0, administration client I am trying to filter results on my list of tables while connected to z/OS Db2 10. Any table filter attempt fails with:

!MESSAGE ILLEGAL SYMBOL "W". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: AT MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE HOURS. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.63.108

The tablespace filter with Db2 V10 works fine and the other quirk is that filtering tables with z/OS Db2 9 works fine.

Does anyone have a guess as to the cause/fix for this? It has me flummoxed.

Many thanks!
Jim Stewart
Updated on 2013-01-04T22:38:41Z at 2013-01-04T22:38:41Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: SQL -104 trying to filter tables with Z/OS Db2 10

    ‏2013-01-03T07:51:55Z  in response to SystemAdmin
    The problem is still present with IBM® Data Studio Version 3.2.0.0

    Jim Stewart
    • YuanFeng
      YuanFeng
      78 Posts
      ACCEPTED ANSWER

      Re: SQL -104 trying to filter tables with Z/OS Db2 10

      ‏2013-01-04T09:52:06Z  in response to SystemAdmin
      Thanks Jim for report the issue, I have raised your problem to our developer, it looks like a defect.Our developer is investigating on it,I will keep you update if there's some progress.
      • SystemAdmin
        SystemAdmin
        1632 Posts
        ACCEPTED ANSWER

        Re: SQL -104 trying to filter tables with Z/OS Db2 10

        ‏2013-01-04T22:38:41Z  in response to YuanFeng
        Hi Yuan,

        Thanks very much for the update. I was hoping the cause wasn't PEBKAC.
        :-)
        Jim Stewart
      • JGStewart
        JGStewart
        1 Post
        ACCEPTED ANSWER

        Re: SQL -104 trying to filter tables with Z/OS Db2 10

        ‏2014-02-15T23:19:27Z  in response to YuanFeng

        Hi Yuan, 

        It's been a year.  Any progress to report?

         

        thanks,

        Jim Stewart