Re: LIKE as host variable in Query/400

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

This is just normal QMQRY behavior - substitution variables that are
strings need the apostrophes around them. Every setvar value is a character
string. Those would probably want double apostrophes, to get the apostrophe
into the result.

At 11:40 AM 8/23/02 +1000, you wrote:

>Hello Valerio,
>
>You wrote:
> >Now I need to add a LIKE selection, but, I can't find the syntax that
> >would bring up the "Specify Dependent Value Qualifiers" screen. Does
> >anybody know if LIKE as host variable is supported and what's the
> >correct syntax for coding it in Query/400?
>
>  CUSNAM            LIKE   :name
>
> >I know I can have it working by creating a source in QQMQRYSRC with SEU
> >and then run it with a regular strqmqry command, but I'm curious to know
> >if it can be done under Query/400.
>
>No, it can't.  If you code the above you will receive message QRY2234 -
>Value not correct, cursor at position to check for error.
>
>The second-level text for that message is fairly explicit:
>
>Cause . . . . . :   The cursor indicates the part of the value in error.
>If the cursor is at the end of the value line, it may mean that part of
>the value is missing.
>      Some types of errors are:
>      -- Wrong separator:  Separate RANGE, LIST, and NLIST values with
>spaces.
>      -- Wrong type of value:  Use constants, not fields, as LIST and NLIST
>    values.  Use a character constant enclosed in apostrophes for the LIKE
>or NLIKE value.  Use the NULL keyword for the IS or ISNOT value (example:
>    PARTCODE ISNOT NULL).
>      -- Misplaced characters:  For numeric constants, place + or - before
>the number, not after.  Example: NUMBER1  RANGE  -20 -10
>      -- Characters not allowed:   Enclose constants inside apostrophes.
>    Example: PARTCODE  LIST  '9X20224' '6Paaa4'.
>
>The relevant part is:
>"Use a character constant enclosed in apostrophes for the LIKE or NLIKE
>value."
>
>The same problem occurs with LIST and NLIST.  It does seem a silly
>restriction.  Perhaps you should create a DCR and get it changed?
>
>Regards,
>Simon Coulter.
>--------------------------------------------------------------------
>    FlyByNight Software         AS/400 Technical Specialists
>    http://www.flybynight.com.au/
>
>    Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
>    Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
>                                                              X
>                  ASCII Ribbon campaign against HTML E-Mail  / \
>--------------------------------------------------------------------
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.