RE: AS400 Query - Passing info from CL program?

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

QMFORMS?  EEEW!

My one experience with actually writing qmforms made me grateful for O
specs. <g>

BTW, parameter passing is documented in the query manual although I didn't
learn about it from the manual.  Can't remember the title of the section
offhand, but the topic is Office Vision mail merges and I think it's in an
appendix.  It's one of my favorite challenges to people who claim to believe
that _all_ IBM documentation is completely wonderful. (In all fairness, some
of it is wonderful.)

  
> -----Original Message-----
> From: Dan Bale [mailto:dbale@genfast.com]
> Sent: Tuesday, November 23, 1999 1:43 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: AS400 Query - Passing info from CL program?
> 
> 
> 
> 
> AAAAAAAAAAuuugggghhhhhhhhh!   Where the heck have I been?  
> Why isn't this
> documented in the Query manual?  You should'a heard the 
> head-banging when I
> shared this response with the others in our office, which, 
> several months ago,
> undertook a _major_ project to convert user-written queries 
> with hard-coded
> selections to QM queries (both *QMQRY & *QMFORM objects).  It 
> got so bad that I
> ended up scrapping some of the conversions and wrote RPG/CL 
> from scratch; much
> faster to production.
> 
> Well, so, I guess, Thanks for the tip!  Next time..........
> 
> If I'm not the only one who didn't know about this (which I 
> suppose _is_
> possible), I think this would be an excellent tech tip in the 
> trade rags.  Per,
> go for it; it might net you $50!
> 
> BTW, this technique _does_ do a conversion to *QMQRY, it's 
> just transparent.
> This is important to know, because there are differences 
> between WRKQRY output
> and STRQMQRY *QMQRY output.  But it looks much cleaner than 
> the conversions I
> did in the past.  Oh, and character host variables have to be 
> enclosed in triple
> single quotes, i.e., SetVar((STATUS '''A'''))
> 
> Will sleep better tonight.......
> 
> - Dan Bale
> 
+---
| 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
+---