Re: Open queries

[Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>]

Since it's hard to follow .... try this:

sndpgmmsg msg(&qslt) topgmq(*same)   

Do the above in the CLP "after" you build the &QSLT and before
you call opnqryf....... This will allow you to "see" what the
actual string looks like that opnqryf is attempting to use....

When the program abends....Press F10 

look in the joblog and you will see
the &qslt and then you can determine the problem.... I would
run this interactive till I got it working right.....


Remember the rules about numeric and alpha variables.....



Shelly.Sommerfeld@state.sd.us wrote:
> 
> Rick,
> 
> I have gotten the first part to work with the parms being passed in and
> everything... the next problem that I am having is on the opnqry statement.
> When I go to run the statement it gives me an unmonitored message CPF9899.
> I have read everything on opnqry.  I can not see what I have done wrong.
> Just wondering if you had any thoughts on this?
> 
> CHGVAR     VAR(&QSLT) VALUE('SMTIME *EQ ' *CAT &TIMEM *CAT +
>             ' *AND  SMENDT *GE ' *CAT &FMDT)
> 
> OPNQRYF    FILE((SMSTAT10)) QRYSLT(&QSLT)
> 
>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---