Program Name info

[Pavan]

Hi,
Is there a way to find a list of programs that are called by "RPG Backend Call" tied to a button(in Query Behavior section)?
Regards,
Pavan

[robert.swanson]

Hi Pavan,

The RPG programs called from Query Apps are stored inside VVQRY200. They're encoded in JSON format inside field VVVALUE, with a name of "pgm".

You could get a crude but quick list of programs via STRSQL using a statement like this:

select vvid,
       substr(char(vvvalue),posstr(char(vvvalue),'"pgm"')+7,10) as PGM
  from vvqry200
 where char(vvvalue) like '%"pgm":%'

However this approach would only show you the first RPG program in VVVALUE for each record -- there could be additional programs not being shown if you have Apps calling more than one RPG program. In which case you'd need to write something a little more sophisticated. But you get the idea.

[Pavan]

That really helps. Thanks Rob.