1. Forum
  2. Usenet
  3. COMP.SYS.IBM.AS400.MISC

  • QMQRY - Column headings

    From Giovanni Brutto@21:1/5 to All on Fri May 20 01:34:36 2022
    Hi everyone,

    Anyone know how to add variable on a QMFORM column headings?

    Thanks for the help.

    Regards
    Giovanni

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roberto Bombelli@21:1/5 to All on Fri May 20 06:53:25 2022
    Hi giovanni,
    I think it's possible; You mast put a variable in the SQL like this :

    select
    codice,
    descrizione as &variable
    from libreria.tabella
    where desclizione like 'AL%'
    order by 001

    and u can send variable (&variable) from CLP o RPG

    If u will run from QM it ask for variable



    Il giorno venerdì 20 maggio 2022 alle 10:34:38 UTC+2 Giovanni Brutto ha scritto:
    Hi everyone,

    Anyone know how to add variable on a QMFORM column headings?

    Thanks for the help.

    Regards
    Giovanni

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)