Re: QMQRY use LIKE?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Fran

Others have pointed out the LIKE operator in the record selection 
screen - documentation is as close as your F1 key when your cursor is 
in that column or the value column.

You might not be aware that you don't need the full blown SQL to use 
QMQRY even better - forms, now, they can be ugly - heh.

Query management support is part of the OS - comes with every machine.

You can RTVQMQRY from a QRYDFN - main problems come when using other 
than a type 1 join. This gives you a source member, that you use to 
CRTQMQRY. There is even a WRKQMQRY with several handy options.

Using RTVQMQRY with dependent values, as you have, will result in the 
&INPOS as part of the SQL statement in question. I can't urge 
strongly enough that eventually you create your own source members 
with your SELECT statement in them - or any valid SQL statement, for 
that matter. And use CRTQMQRY.

NOTE: The source file, usually named QQMQRYSRC, has to have a 
RCDLEN(91) - not 92.

You have much more power using actual SQL on QMQRY source - QRYDFNs 
can be handy but have some limitations, or at least difficulties, 
when using ANDs and ORs - no parenthesizing possible.

There's a manual called Query Management Programming that has a lot 
of this information - and more than you probably WANT to know! You 
can find it under the Database topic at InfoCenter.

HTH
Vern

At 10:59 AM 12/21/2007, you wrote:

> We are at V5R2M0 and do not have the full blown SQL.
>
> I use the limited RunSQLStm with a script in a database file, 
> though. However, this is not my issue at the moment.
>
> I use WRKQRY to generate queries and in this case can build a query 
> to receive parms from a CL as in my prior posts.
>
> My select records screen looks like this:
>           RPREFA            EQ     :inneg
>  OR     RPREFA            EQ     :inpos
>  OR     RPPRCL            EQ     :inparcel
>
>
> I'd like to add a LIKE statement, too. Is that possible? If so, 
> could you point me to some documentation?
> Thanks again,
>
>
> Fran Denoncourt
> Sr. Programmer/Analyst
> Pinal County Treasurer's Office
> Florence, AZ 85232
> (520) 866-6404