I'm having some difficulty executing a query which uses a User Defined Table Function with parameters. I'm not sure if my issue is UDTF support, or if it is how I am specifying the parameters.
Example of what I'm doing:
FROM TABLE(MY_UDTF$('ABC123')) AS T;
FROM TABLE(MY_UDTF$(?)) AS T;
Please note, when I run this query in another editor (more specific to DB2 on IBM i) - it works as expected.
Also note, I can get something simple such as the following to work with query parameters:
WHERE MY_FIELD = ?;
Am I doing something wrong? Or are UDTF's just not supported in PHPStorm?