RE: In case anyone is interested....

This is very much the case.  I have added more extprocs than what was
submitted by Scott but by far the majority was his service program that
this was built upon.  Most of my contributions was to create an easy to
use command interface which prevents you from having to write tons of
programs to build a spreadsheet.  I first undertook this "project" to
simplify my life.  I can build a workfile, execute a command & viola
it's in Excel....

My original version required the production machine to have the RPG
compilers installed ( it wrote an RPG IV program on the fly...).  Since
the company I am currently working for does not have compilers loaded on
their production machines I opted to rewrite it using embedded SQL
(which is surprisingly easier than writing a code generator
program...not that it hasn't gotten easier since RPG IV). 

Needless to say I have already learned a lot from this open source
effort...(never had to think of international language support for
example lol..).

BTW, I love this mailing list!!!  Thanks to all the expertise on this
list I know I have benefitted greatly & I hope to be able to give back
some to others...especially those who don't tell me to RTFM!!! <vbg>

Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Tuesday, October 04, 2005 2:51 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: In case anyone is interested....

Hello Jonathan,

> I have to say I don't know anything about Java, but did a scan on

You start out your message by saying that you don't know anything about
Java.  So why assume that I'm wrong?

> 5769JV1 in Google and found the "Getting Started with Java and AS/400:
> Java on AS/400" manual at http://164.42.157.80/manuales/java400.pdf.  
> On the first page in Chapter 1 it says that you can "use Java with 
> other languages such as C++ and RPG".

That statement is so broad it could mean anything.  It could be
referring to the JNI APIs.  It could be referring to the ability to call
Java programs from RPG programs.

I was specifically referring to the RPG/Java integration that's used in
the iSeriesToExcel project that Tommy Holden posted.  Why would I know
anything about this project?  Because he's using a lot of code that I
wrote in a series of articles that I wrote about using the HSSF/POI
classes from RPG.

The code that he's using uses RPG's support for calling Java classes
with the EXTPROC D-spec keyword.  In other words, starting in V5R1 you
can write code that looks like this:

      D HSSFWorkbook    S               O   CLASS(*JAVA
      D
:'org.apache.poi.hssf.usermodel-
      D                                     .HSSFWorkbook')

      D new_HSSFWorkbook...
      D                 PR                  like(HSSFWorkbook)
      D                                     ExtProc(*JAVA:
      D
'org.apache.poi.hssf.usermodel-
      D                                     .HSSFWorkbook':
      D                                     *CONSTRUCTOR)

What about that is new in V5R1?

-- The CLASS keyword.
-- The O (Object) data type.
-- The *JAVA special value.
-- The *CONSTRUCTOR special value

So... pretty much everything related to Java integration is new.

How do I know that this stuff was added in V5R1?  Because IBM documented
it in the "What's New in This Release?" section of the RPG Reference
manual in the information center:
http://publib.boulder.ibm.com/iseries/v5r1/ic2924/books/c092508307.htm#H
DRRELV5R1

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.