In <1347888608.6189.yahoomail...@web114708.mail.gq1.yahoo.com>, on
09/17/2012
at 06:30 AM, Walter Marguccio said:
>Still, I need a .xls generator on the Linux side.
On the Linux side the issues with Perl and CPAN disappear.
--
Shmuel (Seymour J.) Metz, SysProg and JOAT
Atid/2
In , on 09/17/2012
at 12:00 PM, Scott Ford said:
>Excellent, what version of Perl is supported on Unix System Services,
>v5 ?
5.8.7; the Unicode support broke EBCDIC after that. I don't know
whether anybody is trying to fix it.
--
Shmuel (Seymour J.) Metz, SysProg and JOAT
Atid/2
Scott Chapman's idea is nicely parsimonious, I think.
A slight variation is to put the data in DB2, then connect Microsoft Excel
directly to that. More information here:
http://support.microsoft.com/kb/216428
To toss in some more possibilities, Cognos and SPSS can both export to
Excel files, and
I don't know your full requirements, but what I've done in the past is simply
create the .csv file and copy it over to a spot in the http server's (ZFS)
directory. Then create an Excel spreadsheet that references the CSV by
importing the data "From Web". Set up the data range to automatically
> From: Steve Goetze
> If you would like to pursue the Hybrid Batch / Perl Linux suggestion,
> here's a sample Co:Z Launcher job that runs a perl program
Steve,
terrific ... thanks.
Walter Marguccio
z/OS Systems Programmer
BELENUS LOB Informatic GmbH
Munich - Germany
---
Guys,
Thanks for the clarification, also great idea and process
Scott ford
www.identityforge.com
On Sep 17, 2012, at 12:10 PM, Steve Goetze wrote:
> The example JCL that I posted offloads the Perl processing to a Linux
> server - that part of the "hybrid batch" job doesn't run on z/OS.
>
> IBM
t; TennesseeSM and The MEGA Life and Health Insurance Company.SM
>
>
>> -Original Message-
>> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
>> On Behalf Of Scott Ford
>> Sent: Monday, September 17, 2012 11:00 AM
>> To: IBM-MAIN@LISTS
#x27;t have C compiler, either.
Radoslaw's comment about creating .xls on z/OS and not on a PC is
surely correct, I forgot that we
already offload some processes to distributed machines, depending
on the process.
As an example, if we need to produce a single .pdf file, we use
TXT2PDF on z/
IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Creating .xls on z/OS
>
> Excellent, what version of Perl is supported on Unix System Services,
> v5 ?
>
> Scott ford
> www.identityforge.com
>
--
For IBM-MAIN
The example JCL that I posted offloads the Perl processing to a Linux
server - that part of the "hybrid batch" job doesn't run on z/OS.
IBM Ported Tools for z/OS Perl (
http://www-03.ibm.com/systems/z/os/zos/features/unix/ported/perl/index.html)
supports Perl version 5.8.7. But, as is often the ca
Excellent, what version of Perl is supported on Unix System Services, v5 ?
Scott ford
www.identityforge.com
On Sep 17, 2012, at 11:52 AM, Steve Goetze wrote:
> If you would like to pursue the Hybrid Batch / Perl Linux suggestion,
> here's a sample Co:Z Launcher job that runs a perl program to r
If you would like to pursue the Hybrid Batch / Perl Linux suggestion,
here's a sample Co:Z Launcher job that runs a perl program to read input
data from a z/OS dataset and write the output in .XLS format to another
dataset. The perl program itself is a PDS member on z/OS, so nothing is
required on
On Mon, Sep 17, 2012 at 6:30 AM, Walter Marguccio <
walter_marguc...@yahoo.com> wrote:
> From: "McKown, John"
>
> > I would *STRONGLY* suggest that you try to get your management to allow
> you to install Co:Z Hybrid Batch
> John,
> I wasn't unaware of Co:Z Hybrid Batch. However, we have already
thanks to John for explaining why it might NOT work
> on z/OS. We don't have C compiler, either.
>
> Radoslaw's comment about creating .xls on z/OS and not on a PC is surely
> correct, I forgot that we
> already offload some processes to distributed machines, depending on the
>
Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Walter Marguccio
> Sent: Monday, September 17, 2012 8:30 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Creating .xls on z/OS
>
> From: "McKown, John"
TennesseeSM and The
MEGA Life and Health Insurance Company.SM
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Walter Marguccio
> Sent: Monday, September 17, 2012 9:08 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subje
> I wasn't unaware of Co:Z Hybrid Batch.
"I was unaware ... ", should be ... sorry, brain cells not yet online, although
is late afternoon, for me.
Walter Marguccio
z/OS Systems Programmer
BELENUS LOB Informatic GmbH
Munich - Germany
From: "McKown, John"
> I would *STRONGLY* suggest that you try to get your management to allow you
> to install Co:Z Hybrid Batch
John,
I wasn't unaware of Co:Z Hybrid Batch. However, we have already Co:Z Batch
implemented on every LPARs.
Still, I need a .xls generator on the Linux side.
Wal
iscussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Walter Marguccio
> Sent: Monday, September 17, 2012 4:10 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Creating .xls on z/OS
>
> > From: "McKown, John"
>
>
> > Supposedly, but I haven't ac
sv is considered not acceptable because it lacks features which .xls offers
(formatting, graphs, and so on)
CPAN is worth a try, thanks to John for explaining why it might NOT work on
z/OS. We don't have C compiler, either.
Radoslaw's comment about creating .xls on z/OS and not on a PC is s
te:
09/14/2012 10:33 PM
Subject:
Re: Creating .xls on z/OS
Sent by:
IBM Mainframe Discussion List
Martin,
I have no trouble with formulae in .csv, I do it all the time from Rexx on
z/OS. I will generate two calculation cells like this, for instance:
"=IF(D2>0,(F2-D2),"" &q
;
>> -Original Message-
>> From: Walter Marguccio
>> Sender: IBM Mainframe Discussion List
>> Date: Fri, 14 Sep 2012 06:44:23
>> To:
>> Reply-To: IBM Mainframe Discussion List
>> Subject: Creating .xls on z/OS
>>
>>
Fri, 14 Sep 2012 06:44:23
> To:
> Reply-To: IBM Mainframe Discussion List
> Subject: Creating .xls on z/OS
>
> Hello all,
>
> I've been asked if there is the possibility to create Excel tables (.xls)
> files on z/OS,
> using a batch job. I've searc
W dniu 2012-09-14 23:08, Martin Packer pisze:
.CSV won't contain formulae. Don't know if that's what bothers the OP -
but it bothers ME as I'd like to generate them in REXX.
There are many things which cannot be kept in .CSV: graphs, complex
formula, column formatting, page setup, multiple spr
Excel:
=IF(D2>0,(F2-D2)," ") =IF(D2>0,(H2/D2)," ")
HTH
Peter
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Martin Packer
Sent: Friday, September 14, 2012 5:09 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subjec
Have you tried putting in =A1+B2 between commas for a cell value?
1,2,=SUM(A1:B1)
11,22,=SUM(A2:B2)
=SUM(A1:A2),=SUM(B1:B2),=A1+B2
On Fri, Sep 14, 2012 at 4:08 PM, Martin Packer wrote:
> .CSV won't contain formulae. Don't know if that's what bothers the OP -
> but it bothers ME as I'd like to ge
in_pac...@uk.ibm.com
Twitter / Facebook IDs: MartinPacker
Blog:
https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker
From:
"R.S."
To:
IBM-MAIN@listserv.ua.edu,
Date:
09/14/2012 08:23 PM
Subject:
Re: Creating .xls on z/OS
Sent by:
IBM Mainframe Discussion List
W
W dniu 2012-09-14 15:44, Walter Marguccio pisze:
Hello all,
I've been asked if there is the possibility to create Excel tables (.xls) files
on z/OS,
using a batch job. I've searched the archives, the developerwork IBM's site,
redbooks,
but found no clue.
We run the XMITIP tool which is able to
n
> Sent: Friday, September 14, 2012 8:51 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Creating .xls on z/OS
>
> Supposedly, but I haven't actually tried. Look at:
> http://poi.apache.org/
>
> The Apache POI Project's mission is to create and maintain Java APIs for
I have successfully used the java based jexcelapi.
http://jexcelapi.sourceforge.net/
Its open source.
Denis.
-Original Message-
From: Walter Marguccio
To: IBM-MAIN
Sent: Fri, Sep 14, 2012 3:44 pm
Subject: Creating .xls on z/OS
Hello all,
I've been asked if there i
Lizette,
I loved SAS, did a lot of network performance with SNA with it.
Scott ford
www.identityforge.com
On Sep 14, 2012, at 10:37 AM, Lizette Koehler wrote:
> John,
>
> I have used ODS in SAS and you can generate the XLS into a PDSE file that is
> then send (via email or other FTP to a sit
t: Friday, September 14, 2012 8:51 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Creating .xls on z/OS
Supposedly, but I haven't actually tried. Look at:
http://poi.apache.org/
The Apache POI Project's mission is to create and maintain Java APIs for
manipulating various file formats
f Lizette Koehler
> > Sent: Friday, September 14, 2012 9:38 AM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: Re: Creating .xls on z/OS
> >
> > John,
> >
> > I have used ODS in SAS and you can generate the XLS into a PDSE file
> > that is then send
: IBM Mainframe Discussion List
Date: Fri, 14 Sep 2012 06:44:23
To:
Reply-To: IBM Mainframe Discussion List
Subject: Creating .xls on z/OS
Hello all,
I've been asked if there is the possibility to create Excel tables (.xls) files
on z/OS,
using a batch job. I've se
e-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Lizette Koehler
> Sent: Friday, September 14, 2012 9:38 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Creating .xls on z/OS
>
> John,
>
> I have used ODS in SAS and you can gen
John,
I have used ODS in SAS and you can generate the XLS into a PDSE file that is
then send (via email or other FTP to a site) very easily.
>From the ODS manual
With ODS, you can produce tabular output , which can be viewed with Excel.
D\
Lizette
>
> I'm not sure, but looking at
> http:/
seeSM and The
MEGA Life and Health Insurance Company.SM
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Vernooij, CP - SPLXM
> Sent: Friday, September 14, 2012 9:21 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re
You don't have SAS? I believe it can.
Kees.
"Walter Marguccio" wrote in message
news:<1347630263.5695.yahoomail...@web114704.mail.gq1.yahoo.com>...
> Hello all,
>
> I've been asked if there is the possibility to create Excel tables (.xls)
> files on z/OS,
> using a batch job. I've searched
ber 14, 2012 9:13 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Creating .xls on z/OS
>
> Since you have Perl, I'd look into one of the dozens of brilliant CPAN
> modules, e.g. Spreadsheet::WriteExcel
>
> Regards,
> Boris
>
> -
Since you have Perl, I'd look into one of the dozens of brilliant CPAN modules,
e.g. Spreadsheet::WriteExcel
Regards,
Boris
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.ed
Please ignore my response about xsl - it looked like xls for a minute.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Walter Marguccio
Sent: Friday, September 14, 2012 9:44 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Creating .xls on z
The xml toolkit contains the xsl processer and sample xsl files.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Walter Marguccio
Sent: Friday, September 14, 2012 9:44 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Creating .xls on z/OS
On Fri, 14 Sep 2012 06:44:23 -0700, Walter Marguccio wrote:
>I've been asked if there is the possibility to create Excel tables (.xls)
>files on z/OS,
You might also see if .ods spreadsheets would be acceptable. A quick qoogle
search turns up lots of information about creating them. Here is
esseeSM and The
MEGA Life and Health Insurance Company.SM
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
> On Behalf Of Walter Marguccio
> Sent: Friday, September 14, 2012 8:44 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Cre
Hello all,
I've been asked if there is the possibility to create Excel tables (.xls) files
on z/OS,
using a batch job. I've searched the archives, the developerwork IBM's site,
redbooks,
but found no clue.
We run the XMITIP tool which is able to create .csv files, but this seems not
enough.
45 matches
Mail list logo
