Lon_Needham_606

What is the syntax for the Variable Picker in an SQLI object?

Discussion created by Lon_Needham_606 on Jun 9, 2015
Latest reply on Jun 9, 2015 by Lon_Needham_606
Good morning! I'm trying to write into my SQL statement a variable I defined. Would someone mind helping me with the proper syntax to reference that variable's value? The following is what I have in my SQLI object. Inside the variable picker button I selected variable objects in the category field, then selected my object, VARA.JOB_DOC_SETUP. What is the syntax to reference Value 1 in my variable?

SELECT OH.OH_NAME
FROM OH
WHERE OH.OH_TYPE = 'JOBS'
AND OH.OH_DELETEFLAG = '0'
AND OH.OH_NAME LIKE {VARA.JOB_DOC_SETUP}

VARA.JOB_DOC_SETUP:
Key: search_string
Value 1: ETL

The goal is to use the results in a prompt set combo box.

Outcomes