How would I select data from a specific member in a file using SQL with Java and JDBC?
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.
Dig Deeper on Web Development
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.