We are currently experimenting with BIRT, accessing DB2/400 data.

When we set up a Data Source with a URL of jdbc:as400://foo.bar.com (the name has been changed to protect the innocent), we connect just fine, but when we go to create a new Data Set, we end up with a list of the first 20 libraries in alphabetical order, NOT including the library we want.

But we can select the desired library (we'll call it WTFOOBAR here) from the Schema drop-down.

Ideally, we don't really *want* end-users to be kicked into this situation.

We tried changing the URL in the Data Source to
jdbc:as400://foo.bar.com/WTFOOBAR
and nothing about its behavior changed.

We tried changing it to
jdbc:as400://foo.bar.com:currentSchema=WTFOOBAR
and again, nothing about its behavior changed.

Anybody know what we're doing wrong here?

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.