AnsweredAssumed Answered

PREP_PROCESS_VARA - Is my syntax incorrect or have I found a bug?

Question asked by JohnO'Mullane on Oct 11, 2016
Latest reply on Oct 13, 2016 by JohnO'Mullane
Hi,
I'm trying to do a simple PREP_PROCESS_VARA which is not working.

I'm trying to retrieve data for all rows that have a "0" in Value 4

4blsgi5j5jay.png

From what I can tell from the help, this is what my command should look like 

:SET &HND#=PREP_PROCESS_VAR(DBA.BACKUP_MOUNT_RESULTS, ,"0",5)

This doesn't work as it's not getting inside my PROCESS.

If I try this, still doesn't work...

:SET &HND#=PREP_PROCESS_VAR(DBA.BACKUP_MOUNT_RESULTS, ,"*0*",5)

The only way I can get it to work is if I replace with the following 

:SET &HND#=PREP_PROCESS_VAR(DBA.BACKUP_MOUNT_RESULTS, ,"*0*")

There are 2 problems here. 

1. Why do I need to use wildcards(*)
2. Why does it not recognize the column number in my syntax

Anyone out there know if this is a bug or is my syntax incorrect?

John.

Outcomes