Re: Call Query

[Evan Harris <spanner@xxxxxxxxxx>]

Dan

>Can't say I've seen a lot of list activity asking about substringing numerics,
>but I will opine here and say that if you have to substring a numeric
>variable, then it shouldn't be a numeric variable.

I think Rob's referring to when you are trying to include numeric 
comparison's in a QRYSLT string. I can recall seeing a few of these float 
through here and midrange-l.

All that substringing, concatenation and extra quote business seems to 
throw a few people. It made more sense to me after I unravelled the 
mysteries of passing parameters into QMQRY (now there's a way to get claw 
marks on your head).

Perhaps a good idea would be to write a front-end RPG to pass a 
pre-formatted string into a CL that would use OPNQRYF to output the data 
into a pre-formatted work file. Then it would be a simple matter of 
formatting the report using Query.

To improve things even further you could output to a multi-member file and 
pass the member into the queries file name prompt. This would allow many 
users to run their queries at the same time.

Of course for the front-end RPG you'd have to create a command so that the 
numeric variables didn't fail due to not being passed correctly on the 
command line.

Let's see - CMD, RPG, CL, Query..... Nah, I think I'll just write a report 
in RPG using O-Specs and a do-until loop.......

:)

Cheers
Evan Harris

P.S.I had one of those days too - this has helped

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---