AS400

25 pts.
Tags:
Query optimization
I am having problem with LF not reading correctly.  Can you turn off QUERY Optimizer for one job or a program?  If so how do you turn off Query Optimizer?

Software/Hardware used:
RPG LE AS400 V5R4M00

Answer Wiki

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

Discuss This Question: 2  Replies

 
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
  • CharlieBrowne
    Can you explain what you mean by not reading correctly?
    41,380 pointsBadges:
    report
  • TomLiotta
    I am having problem with LF not reading correctly. How do you know it's not reading correctly? What is the problem? Can you turn off QUERY Optimizer for one job or a program? The query optimizer is for SQL. But you can't reliably use SQL with LFs, so the query optimizer shouldn't be involved. Why ask about the query optimizer? Are you trying to use SQL to process a LF? What is the SQL statement? What is the definition of the LF? You almost certainly need to be looking at something other than the query optimizer, but you haven't shown us anything that we can comment on. Show us what you are doing and tell us why it seems to be wrong. We can suggest changes. Tom
    125,585 pointsBadges:
    report

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