1
  • Difference between Structured Query and Query in AS/400?

    We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. What is the difference between Structured Query and Query? (SQL and QRY)

    anupsshelke420 pointsBadges:
  • AS400 Qry – Is there a way to trick qry into treating blanks as null?

    The data I need to sort on is in either field A or B depending on the transaction type. It could be accomplished by using the "value" expression if qry would consider a blank field as null. Any ideas?

    Sands5 pointsBadges:
  • RTVQMQRY Why does it change the last used date of the *qrydfn obj? Anyway to prevent this update?

    RTVQMQRY    Why does it change the last used date of the *qrydfn obj?  Anyway to prevent  this update? 

    Modiyooch540 pointsBadges:
  • Access paths no longer valid

    Ok, the plot thickens. I'm trying to identify and rebuild LFs that after an abnormal shutdown and normal ipl, are no longer being selected for SQL and QRY. These files are not damaged, but program response has taken a major hit due to these views not being selected. After researdhing one known file...

    Modiyooch540 pointsBadges:
1

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