qmqry outfile

15 pts.
Tags:
AS/400
QMQRY
QMQRY OUTFILE
I have a qmqry that we have had running in production for awhile with no problem. It is called from a cl. We create one workfile and then the second works with this file and joins to another creating a outfile in qtemp which we e-mail to user. This is the type of error we are getting now. > STRQMQRY QMQRY(CONNIE/PRJ8917) OUTPUT(*OUTFILE) OUTFILE(QTEMP/PRJ8917) Select or omit error on field ���������� member PRJ8917. Select or omit error on field *N member PRJ8917. Select/omit error on member PRJ8917. Data conversion or data mapping error. RUN QUERY command failed with SQLCODE -802. RUN QUERY command ended due to error. STRQMQRY command failed. > However if I run the same qmqry with output(*) it works?* > STRQMQRY QMQRY(CONNIE/PRJ8917) OUTPUT(*) Any ideas what I might try to correct?
ASKED: February 19, 2008  5:35 PM
UPDATED: March 12, 2010  9:35 AM

Answer Wiki

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

Hi,

It looks like the file already exists in QTEMP, but with a slightly different record format.

Regards,

Martin Gilbert.

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
  • TomLiotta
    Without seeing the query and possibly the CLP, there's no way to know. Gilly400's guess looks like as good as guesses get. 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