Problem solve Get help with specific problems with your technologies, process and projects.

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 last published in April 2001

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.