1. Forum
  2. USENET
  3. comp.sys.ibm.as400.misc

  • QMQRY - Column headings

    From Giovanni Brutto@brutto.giovanni@gmail.com to comp.sys.ibm.as400.misc on Fri May 20 01:34:36 2022
    From Newsgroup: comp.sys.ibm.as400.misc

    Hi everyone,

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

    Thanks for the help.

    Regards
    Giovanni
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Roberto Bombelli@rbombelli@gmail.com to comp.sys.ibm.as400.misc on Fri May 20 06:53:25 2022
    From Newsgroup: comp.sys.ibm.as400.misc

    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|4 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
    --- Synchronet 3.21d-Linux NewsLink 1.2