Re: Java exception "java.lang.OutOfMemoryError: Java heap space" when calling ...

As others have said, you can reduce the memory requirements by using SXSSF
and also using SS_freeLocalRef(Row) at least to clear each row from memory
as its completed.
If you're using a 64bit JVM, you can use the following, run before any
other java commands in your program. This has to be run before the JVM is
started in the job, so if you're running this stuff interactively, it may
be too late.

callp(e) QCMDEXC('ADDENVVAR ENVVAR(QIBM_RPG_JAVA_PROPERTIES)
VALUE('
+apos+ '-Xmx8192m;-Xms512m;'+apos+')':1024);
___________________________________
Darren Strong
Dekko