Learning SQL Part 2

1,185 pts.
Tags:
AS/400
AS/400 SQL
Microsoft Access
SQL
SQL Training
Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?
ASKED: July 29, 2009  9:11 AM
UPDATED: July 30, 2009  3:48 PM

Answer Wiki

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

Any book on SQL — Access supports 85% of the standard.

This isn’t the best way to go.
I think it will be very slow – SQL is running on you PC and every record from the 400 must be sent even if it’s eventually excluded by your Query.

You can run SQL from your PC using Navigator in client access or a number of free SQL PC tools. These will pass the request to the 400 which does the selection and only transfers the results to your pc.

Phil

Discuss This Question: 1  Reply

 
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