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?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 19, 2008 5:35 PM
UPDATED:
March 12, 2010 9:35 AM
Answer Wiki:
Hi,
It looks like the file already exists in QTEMP, but with a slightly different record format.
Regards,
Martin Gilbert.
To see all answers submitted to the Answer Wiki: View Answer History.
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