Re: Issue with generating multiple excel spreadsheets in batch usingPOI

Sorry. I was in error it is a batch CLLE.

Thanks
Andy
----- Original Message -----
From: <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, January 05, 2010 2:31 PM
Subject: Re: Issue with generating multiple excel spreadsheets in batch
usingPOI

why are you using a CLP? you should be using CLLE. POI used within RPG
has to run in an ILE environment, rough guess is that when the first ILE
program completes and is returned back to the default activation group

(in

OPM mode) it's hosing the ILE environment


Thanks,
Tommy Holden



From: "Andy Hautamaki" <ahautamaki@xxxxxxxxxxxxxxx>
To: "RPG400-L@xxxxxxxxxxxx" <RPG400-L@xxxxxxxxxxxx>
Date: 01/05/2010 01:26 PM
Subject: Issue with generating multiple excel spreadsheets in

batch

using POI
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



We have an CLP batch program that calls two separate ILE programs and

each

of them generate an excel spreadsheet using POI.

The first ILE program creates the excel spreadsheet correctly but the
second
when it creates the spreadsheet it has junk in the cells.

What is confusing is when we call the two ILE programs interactively they
both work correctly.

Is there something special in our CLP that we should have coded?

Thanks
Andy

--
This is the RPG programming on the IBM i / System i (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.


--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.