MQSeries.net :: View topic

AnshumanMishra861 · Posted: Tue Apr 19, 2022 6:42 am Post subject:

I am connecting ACE with DB2. I am getting a JSON request with FieldNames and Values and I need to fetch data from DB based on those values.

While fetching data in DB2, it's working in below format if the field in NULL
'SELECT * FROM table WHERE column1 IS NULL'

but if the field has some values the query should be

'SELECT * FROM table WHERE column1 = "value" '

I have multiple columns that can be either NULL or may have some values.

I am creating the SQL query in esql as below

SET env.var[] = PASSTHRU('SELECT * FROM table WHERE column1 = ? AND column2 = ?' VALUES(env.Column1_value,env.Column2_value) );

But this works only if the fields have some values.
Is there any way I can change the query dynamically to below, depending on the field values?

SET env.var[] = PASSTHRU('SELECT * FROM table WHERE column1 IS NULL AND column2 = ?' VALUES(env.Column2_value) );

I am getting 10 columns in input. Below is a sample input format that I might receive
{
"searchKeys": {
"column1": "value",
"column2": "value",
"column3": "",
"column4": "",
"column5": "value",
"column6": "",
"column7": "value",
"column8": "",
"column9": "",
"column10": ""
}
}