Issue in conversion with SET

[raushankumarrr88]

EXEC SQL
SET :WS-LOGGING-ENABLED = BRANCH.PROGRAM_LOGGING
(:PGM, :PM0168-MI-LOC)
END-EXEC

_So i am getting the syntax error in the precompile.

I am able to mitigate this after converting the SET to CALL, but i have alot of SET statements._

EXEC SQL
CALL BRANCH.PROGRAM_LOGGING(:PGM, :PM0168-MI-LOC, :WS-LOGGING-ENABLED)
END-EXEC.

Can anyone Suggest how to resolve this?

[kio-watanabe]

@raushankumarrr88
Thanks for opening the issue.
We'll investigate and get back to you.

[kio-watanabe]

@raushankumarrr88
While "EXEC SQL SET" is an IBM DB2 syntax, OCESQL4J currently only supports PostgreSQL. So, your suggestion to use "EXEC SQL CALL" seems like the best way forward. Sorry that we can't offer direct support for "EXEC SQL SET" with DB2.