If you are going to "offload" the work to Linux or even MS-Windows, I would *STRONGLY* suggest that you try to get your management to allow you to install Co:Z Hybrid Batch. It is cost-free, if you don't want any support. If you must have support, that is a cost option. Co:Z Hybrid Batch is a batch program which uses SSH to connect to the remote server. It then sends "in stream" commands over the SSH channel and get the command "stdout" and "stderr" back. For MS-Windows, you need to set up an SSH server because MS doesn't supply one. I would also suggest that you install all of the Co:Z product set. Especially Co:Z Data Set Pipes. That installs on both the z/OS system and the remote system. It has a "fromdsn" command which basically reads a DSN, or DD: allocated to the step ,and puts it out to STDOUT (for piping to other commands or redirection into a file). It also has a "todsn" command which takes STDIN and places it a DSN or out to a DD: allocated to the step.
http://dovetail.com/solutions.html I use it to back up my Linux/Intel desktop's ${HOME}. //PROCLIB JCLLIB ORDER=(SYS3.COZ.V2R1M1.SAMPJCL) //BACKUP EXEC PROC=COZPROC,ARGS='user@linux' //TAROUT DD DSN=&SYSUID..LINUX.HOME.TAR.BZ2(+1), // DISP=(NEW,CATLG,DELETE), // UNIT=VTS2,LABEL=EXPDT=99000, // RECFM=U,BLKSIZE=27998,DSORG=PS //STDIN DD * tar cvj . |\ todsn -b //DD:TAROUT exit /* //STDOUT DD SYSOUT=* //STDERR DD SYSOUT=* //CEEDUMP DD SYSOUT=* //SYSOUT DD SYSOUT=* -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets® 9151 Boulevard 26 • N. Richland Hills • TX 76010 (817) 255-3225 phone • [email protected] • www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets® is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. –The Chesapeake Life Insurance Company®, Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] > On Behalf Of Walter Marguccio > Sent: Monday, September 17, 2012 4:10 AM > To: [email protected] > Subject: Re: Creating .xls on z/OS > > > From: "McKown, John" <[email protected]> > > > > Supposedly, but I haven't actually tried. Look at: > > > http://poi.apache.org/ > > as always, thanks to everybody for your valuable input. > I'll try to answer to some of the questions which have been posed : > > we don't have SAS, nor DB2; > > .csv 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 > 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/OS, pure. But if we need to produce > 3,000 .pdf files, we offlload TXT2PDF's execution on a Linux box. > Likewise, we can think of producing the raw data > on z/OS, offloading the creation of a .xls on a Linux box, where the > availability of programs to create Excels is wider. > > Sam, may I try your Cobol/assembler API ? > > > Walter Marguccio > z/OS Systems Programmer > BELENUS LOB Informatic GmbH > Munich - Germany > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
