Are you able to left join to a UDTF with input parms with DB2 query in Editor?

HollyL

$stockpile = "'2023-09-30'";
Here is my join:
->LeftJoin("aggen.DELIVYSUMF($stockpile, '0') as aggen.DELIVYSUMF", "aggen.DELIVYSUMF.SHRNUM", "=", "aggen.bfrep.BFASNB")

error I'm getting:
Messages: 42601 Token ( was not valid. Valid tokens: ON FULL LEFT CROSS INNER RIGHT USING EXCEPTION. SQLCODE=-104

I can't paste the whole sql here for privacy reasons. But it looks like it should work from when I see it in the log.

LEFT JOIN aggen.DELIVYSUMF('2023-09-30', '0') as aggen.DELIVYSUMF ON aggen.DELIVYSUMF.SHRNUM = aggen.bfrep.BFASNB

allan

Unfortunately no - what you need to do in such a case is create a VIEW. There is an example of that here.

Allan

HollyL

Thanks Allan for your quick response!