Q

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

Dig deeper on Web Development

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.

0 comments

Oldest 

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:

SearchEnterpriseLinux

SearchDataCenter

Close