Re: R: Utility for import excel file to db2 file

On Sun, 2 Feb 2025 at 08:00, Vern Hamberg wrote:

I do wonder about the Java version you are running.

It seems to me that people new to Scott's POI/HSSF wrappers tend to
get stuck on the Java part of this.

The Java environment is very different to the ILE environment. My
advice these days for people wanting to use these excellent wrappers
is to do several Java-only projects first. Hello World, and then
something more complex like reading from a Db2 table (in Java). The
point is to become familiar with the Java CLASSPATH - especially how
it's set once per job. I learnt to SBMJOB everything that uses Java.
This taught me how to print, print, print for debugging purposes. Once
one is familiar with CLASSPATH, one can then set the proper CLASSPATH
for the wrappers to work. Make sure you don't set the CLASSPATH in a
user profile-specific way, or else your user profile will be the only
one that can run this!

--buck