Ask the Expert

Selecting data from a specific member in a file using SQL with Java and JDBC

How would I select data from a specific member in a file using SQL with Java and JDBC?

To my knowledge, the JDBC and SQL interfaces do not have properties or entity relationships that would indicate a specific member to use on an SQL request from Java. If there is a way, I haven't found it yet. I would use the Java Toolbox and serialize a request for a call to override the physical file to a specific member. Since the JDBC request might create a separate thread, it might not work. That would leave you with a serial method to access AS/400 data by a specific member and making JNI calls to process your SQL requests. If you do find a way, please let us know.

This was first published in April 2001

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: