qmqry error - Help!
SQL, QMQRY, AS/400 journaling
Can anyone help? I have a clp application that calls a qmqry which reads a large sales transaction file and selects and creats a small summary file of certain transactions for a certain typpe of part and date range. This sales transaction file is journaled and the file it creates becomes journaled? This part works fine.
The second part of the clp takes this summary workfile and joins to our actual payment records and creates another workfile of any items in the workfile that are not paid and ages how deliquient they are. We put these records in a workfile in qtemp and e-mail the user.
This part is not working anymore. It gets a error on select-omit record 0.
I can run this qmqry manually with output on screen so it is not the actually qmqry(I believe) Would the journalling have anything to do with it? Or does anybody have any idea which area I should explore?
