STRQMQRY require compile if add new field

5 pts.
Tags:
AS/400
AS/400 commands
STRQMQRY
I add field to a physical file, should i compile the STRQMQRY source, although inside STRQMQRY don’t use the new field. I test STRQMQRY old object, can run on in amend physical file. I juz want to double confirm from expert.

Software/Hardware used:
Software
ASKED: June 10, 2010  11:35 AM
UPDATED: June 11, 2010  12:03 AM

Answer Wiki

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

No need to recompile a QM query unless you removed something that was needed by the query or changed something to be incompatible.

For example, if you changed a CHAR column to be an INTEGER column, you would possibly have a WHERE clause that made a character comparison — the comparison might have been against a quoted string and need to be changed so that it was a numeric literal instead. Or you might have renamed a column that you used in your column list — you’d need to change the source to refer to the new name.

In general, if you don’t have to make any change to the QM source, then you won’t need to recompile.

Tom

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