How would I select data from a specific member in a file using SQL with Java and JDBC?
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
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.