sysibm.sysdummy1 not working in ireport
Posted on June 21, 2016 at 11:56pm
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.
Joined: May 17 2016 - 10:14am
Last seen: 6 years 11 months ago
Posted on June 22, 2016 at 4:06am
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.
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago