sysibm.sysdummy1 not working in ireport

sysibm.sysdummy1 is not working when I am running the query from Ireport. But the same is working fine when I run the same query from DB2client. select (****) from sysibm.sysdummy1; what is the solution.! thanks.
shreyas.deshpande26's picture
Joined: May 17 2016 - 10:14am
Last seen: 6 years 11 months ago

1 Answer:

What encoding are you using? You need to be using EBCDIC and I think you also should be using IBM JDK when using using IBM products.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago