Microsoft Office & AS/400 Database

5 pts.
Tags:
Access
i5
ODBC on i5
I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You should be able to call the system API Execute Command, QCMDEXC, as a stored procedure prior to the data transfer. Through QCMDEXC you would issue an OVRDBF using the appropriate MBR parameter value. The QCMDEXC API documentation can be found <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/qcmdexc.htm”>here</a>.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following