Hi,
There is a report page and it has a DB2 query which retrieves the information from DB2 tables and using some paramaters in the query which is gotten from a previous screen.
My problem is, the 1st variable gets only 1 parameter, but it occured that I would need to search by more value. The variable is a string type and used in the WHERE clause like this:
b.name = :C_name
But when I tested with hardcoding way like this:
b.name in ('40','GGG5')
It didn't retrieved anything hence when I search with only 1 value the retrieve has result!
What is wrong? Why it doesn't work with more parameter? The query is working in the mainframe when I run this.
Please help! Hope it is clear what is my problem.
Thx
There is a report page and it has a DB2 query which retrieves the information from DB2 tables and using some paramaters in the query which is gotten from a previous screen.
My problem is, the 1st variable gets only 1 parameter, but it occured that I would need to search by more value. The variable is a string type and used in the WHERE clause like this:
b.name = :C_name
But when I tested with hardcoding way like this:
b.name in ('40','GGG5')
It didn't retrieved anything hence when I search with only 1 value the retrieve has result!
What is wrong? Why it doesn't work with more parameter? The query is working in the mainframe when I run this.
Please help! Hope it is clear what is my problem.
Thx