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

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

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

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

    Jim Stewart
  • YuanFeng
    YuanFeng
    78 Posts

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

    ‏2013-01-04T09:52:06Z  
    The problem is still present with IBM® Data Studio Version 3.2.0.0

    Jim Stewart
    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

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

    ‏2013-01-04T22:38:41Z  
    • YuanFeng
    • ‏2013-01-04T09:52:06Z
    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.
    Hi Yuan,

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

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

    ‏2014-02-15T23:19:27Z  
    • YuanFeng
    • ‏2013-01-04T09:52:06Z
    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.

    Hi Yuan, 

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

     

    thanks,

    Jim Stewart

     

  • YuanFeng
    YuanFeng
    78 Posts

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

    ‏2014-02-17T02:44:38Z  
    • JGStewart
    • ‏2014-02-15T23:19:27Z

    Hi Yuan, 

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

     

    thanks,

    Jim Stewart

     

    Hi,Jim

    I tried with latest 4.1.0.1 driver, the filter works fine for tables, Could you download the latest driver.

    You can get the latest versio from below URL:http://www.ibm.com/developerworks/downloads/im/data/