× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



USE sets the current database - on the i, a library is the same thing as what MySQL and others call a database.

There is a SET OPTION DFTRDBCOL schema-name that gets you the same thing.

Or you can set naming convention in JDBC to SQL and set the default collection there.

I think!

HTH
Vern

On 2/1/2013 5:04 PM, James H. H. Lampert wrote:
Scott, I hope you're feeling better; don't push yourself on my account.
I'm sure anybody familiar with both MySQL and DB2/400 can answer this,
whether they know JDBCR4 or not.

At any rate, it's like the subject line says.

I haven't really had a good opportunity to install MySQL someplace with
a fixed IP address, and so I'm running the first tests of JDBCR4
pointing right back to the local DB2/400 on the very same box.

I changed a copy of the JDBCTEST source member, so that it goes into the
local DB2/400 (talk about carrying coals to Newcastle!) instead of a
MySQL server. I successfully got rid of the parameters on the CREATE
DATABASE that DB2/400 didn't like, and it successfully created the
TESTSCK library, with all the extra baggage of an SQL collection.

Then it tried a USE statement. Which is perfectly fine in MySQL, but
DB2/400 didn't like it. And while a quick RTFM confirmed that DB2/400
doesn't have a USE statement, I haven't a clue what the equivalent would be.

--
JHHL


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 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.