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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!