Re: Bug with library underscore in wdsc Data perspective

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

The problem might be that the underscore is a single-character 
wildcard in SQL - this is a little-known gotcha, seems to me.

At 09:00 AM 10/17/2006, you wrote:

> All,
> There is a bug in the data perspective when you create a new 
> connection in the database explorer view.
> When you create a new iseries connection (right click and New 
> Connection) then if you change the default filters 'NOT LIKE SYS%' 
> by a library with underscore int it (for example U_MyLIB) and click finish.
> You cannot see any tables in our schema.
> Then click the menu Filters, you see that your library name has been 
> translated to 'U MyLib' the underscore has been changed by a space.
> If you correct the filter then you can see your tables.
> Maybe that can be fixed in the next release...
>
> Regards,
>
> Manuel Cerda
>
>
>
>
>
> --
> This is the Websphere Development Studio Client for 
> iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.