Re: z/OS V1.8 -- z/OS V1.13 , Any VSAM improvement is good for Batch I/O performance ?
W dniu 2012-09-14 08:29, Tsai Laurence pisze: Dear listers, as the subject, anybody knows ? Not much. See redbook VSAM Demistyfied for details. -- Radoslaw Skorupka Lodz, Poland -- Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku przeznaczone wycznie do uytku subowego adresata. Odbiorc moe by jedynie jej adresat z wyczeniem dostpu osób trzecich. Jeeli nie jeste adresatem niniejszej wiadomoci lub pracownikiem upowanionym do jej przekazania adresatowi, informujemy, e jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne dziaanie o podobnym charakterze jest prawnie zabronione i moe by karalne. Jeeli otrzymae t wiadomo omykowo, prosimy niezwocznie zawiadomi nadawc wysyajc odpowied oraz trwale usun t wiadomo wczajc w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorised to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. BRE Bank SA, 00-950 Warszawa, ul. Senatorska 18, tel. +48 (22) 829 00 00, fax +48 (22) 829 00 33, www.brebank.pl, e-mail: i...@brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237, NIP: 526-021-50-88. Wedug stanu na dzie 01.01.2012 r. kapita zakadowy BRE Banku SA (w caoci wpacony) wynosi 168.410.984 zotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/OS V1.8 -- z/OS V1.13 , Any VSAM improvement is good for Batch I/O performance ?
CA Reclaim is the one item I can think of. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Recovery , backup system in USB stick
Hi Is it possible , i.e. , to have a recovery backup z/OS system in USB stick ? (Currently we have the catastrophe recovery system in 3590 tapes in a bank safe , but it can be also in my pocket in an USB stick ). It is a z9 machine -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Recovery , backup system in USB stick
Miklos Szigetvari wrote: Is it possible , i.e. , to have a recovery backup z/OS system in USB stick ? Good lazy Friday question! ;-D In theory, yes, in fact any storage medium (CD/DVD/etc) will do. The trick is of course, how and in what format do you want to load and unload your data. It also depends what type of recovery do you want to do. What are you using to copy your data to/from your stick? (Currently we have the catastrophe recovery system in 3590 tapes in a bank safe, but it can be also in my pocket in an USB stick ). In a bank safe? If you need these tapes in a hurry at 02h59 local time, will the bank co-operate? Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Recovery , backup system in USB stick
W dniu 2012-09-14 10:10, Miklos Szigetvari pisze: Hi Is it possible , i.e. , to have a recovery backup z/OS system in USB stick ? (Currently we have the catastrophe recovery system in 3590 tapes in a bank safe , but it can be also in my pocket in an USB stick ). It is a z9 machine Yes Ok, seriously: Define recovery backup z/OS system. What kind of recovery do you want to perform? Even IPL-able USB stick containing whole system and applications and data is not a complete solution. What about IOCDS? Note: z/OS cannot be booted from neither USB stick, nor DVD, nor tape. Period. It is possible to boot standalone program from DVD or tape, or (maybe) USB stick. That's how COD (driver) works: you can start standalone program from DVD and restore 3390 images from DVD. I would prefer to have not so standalone z/OS image on few already restored 3390 volumes - it solves 90% possible problems. Remaining 10% consist of 99% - disaster (standalone program is unusable) and 1% some weird cases. ;-) My €0.02 -- Radoslaw Skorupka Lodz, Poland -- Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku przeznaczone wycznie do uytku subowego adresata. Odbiorc moe by jedynie jej adresat z wyczeniem dostpu osób trzecich. Jeeli nie jeste adresatem niniejszej wiadomoci lub pracownikiem upowanionym do jej przekazania adresatowi, informujemy, e jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne dziaanie o podobnym charakterze jest prawnie zabronione i moe by karalne. Jeeli otrzymae t wiadomo omykowo, prosimy niezwocznie zawiadomi nadawc wysyajc odpowied oraz trwale usun t wiadomo wczajc w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorised to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. BRE Bank SA, 00-950 Warszawa, ul. Senatorska 18, tel. +48 (22) 829 00 00, fax +48 (22) 829 00 33, www.brebank.pl, e-mail: i...@brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237, NIP: 526-021-50-88. Wedug stanu na dzie 01.01.2012 r. kapita zakadowy BRE Banku SA (w caoci wpacony) wynosi 168.410.984 zotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMPE: superseded products
On 9/13/2012 1:14 PM, Jousma, David wrote: Do something like this: //SMPCNTL DD * SET BDY(GLOBAL) . REJECT HOLDDATA NOFMID PRODUCT DELETEFMID (HKAH33T HWRE330 JWRE33C JWRE33I JWRE331). Except change the FMID's to your desired ones. If you're concerned about the PRODUCT and FEATURE entries in the global zone (which I think you are), then Dave's got it right with the REJECT command above. Kurt Quackenbush -- IBM, SMP/E Development -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Tivoli Performance Modeler for ZOS (v2.3)
You're not the only one with the problem. I don't remember all the details at the moment, but I think I eventually got somebody in IBM to point me to the FP 14 refresh download, which I was able to install, and then I was able to install FP15 over top of that. Clearly they have some issues with their packaging and delivery of the product. Scott On Thu, 13 Sep 2012 19:09:52 +, Hylton Tom P tom.p.hyl...@irs.gov wrote: I'm relatively new to TPM, and I can't seem to get any info from the horrid ibm support portal and most of the links to docs, support, and even passport advantage are invalid at the moment. Has anyone using it successfully installed FP15? I have V2.3 plus fp14 installed. I tried to install FP15 but it indicates I'm not on the correct version. Looking at the readme, it references Requires: Version 2 Release 3 Modification 0 refresh to be installed. I tried uninstalling with hopes of reinstalling base and then the FP15, but I'm still getting errors. My installed version doesn't have the word refresh in it, so I'm thinking that there might be a new base to download before installing fp15? As I said, passport advantage seems to have the same problem as IBMLINK telling me IE doesn't have authority to access it, so I can't get to it to look around, and would appreciate any pointers you may have to get me back quicker. Tia, tom -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: UTILITY TO READ SMF RECORDS
File 686 on the CBT 'tape' has a program called SMFDUMP that will format the output into a report. It takes in most of the SMF records. I use it to track down the same thing all the time. Betsy -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
Supposedly, but I haven't actually tried. Look at: http://poi.apache.org/ quote The Apache POI Project's mission is to create and maintain Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In short, you can read and write MS Excel files using Java. In addition, you can read and write MS Word and MS PowerPoint files using Java. Apache POI is your Java Excel solution (for Excel 97-2008). We have a complete API for porting other OOXML and OLE2 formats and welcome others to participate. OLE2 files include most Microsoft Office files such as XLS, DOC, and PPT as well as MFC serialization API based file formats. The project provides APIs for the OLE2 Filesystem (POIFS) and OLE2 Document Properties (HPSF). Office OpenXML Format is the new standards based XML file format found in Microsoft Office 2007 and 2008. This includes XLSX, DOCX and PPTX. The project provides a low level API to support the Open Packaging Conventions using openxml4j. For each MS Office application there exists a component module that attempts to provide a common high level Java api to both OLE2 and OOXML document formats. This is most developed for Excel workbooks (SS=HSSF+XSSF). Work is progressing for Word documents (HWPF+XWPF) and PowerPoint presentations (HSLF+XSLF). The project has recently added support for Outlook (HSMF). Microsoft opened the specifications to this format in October 2007. We would welcome contributions. There are also projects for Visio (HDGF), TNEF (HMEF), and Publisher (HPBF). As a general policy we collaborate as much as possible with other projects to provide this functionality. Examples include: Cocoon for which there are serializers for HSSF; Open Office.org with whom we collaborate in documenting the XLS format; and Tika / Lucene, for which we provide format interpretors. When practical, we donate components directly to those projects for POI-enabling them. /quote -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * john.mck...@healthmarkets.com * 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(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), 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: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: 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF Dataset CLOSE PENDING ISSUE
General note . Close Pending status for an SMF dataset is actually fairly normal but should NOT persist for very long. It basically means that SMF is still writing data out to that physical dataset but has logically reached the end of the file and is collecting/targetting its current input data to the 'next' dataset (which in this case there is none - which I suspect might have been the source of the issue). Second note .. you really should have procedures in place on the system to dump and CLEAR SMF datasets as soon they become FULL - you should never really have SMF datasets that are in dump required state. That's system data that has been collected and is just sitting there not being used for its intended purpose. IF for some reason there is no actual need for the data then just make sure to CLEAR the datasets as they become FULL. Third general thing . Close Pending is USUALLY an indication of a thru-put performance iusse with SMF - that is, the data is being collected as a FASTER rate than it is being physically written out to the SMF dataset. In most cases there might be a data spike that causes this sort of behavior instead of a sustained data rate issue; the other possiblity to consider is an I/O (performance) issue with the physical SMF dataset itself. Finally, as has already been noted if the problems persists then contact IBM Service. Thanks, Bill z/OS Development and Service -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: 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 one: http://www.ibm.com/developerworks/web/library/wa-odf/ .ods is the native spreadsheet format for OpenOffice, Libre Office and others. Microsoft has included support for it in their Office suite, though they try to push you to their formats. -- Tom Marchant -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF Dataset CLOSE PENDING ISSUE
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of William Richardson Sent: Friday, September 14, 2012 8:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMF Dataset CLOSE PENDING ISSUE General note . Close Pending status for an SMF dataset is actually fairly normal but should NOT persist for very long. It basically means that SMF is still writing data out to that physical dataset but has logically reached the end of the file and is collecting/targetting its current input data to the 'next' dataset (which in this case there is none - which I suspect might have been the source of the issue). Interesting to know about CLOSE PENDING. But I don't understand the explanation because, in the past, I have had all my SMF data sets fill up. In that case, SMF started buffering in memory and the last used MAN data set was DUMP REQUIRED. This was before I had CA-OPS/MVS issuing a command to start the STC which would dump the switched from MAN data set. It is also why I have a spare MAN data set already defined and EMPTY so that I can add a new one quickly. IIRC, I had to do this one time when SMF records were being created faster than they could be written to disk so every MAN data set filled up and I couldn't empty the fast enough. Second note .. you really should have procedures in place on the system to dump and CLEAR SMF datasets as soon they become FULL - you should never really have SMF datasets that are in dump required state. That's system data that has been collected and is just sitting there not being used for its intended purpose. IF for some reason there is no actual need for the data then just make sure to CLEAR the datasets as they become FULL. I agree. I used to have an IEFU29 exit, but found it easier to use a CA-OPS/MVS rule to start the dump process. Third general thing . Close Pending is USUALLY an indication of a thru-put performance iusse with SMF - that is, the data is being collected as a FASTER rate than it is being physically written out to the SMF dataset. In most cases there might be a data spike that causes this sort of behavior instead of a sustained data rate issue; the other possiblity to consider is an I/O (performance) issue with the physical SMF dataset itself. I was thinking that a hardware RESERVE on the volume containing the MAN data set from a different z/OS system might cause this. I have converted most of the hardware RESERVEs into GRS global ENQs. Finally, as has already been noted if the problems persists then contact IBM Service. Thanks, Bill z/OS Development and Service -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets® 9151 Boulevard 26 • N. Richland Hills • TX 76010 (817) 255-3225 phone • john.mck...@healthmarkets.com • 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
You don't have SAS? I believe it can. Kees. Walter Marguccio walter_marguc...@yahoo.com 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
I'm not sure, but looking at http://support.sas.com/rnd/base/ods/templateFAQ/Excel1.pdf quote There are several methods of generating Excel or spreadsheet files using the Output Delivery System. The first method that we will discuss is using the HTML destination to create the Excel or spreadsheet files. When you specify a procedure or data step within the ODS HTML statement with the .XLS or .CSV extensions, Microsoft Excel is opened in the Results Viewer. Excel is not an ODS destination and the fact that the file is opened in Excel is partially a product of ODS. The Results Viewer attempts to open the file based on the files registered extensions. By default the registered extensions of .XLS and .CSV belong to Excel on the PC. /quote it appears to me that SAS must be running on MS-Windows to generate a .xls output. -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * john.mck...@healthmarkets.com * 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(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), 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: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: Creating .xls on z/OS You don't have SAS? I believe it can. Kees. Walter Marguccio walter_marguc...@yahoo.com 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany - - For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM- MAIN For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e- mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
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 (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://support.sas.com/rnd/base/ods/templateFAQ/Excel1.pdf quote There are several methods of generating Excel or spreadsheet files using the Output Delivery System. The first method that we will discuss is using the HTML destination to create the Excel or spreadsheet files. When you specify a procedure or data step within the ODS HTML statement with the .XLS or .CSV extensions, Microsoft Excel is opened in the Results Viewer. Excel is not an ODS destination and the fact that the file is opened in Excel is partially a product of ODS. The Results Viewer attempts to open the file based on the files registered extensions. By default the registered extensions of .XLS and .CSV belong to Excel on the PC. /quote it appears to me that SAS must be running on MS-Windows to generate a .xls output. -- John McKown Systems Engineer IV -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
Thanks for the correction. That is a real XLS file, not just a file which can be opened in Excel (like CSV can be opened in Excel)? -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * john.mck...@healthmarkets.com * 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(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), 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: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 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
Walter - I have recently completed development of a COBOL and Assembler compatible API that allows the creation of full fidelity .xls and .xlsx spreadsheets. Below is a summary of supported functions. Full unicode support Ebcdic (all code pages) to unicode Packed, binary integers, ibm hex float Row oriented data insertion Cell oriented data insertion Jpeg, bmp image support Formulas Multiple tabs Lots more I also have a simple control card driven utility (built on the api) that allows a sequential file to be placed in a .xls or .xlsx format. I also have many sample COBOL and assembler programs for usage examples. There is no dependency on any third party products. No need for Java. The .xls and .xlsx file can be binary downloaded and opened directly by excel. Sam Sent from my Verizon Wireless BlackBerry -Original Message- From: Walter Marguccio walter_marguc...@yahoo.com Sender: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Date: Fri, 14 Sep 2012 06:44:23 To: IBM-MAIN@LISTSERV.UA.EDU Reply-To: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: loading cryptographic coprocessor key part registers
Frank, I would strongly recommend a checklist style with places for initials for each of the MK holders. Naming conventions - Your naming convention takes care of the test v.s. prod.. which is good. But how do you handle migrating from one key to another. Example. KEY1 is in use, KEY2 is the one that you have to switch to... Depending on what you are using the key for ... you may need both or need to replace the contents of KEY1 with KEY2 (think session keys... not data base encryption) The whole key management thing can make things difficult. Personally, I agree with separating test and production. However, you may find that there are some keys (think PKDS) that have to be the same in test and production. As previously discussed the ability to move keys from one PKDS to another using the KEYXFER tool is dependent on the MK being the same. Not to say that I think having the same MK for test and production is a good idea I would not recommend it it is just a reminder that you may need to consider other options if the key needs to be the same in both places. The security for keys will be made much easier if you keep them separated name-wise. You will regret choosing the same name for test and production (only seems like a good idea... but your security folks will stage a revolt ... tar and feathering may be involved.) I am making an assumption that the security rules / security data base being the same between test and production. I am personally a fan of doing things one way. Centralizing databases and rules means that even if you make a mistake.. and production ends up in test for example ... then the same rules are always in effect. Additionally, I would suggest implementing some of the newer controls for CSFKEYS which allow for a bit more granularity that the old method of READ or NONE. Also, I would consider using the Protected key if performance is a consideration. This topic has been discussed at some length on this list. Are you running more than one production LPAR that is going to share keys? I have personally been thru a conversion from using Thales security modules to using the Crypto Express cards. It is awesome. Rob Schramm Senior Systems Consultant Imperium Group On Thu, Sep 13, 2012 at 8:39 PM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: All of our TN3270 traffic is SSL encrypted. I will definitely be documenting everything! We have a naming convention as suggested by our vendor, but if you have any particular good practices I'd love to hear them. Your point about DR is also well taken. We'll have to discuss that. Another question, since I've got your attention. Our vendor mentions that at all of their other customers the CKDS/PKDS are shared between production and non-production. It wasn't clear to me if this was because they run prod and non-prod in the same LPAR or for some other reason (such as perhaps they didn't know any better). Because of this they had keys with names like KEKKIM.TEST.ABCD and KEKKIM.PROD.ABCD. We, on the other hand, will have production in one crypto region with it's own CKDS/PKDS, totally separate from non-production. This seems the obvious, best way to go, but I'm curious what others have to say. Because of this we could have both a production and a non-production key with the same label name, but they would not refer to the same actual key value. (One could not access the production keys from a non-prod LPAR.) Thanks! Frank From: Rob Schramm rob.schr...@gmail.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, September 13, 2012 5:54 PM Subject: Re: loading cryptographic coprocessor key part registers I am hoping that you have already considered the need for encrypting the TSO session. Additionally, having the procedure actually documented before entering your production MK is a really good idea. Also, secured key part storage onsite as well as offsite for disaster recovery. Also, naming convention for the operational keys is critical!!! Rob Schramm On Sep 13, 2012 5:50 PM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: Looks like we found a solution: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS189. Frank From: Frank Swarbrick frank.swarbr...@yahoo.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, September 13, 2012 12:43 PM Subject: loading cryptographic coprocessor key part registers We are migrating our PIN/card security process to use ICSF and a Crypto3 card. All of our vendor's other customers have used the TKE Workstation to load their operational keys (in multiple key part/component format). We were not planning on purchasing the TKE feature. But I cannot see any way outside of TKE to enter operational key components in to the cryptographic coprocessor's keypartregisters outside of using TKE. Help! Frank
Re: loading cryptographic coprocessor key part registers
One more note... While you can do the keys via panels, it is not as secure as doing it via TKE. Rob Schramm Senior Systems Consultant Imperium Group On Fri, Sep 14, 2012 at 10:55 AM, Rob Schramm rob.schr...@gmail.com wrote: Frank, I would strongly recommend a checklist style with places for initials for each of the MK holders. Naming conventions - Your naming convention takes care of the test v.s. prod.. which is good. But how do you handle migrating from one key to another. Example. KEY1 is in use, KEY2 is the one that you have to switch to... Depending on what you are using the key for ... you may need both or need to replace the contents of KEY1 with KEY2 (think session keys... not data base encryption) The whole key management thing can make things difficult. Personally, I agree with separating test and production. However, you may find that there are some keys (think PKDS) that have to be the same in test and production. As previously discussed the ability to move keys from one PKDS to another using the KEYXFER tool is dependent on the MK being the same. Not to say that I think having the same MK for test and production is a good idea I would not recommend it it is just a reminder that you may need to consider other options if the key needs to be the same in both places. The security for keys will be made much easier if you keep them separated name-wise. You will regret choosing the same name for test and production (only seems like a good idea... but your security folks will stage a revolt ... tar and feathering may be involved.) I am making an assumption that the security rules / security data base being the same between test and production. I am personally a fan of doing things one way. Centralizing databases and rules means that even if you make a mistake.. and production ends up in test for example ... then the same rules are always in effect. Additionally, I would suggest implementing some of the newer controls for CSFKEYS which allow for a bit more granularity that the old method of READ or NONE. Also, I would consider using the Protected key if performance is a consideration. This topic has been discussed at some length on this list. Are you running more than one production LPAR that is going to share keys? I have personally been thru a conversion from using Thales security modules to using the Crypto Express cards. It is awesome. Rob Schramm Senior Systems Consultant Imperium Group On Thu, Sep 13, 2012 at 8:39 PM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: All of our TN3270 traffic is SSL encrypted. I will definitely be documenting everything! We have a naming convention as suggested by our vendor, but if you have any particular good practices I'd love to hear them. Your point about DR is also well taken. We'll have to discuss that. Another question, since I've got your attention. Our vendor mentions that at all of their other customers the CKDS/PKDS are shared between production and non-production. It wasn't clear to me if this was because they run prod and non-prod in the same LPAR or for some other reason (such as perhaps they didn't know any better). Because of this they had keys with names like KEKKIM.TEST.ABCD and KEKKIM.PROD.ABCD. We, on the other hand, will have production in one crypto region with it's own CKDS/PKDS, totally separate from non-production. This seems the obvious, best way to go, but I'm curious what others have to say. Because of this we could have both a production and a non-production key with the same label name, but they would not refer to the same actual key value. (One could not access the production keys from a non-prod LPAR.) Thanks! Frank From: Rob Schramm rob.schr...@gmail.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, September 13, 2012 5:54 PM Subject: Re: loading cryptographic coprocessor key part registers I am hoping that you have already considered the need for encrypting the TSO session. Additionally, having the procedure actually documented before entering your production MK is a really good idea. Also, secured key part storage onsite as well as offsite for disaster recovery. Also, naming convention for the operational keys is critical!!! Rob Schramm On Sep 13, 2012 5:50 PM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: Looks like we found a solution: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS189. Frank From: Frank Swarbrick frank.swarbr...@yahoo.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, September 13, 2012 12:43 PM Subject: loading cryptographic coprocessor key part registers We are migrating our PIN/card security process to use ICSF and a Crypto3 card. All of our vendor's other customers have used the TKE Workstation to load their operational keys (in multiple key part/component format). We
Re: Creating .xls on z/OS
John, Not truly my area of expertise. I know it works. But from the z/OS Companion for SAS has a description. The SAS Output Delivery System can be used to generate graphical reports of your SAS data. Remote browsing enables you to view your output directly from the SAS session, either in real time as the output is generated, or on demand from the Results window. Remote browsing displays ODS output that is generated to z/OS native data sets (sequential, PDS, or PDSE) or a UFS directory. HTML, PDF, RTF, and XLS file types are displayed with the remote browsing system. If your browser does not have the appropriate plug-in for non-HTML data types, it will display a download dialog box rather than the actual data. This dialog box will enable you to download the report to your PC and view it using a local program, such as Excel for an XLS file. Note: When images or graphics are written to az/OS native data set and remote browsing is being used to view the output, the URL=NONE option should not be used with the ODS statement. Using this option causes the HTML to be written with incomplete filenames, and the remote browsing system is not able to determine the location of the image or graphics. When this situation occurs, the browser displays broken image icons in the HTML output. You might find it helpful to save another software vendor's file to a DBF file and then convert that file into a SAS data set. For example, you could save an Excel XLS file in DBF format, upload the file, and use PROC DBF to convert that file into a SAS data set. Or you could do the reverse; use PROC DBF to convert a SAS data set into a DBF file and then load that file into an Excel spreadsheet. The process I have used is to generate an RTF file on the mainframe and then using SAS EMAIL process, email that result. Then when my recipients open the email, the RTF shows up in the Browser. I have seen several SAS papers on Mainframe to Excel processes. SAS also has a Microsoft plugin that allows you to use SAS to extract the data you want while in Excel prior to allowing Excel to present the data. Basically you write the output from SAS in a different format (XLS, RTF, HTML, PDF, RTF) to an HFS or PDSE file (I have not worked with ODS with other file types). And it works. I do not know how the ODS engine works to make the magic happen. If you would like a sample SAS code, write me offlist and I will share. Lizette Thanks for the correction. That is a real XLS file, not just a file which can be opened in Excel (like CSV can be opened in Excel)? -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * john.mck...@healthmarkets.com * 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(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), 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: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 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
Hi, I am looking for a jcl to change the expiration date of some tapes in CA TLMS. This partition is running z/OS 1.12. I looked at the user guide for an example but I didn't find any. Perhaps I missed it. Could anybody help me out please? Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
I've used POI to create simple, straightforward spreadsheets and it works fine. The program is easy enough although I'm not sure what complications have been introduced with Excel 2007. Robert Crawford CICS Technical Support United Services Automobile Association (210) 913-3822 For Service Requests please use our Customer Portal. Seek not to follow in the footsteps of the wise; seek what they sought. - Matsuo Basho, poet (1644-1694) -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of McKown, John 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/ quote The Apache POI Project's mission is to create and maintain Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In short, you can read and write MS Excel files using Java. In addition, you can read and write MS Word and MS PowerPoint files using Java. Apache POI is your Java Excel solution (for Excel 97-2008). We have a complete API for porting other OOXML and OLE2 formats and welcome others to participate. OLE2 files include most Microsoft Office files such as XLS, DOC, and PPT as well as MFC serialization API based file formats. The project provides APIs for the OLE2 Filesystem (POIFS) and OLE2 Document Properties (HPSF). Office OpenXML Format is the new standards based XML file format found in Microsoft Office 2007 and 2008. This includes XLSX, DOCX and PPTX. The project provides a low level API to support the Open Packaging Conventions using openxml4j. For each MS Office application there exists a component module that attempts to provide a common high level Java api to both OLE2 and OOXML document formats. This is most developed for Excel workbooks (SS=HSSF+XSSF). Work is progressing for Word documents (HWPF+XWPF) and PowerPoint presentations (HSLF+XSLF). The project has recently added support for Outlook (HSMF). Microsoft opened the specifications to this format in October 2007. We would welcome contributions. There are also projects for Visio (HDGF), TNEF (HMEF), and Publisher (HPBF). As a general policy we collaborate as much as possible with other projects to provide this functionality. Examples include: Cocoon for which there are serializers for HSSF; Open Office.org with whom we collaborate in documenting the XLS format; and Tika / Lucene, for which we provide format interpretors. When practical, we donate components directly to those projects for POI-enabling them. /quote -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * john.mck...@healthmarkets.com * 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(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), 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: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: 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
Here's what I use: //* //TLMSPROC JCLLIB ORDER='OEM#P.CAI.TLMS.R11.CAIPROC' //STEP010 EXEC CATRPTS //SYSOUTDD SYSOUT=X //SYSIN DD * UPV volser,EXPDT=juliandate /* * * *George Rodriguez* *Specialist II - IT Solutions* *Application Support / Quality Assurance* *PX - 47652* *(561) 357-7652 (office)* *(561) 707-3496 (mobile)* *School District of Palm Beach County* *3348 Forest Hill Blvd.* *Room B-251* *West Palm Beach, FL. 33406-5869* *Florida's Only A-Rated Urban District For Eight Consecutive Years* On Fri, Sep 14, 2012 at 11:28 AM, willie bunter williebun...@yahoo.comwrote: Hi, I am looking for a jcl to change the expiration date of some tapes in CA TLMS. This partition is running z/OS 1.12. I looked at the user guide for an example but I didn't find any. Perhaps I missed it. Could anybody help me out please? Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- *Accredited District Since 2008; Re-certification - January 2013* Home of Florida's first LEED Gold Certified School Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
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 stars...@mindspring.com 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 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://support.sas.com/rnd/base/ods/templateFAQ/Excel1.pdf quote There are several methods of generating Excel or spreadsheet files using the Output Delivery System. The first method that we will discuss is using the HTML destination to create the Excel or spreadsheet files. When you specify a procedure or data step within the ODS HTML statement with the .XLS or .CSV extensions, Microsoft Excel is opened in the Results Viewer. Excel is not an ODS destination and the fact that the file is opened in Excel is partially a product of ODS. The Results Viewer attempts to open the file based on the files registered extensions. By default the registered extensions of .XLS and .CSV belong to Excel on the PC. /quote it appears to me that SAS must be running on MS-Windows to generate a .xls output. -- John McKown Systems Engineer IV -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
Willie, The support group at CA should be more than able to help you with this. I have opened cases to CA on just these types of questions to CA1. I am sure TLMS will be just as good. Lizette TAPE Hi, I am looking for a jcl to change the expiration date of some tapes in CA TLMS. This partition is running z/OS 1.12. I looked at the user guide for an example but I didn't find any. Perhaps I missed it. Could anybody help me out please? Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
Willie, Please open an issue with Level 1 support. We need to determine how the particular volume(s) is being retained. Just changing the KEEPDATE may not change the retention if the volume is retained by another retention method, catalog control for example. Pat Hughes - TLMS Level II Pat On Sep 14, 2012, at 10:28 AM, willie bunter williebun...@yahoo.com wrote: Hi, I am looking for a jcl to change the expiration date of some tapes in CA TLMS. This partition is running z/OS 1.12. I looked at the user guide for an example but I didn't find any. Perhaps I missed it. Could anybody help me out please? Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: loading cryptographic coprocessor key part registers
Frank, That is not true. Try option k. But the only reason you would need it would be if you need to store the operational key parts outside of the mainframe. Also, KGUP should support key part entry... although it is one of the oldest interfaces for ICSF. Auto generating keys is probably be the best if the keys are not required outside of the mainframe. Although you should be able to leverage a transport key or temporary session key if you need to exchange the key. The problems are that the management of the operational key parts are not really being managed outside of some interface like TKE or DKMS. TKE can actually enforce the presence of multiple people for key entry. DKMS has a whole host of ways of actually managing key materials. Rob Schramm Senior Systems Consultant Imperium Group On Fri, Sep 14, 2012 at 11:34 AM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: Key part entering is available in ICSF's ISPF interface only for master keys, not for operational keys. Bizarre but true. Operational keys can only be entered in full (not parts) or simply generated. From: Mark Jacobs mark.jac...@custserv.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, September 13, 2012 1:30 PM Subject: Re: loading cryptographic coprocessor key part registers ICSF has an ISPF interface that you'll use to enter the key parts. On 09/13/12 14:43, Frank Swarbrick wrote: We are migrating our PIN/card security process to use ICSF and a Crypto3 card. All of our vendor's other customers have used the TKE Workstation to load their operational keys (in multiple key part/component format). We were not planning on purchasing the TKE feature. But I cannot see any way outside of TKE to enter operational key components in to the cryptographic coprocessor's keypartregisters outside of using TKE. Help! Frank -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Mark Jacobs Time Customer Service Tampa, FL The quiet ones are the ones that change the universe... The loud ones only take the credit. Londo Mollari - Babylon 5 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
I have successfully used the java based jexcelapi. http://jexcelapi.sourceforge.net/ Its open source. Denis. -Original Message- From: Walter Marguccio walter_marguc...@yahoo.com To: IBM-MAIN IBM-MAIN@LISTSERV.UA.EDU Sent: Fri, Sep 14, 2012 3:44 pm 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
George, Thanks. Once this is run do I need to do anything else for example run a scratch report etc? I noticed in the user guide it says to run CATINQPR proc. I noticed that you are using CATRPTS. Is that okay? From: George Rodriguez george.rodrig...@palmbeachschools.org To: IBM-MAIN@LISTSERV.UA.EDU Sent: Friday, September 14, 2012 11:44:03 AM Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE Here's what I use: //* //TLMSPROC JCLLIB ORDER='OEM#P.CAI.TLMS.R11.CAIPROC' //STEP010 EXEC CATRPTS //SYSOUT DD SYSOUT=X //SYSIN DD * UPV volser,EXPDT=juliandate /* * * *George Rodriguez* *Specialist II - IT Solutions* *Application Support / Quality Assurance* *PX - 47652* *(561) 357-7652 (office)* *(561) 707-3496 (mobile)* *School District of Palm Beach County* *3348 Forest Hill Blvd.* *Room B-251* *West Palm Beach, FL. 33406-5869* *Florida's Only A-Rated Urban District For Eight Consecutive Years* On Fri, Sep 14, 2012 at 11:28 AM, willie bunter williebun...@yahoo.comwrote: Hi, I am looking for a jcl to change the expiration date of some tapes in CA TLMS. This partition is running z/OS 1.12. I looked at the user guide for an example but I didn't find any. Perhaps I missed it. Could anybody help me out please? Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- *Accredited District Since 2008; Re-certification - January 2013* Home of Florida's first LEED Gold Certified School Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
Wouldn't that depend on why you are changing the date? What is the real issue for which a date change is your chosen solution? :: -Original Message- :: From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On :: Behalf Of willie bunter :: Sent: Friday, September 14, 2012 9:50 AM :: To: IBM-MAIN@LISTSERV.UA.EDU :: Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE :: :: George, :: :: Thanks. Once this is run do I need to do anything else for example run :: a scratch report etc? I noticed in the user guide it says to run :: CATINQPR proc. :: I noticed that you are using CATRPTS. Is that okay? :: :: :: :: From: George Rodriguez george.rodrig...@palmbeachschools.org :: To: IBM-MAIN@LISTSERV.UA.EDU :: Sent: Friday, September 14, 2012 11:44:03 AM :: Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE :: :: Here's what I use: :: :: //* :: //TLMSPROC JCLLIB ORDER='OEM#P.CAI.TLMS.R11.CAIPROC' :: //STEP010 EXEC CATRPTS :: //SYSOUT DD SYSOUT=X :: //SYSIN DD * :: UPV volser,EXPDT=juliandate :: /* :: :: * :: * :: *George Rodriguez* :: *Specialist II - IT Solutions* :: *Application Support / Quality Assurance* :: *PX - 47652* :: *(561) 357-7652 (office)* :: *(561) 707-3496 (mobile)* :: *School District of Palm Beach County* :: *3348 Forest Hill Blvd.* :: *Room B-251* :: *West Palm Beach, FL. 33406-5869* :: *Florida's Only A-Rated Urban District For Eight Consecutive Years* :: :: :: :: On Fri, Sep 14, 2012 at 11:28 AM, willie bunter :: williebun...@yahoo.comwrote: :: :: Hi, :: :: I am looking for a jcl to change the expiration date of some tapes in :: CA :: TLMS. This partition is running z/OS 1.12. I looked at the user :: guide for :: an example but I didn't find any. Perhaps I missed it. Could anybody :: help :: me out please? :: :: Thanks. :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN :: :: :: -- :: :: :: *Accredited District Since 2008; Re-certification - January 2013* :: :: Home of Florida's first LEED Gold Certified School :: :: Under Florida law, e-mail addresses are public records. If you do not :: want :: your e-mail address released in response to a public records request, do :: not send electronic mail to this entity. Instead, contact this office by :: phone or in writing. :: :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
Willie, CATINQR/TLMSINQR is the only supported PROC/Program in current releases of TLMS (12.0 12.5). It has not been officially supported for the majority of the TLMS reports and updated since release 5.5. It was provided through release 12.0 to allow clients time to modify all their JCL. When TLMS is upgraded to release 12.6, all JCL/PROCS referencing TLMSRPTS will receive a S806 abend. If anyone is preparing to convert to release 12.6 and needs to identify the use of obsolete programs, please contact Level I support. We will supply a utility that will scan SMF Type 30 records to identify JOBS using obsolete programs. Regards, Pat Hughes - TLMS Level II Pat On Sep 14, 2012, at 11:49 AM, willie bunter williebun...@yahoo.com wrote: George, Thanks. Once this is run do I need to do anything else for example run a scratch report etc? I noticed in the user guide it says to run CATINQPR proc. I noticed that you are using CATRPTS. Is that okay? From: George Rodriguez george.rodrig...@palmbeachschools.org To: IBM-MAIN@LISTSERV.UA.EDU Sent: Friday, September 14, 2012 11:44:03 AM Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE Here's what I use: //* //TLMSPROC JCLLIB ORDER='OEM#P.CAI.TLMS.R11.CAIPROC' //STEP010 EXEC CATRPTS //SYSOUTDD SYSOUT=X //SYSINDD * UPV volser,EXPDT=juliandate /* * * *George Rodriguez* *Specialist II - IT Solutions* *Application Support / Quality Assurance* *PX - 47652* *(561) 357-7652 (office)* *(561) 707-3496 (mobile)* *School District of Palm Beach County* *3348 Forest Hill Blvd.* *Room B-251* *West Palm Beach, FL. 33406-5869* *Florida's Only A-Rated Urban District For Eight Consecutive Years* On Fri, Sep 14, 2012 at 11:28 AM, willie bunter williebun...@yahoo.comwrote: Hi, I am looking for a jcl to change the expiration date of some tapes in CA TLMS. This partition is running z/OS 1.12. I looked at the user guide for an example but I didn't find any. Perhaps I missed it. Could anybody help me out please? Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- *Accredited District Since 2008; Re-certification - January 2013* Home of Florida's first LEED Gold Certified School Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
Robert, I like the idea of OpenOffice also ring able to create Excel spreadsheets, it ales a lot of sense to me. Scott ford www.identityforge.com On Sep 14, 2012, at 11:41 AM, Crawford, Robert C. robert.crawf...@usaa.com wrote: I've used POI to create simple, straightforward spreadsheets and it works fine. The program is easy enough although I'm not sure what complications have been introduced with Excel 2007. Robert Crawford CICS Technical Support United Services Automobile Association (210) 913-3822 For Service Requests please use our Customer Portal. Seek not to follow in the footsteps of the wise; seek what they sought. - Matsuo Basho, poet (1644-1694) -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of McKown, John 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/ quote The Apache POI Project's mission is to create and maintain Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In short, you can read and write MS Excel files using Java. In addition, you can read and write MS Word and MS PowerPoint files using Java. Apache POI is your Java Excel solution (for Excel 97-2008). We have a complete API for porting other OOXML and OLE2 formats and welcome others to participate. OLE2 files include most Microsoft Office files such as XLS, DOC, and PPT as well as MFC serialization API based file formats. The project provides APIs for the OLE2 Filesystem (POIFS) and OLE2 Document Properties (HPSF). Office OpenXML Format is the new standards based XML file format found in Microsoft Office 2007 and 2008. This includes XLSX, DOCX and PPTX. The project provides a low level API to support the Open Packaging Conventions using openxml4j. For each MS Office application there exists a component module that attempts to provide a common high level Java api to both OLE2 and OOXML document formats. This is most developed for Excel workbooks (SS=HSSF+XSSF). Work is progressing for Word documents (HWPF+XWPF) and PowerPoint presentations (HSLF+XSLF). The project has recently added support for Outlook (HSMF). Microsoft opened the specifications to this format in October 2007. We would welcome contributions. There are also projects for Visio (HDGF), TNEF (HMEF), and Publisher (HPBF). As a general policy we collaborate as much as possible with other projects to provide this functionality. Examples include: Cocoon for which there are serializers for HSSF; Open Office.org with whom we collaborate in documenting the XLS format; and Tika / Lucene, for which we provide format interpretors. When practical, we donate components directly to those projects for POI-enabling them. /quote -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * john.mck...@healthmarkets.com * 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(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), 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: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: 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
All, the various solutions given are the reason I suggested the OP contact CA Support. Since we have various solutions, and also the most important question, WHY?, I will try to explain some parts of TLMS Retention processing. 1. VOLUME level KEEPDATE/EXPDT values (UPV) are not used by TLMS retention processing, and only reflect the maximum KEEPDATE (determined at data set close by TLMS) or EXPDT (determined by EXPDT=\RETPD= in JCL. These fields are not updated by changes to data set KEEPDATE/ EXPDT updates by either TLMSTRS or manual/online updates. However, the fields may be tested in User Exits and reported upon using CA EARL. 2. Data set level EXPDT is only used by the retention system if there is no Retention Master File entry that matches the data set name of the CDS (Controlling Data Set). 3. Data set KEEPDATE will be used if the retention type assigned to the controlling data set uses the KEEPDATE (Types 2,3,B,C). 3. The only certain solution is to use the UPV vv,SCHED= command. It will never be changed by the Tape Retention System. Regards, Pat Hughes Pat On Sep 14, 2012, at 12:08 PM, retired mainframer retired-mainfra...@q.com wrote: Wouldn't that depend on why you are changing the date? What is the real issue for which a date change is your chosen solution? :: -Original Message- :: From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On :: Behalf Of willie bunter :: Sent: Friday, September 14, 2012 9:50 AM :: To: IBM-MAIN@LISTSERV.UA.EDU :: Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE :: :: George, :: :: Thanks. Once this is run do I need to do anything else for example run :: a scratch report etc? I noticed in the user guide it says to run :: CATINQPR proc. :: I noticed that you are using CATRPTS. Is that okay? :: :: :: :: From: George Rodriguez george.rodrig...@palmbeachschools.org :: To: IBM-MAIN@LISTSERV.UA.EDU :: Sent: Friday, September 14, 2012 11:44:03 AM :: Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE :: :: Here's what I use: :: :: //* :: //TLMSPROC JCLLIB ORDER='OEM#P.CAI.TLMS.R11.CAIPROC' :: //STEP010 EXEC CATRPTS :: //SYSOUTDD SYSOUT=X :: //SYSINDD * :: UPV volser,EXPDT=juliandate :: /* :: :: * :: * :: *George Rodriguez* :: *Specialist II - IT Solutions* :: *Application Support / Quality Assurance* :: *PX - 47652* :: *(561) 357-7652 (office)* :: *(561) 707-3496 (mobile)* :: *School District of Palm Beach County* :: *3348 Forest Hill Blvd.* :: *Room B-251* :: *West Palm Beach, FL. 33406-5869* :: *Florida's Only A-Rated Urban District For Eight Consecutive Years* :: :: :: :: On Fri, Sep 14, 2012 at 11:28 AM, willie bunter :: williebun...@yahoo.comwrote: :: :: Hi, :: :: I am looking for a jcl to change the expiration date of some tapes in :: CA :: TLMS. This partition is running z/OS 1.12. I looked at the user :: guide for :: an example but I didn't find any. Perhaps I missed it. Could anybody :: help :: me out please? :: :: Thanks. :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN :: :: :: -- :: :: :: *Accredited District Since 2008; Re-certification - January 2013* :: :: Home of Florida's first LEED Gold Certified School :: :: Under Florida law, e-mail addresses are public records. If you do not :: want :: your e-mail address released in response to a public records request, do :: not send electronic mail to this entity. Instead, contact this office by :: phone or in writing. :: :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE
That's it and yes, that's the program used by TLMS to set dates. My recommendation is try one, then use eith TI or TLMS volume display to see if the EXPDT is set to what you want. On Friday, September 14, 2012 x-apple-data-detectors://19, Pat Hughes1 wrote: All, the various solutions given are the reason I suggested the OP contact CA Support. Since we have various solutions, and also the most important question, WHY?, I will try to explain some parts of TLMS Retention processing. 1. VOLUME level KEEPDATE/EXPDT values (UPV) are not used by TLMS retention processing, and only reflect the maximum KEEPDATE (determined at data set close by TLMS) or EXPDT (determined by EXPDT=\RETPD= in JCL. These fields are not updated by changes to data set KEEPDATE/ EXPDT updates by either TLMSTRS or manual/online updates. However, the fields may be tested in User Exits and reported upon using CA EARL. 2. Data set level EXPDT is only used by the retention system if there is no Retention Master File entry that matches the data set name of the CDS (Controlling Data Set). 3. Data set KEEPDATE will be used if the retention type assigned to the controlling data set uses the KEEPDATE (Types 2,3,B,C). 3. The only certain solution is to use the UPV vv,SCHED= command. It will never be changed by the Tape Retention System. Regards, Pat Hughes Pat On Sep 14, 2012, at 12:08 PM, retired mainframer retired-mainfra...@q.com wrote: Wouldn't that depend on why you are changing the date? What is the real issue for which a date change is your chosen solution? :: -Original Message- :: From: IBM Mainframe Discussion List [mailto:ibm-m...@listserv.ua.IBM-MAIN@LISTSERV.UA.EDU EDU IBM-MAIN@LISTSERV.UA.EDU] On :: Behalf Of willie bunter :: Sent: Friday, September 14, 2012 9:50 AM :: To: IBM-MAIN@LISTSERV.UA.EDU :: Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE :: :: George, :: :: Thanks. Once this is run do I need to do anything else for example run :: a scratch report etc? I noticed in the user guide it says to run :: CATINQPR proc. :: I noticed that you are using CATRPTS. Is that okay? :: :: :: :: From: George Rodriguez george.rodriguez@george.rodrig...@palmbeachschools.org PALMBEACHSCHOOLS.ORG george.rodrig...@palmbeachschools.org :: To: IBM-MAIN@LISTSERV.UA.EDU :: Sent: Friday, September 14, 2012 11:44:03 AM :: Subject: Re: LOOKING FOR JCL - TLMS : CHANGE EXPIRATION DATE OF A TAPE :: :: Here's what I use: :: :: //* :: //TLMSPROC JCLLIB ORDER='OEM#P.CAI.TLMS.R11.CAIPROC' :: //STEP010 EXEC CATRPTS :: //SYSOUTDD SYSOUT=X :: //SYSINDD * :: UPV volser,EXPDT=juliandate :: /* :: :: * :: * :: *George Rodriguez* :: *Specialist II - IT Solutions* :: *Application Support / Quality Assurance* :: *PX - 47652* :: *(561) 357-7652 (office)* :: *(561) 707-3496 (mobile)* :: *School District of Palm Beach County* :: *3348 Forest Hill Blvd.* :: *Room B-251* :: *West Palm Beach, FL. 33406-5869* :: *Florida's Only A-Rated Urban District For Eight Consecutive Years* :: :: :: :: On Fri, Sep 14, 2012 at 11:28 AM, willie bunter :: williebun...@yahoo.comwrote: :: :: Hi, :: :: I am looking for a jcl to change the expiration date of some tapes in :: CA :: TLMS. This partition is running z/OS 1.12. I looked at the user :: guide for :: an example but I didn't find any. Perhaps I missed it. Could anybody :: help :: me out please? :: :: Thanks. :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN :: :: :: -- :: :: :: *Accredited District Since 2008; Re-certification - January 2013* :: :: Home of Florida's first LEED Gold Certified School :: :: Under Florida law, e-mail addresses are public records. If you do not :: want :: your e-mail address released in response to a public records request, do :: not send electronic mail to this entity. Instead, contact this office by :: phone or in writing. :: :: :: -- :: For IBM-MAIN subscribe / signoff / archive access instructions, :: send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN :: :: - -- * * *George Rodriguez* *Specialist II - IT Solutions* *Application Support / Quality Assurance* *PX - 47652* *(561) 357-7652 (office)* *(561) 707-3496 (mobile)* *School District of Palm Beach County* *3348 Forest Hill Blvd.* *Room B-251* *West Palm Beach, FL. 33406-5869* *Florida's Only A-Rated Urban District For Eight Consecutive Years* -- *Accredited District
Re: Creating .xls on z/OS
.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. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: R.S. r.skoru...@bremultibank.com.pl 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 IBM-MAIN@listserv.ua.edu 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 create .csv files, but this seems not enough. Just curious: why .CSV is not enough? What features do you expect? Drawings? -- Radoslaw Skorupka Lodz, Poland -- Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku przeznaczone wycznie do uytku subowego adresata. Odbiorc moe by jedynie jej adresat z wyczeniem dostpu osób trzecich. Jeeli nie jeste adresatem niniejszej wiadomoci lub pracownikiem upowanionym do jej przekazania adresatowi, informujemy, e jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne dziaanie o podobnym charakterze jest prawnie zabronione i moe by karalne. Jeeli otrzymae t wiadomo omykowo, prosimy niezwocznie zawiadomi nadawc wysyajc odpowied oraz trwale usun t wiadomo wczajc w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorised to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. BRE Bank SA, 00-950 Warszawa, ul. Senatorska 18, tel. +48 (22) 829 00 00, fax +48 (22) 829 00 33, www.brebank.pl, e-mail: i...@brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237, NIP: 526-021-50-88. Wedug stanu na dzie 01.01.2012 r. kapita zakadowy BRE Banku SA (w caoci wpacony) wynosi 168.410.984 zotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
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 martin_pac...@uk.ibm.com 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 generate them in REXX. Cheers, Martin Martin Packer, -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
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(D20,(F2-D2), ),=IF(D20,(H2/D2), ), I found that I have to surround the formula with double quotes (because of the embedded spaces) and double any embedded double quotes for Excel to interpret the CSV formula correctly and generate the calculated result. The above cells look like this once the file is downloaded from z/OS to the PC and opened by Excel: =IF(D20,(F2-D2), ) =IF(D20,(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 Subject: Re: Creating .xls on z/OS .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. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: R.S. r.skoru...@bremultibank.com.pl 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 IBM-MAIN@listserv.ua.edu 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 create .csv files, but this seems not enough. Just curious: why .CSV is not enough? What features do you expect? Drawings? -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
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 spreadsheets in one file, etc. etc. However I can't imagine which of the features have to be created on mainframe side. Usually a mainframe dataset contains some data (records), which can be easily converted to .csv file. In this case there is no big sense to bother with .XLS details. Of course the data can be a source for nice graph for CEO, but why to create all the bell and whistles on z/OS side? I would look for some tools on PC side. -- Radoslaw Skorupka Lodz, Poland -- Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku przeznaczone wycznie do uytku subowego adresata. Odbiorc moe by jedynie jej adresat z wyczeniem dostpu osób trzecich. Jeeli nie jeste adresatem niniejszej wiadomoci lub pracownikiem upowanionym do jej przekazania adresatowi, informujemy, e jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne dziaanie o podobnym charakterze jest prawnie zabronione i moe by karalne. Jeeli otrzymae t wiadomo omykowo, prosimy niezwocznie zawiadomi nadawc wysyajc odpowied oraz trwale usun t wiadomo wczajc w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorised to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. BRE Bank SA, 00-950 Warszawa, ul. Senatorska 18, tel. +48 (22) 829 00 00, fax +48 (22) 829 00 33, www.brebank.pl, e-mail: i...@brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237, NIP: 526-021-50-88. Wedug stanu na dzie 01.01.2012 r. kapita zakadowy BRE Banku SA (w caoci wpacony) wynosi 168.410.984 zotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
Wow, Sam very nice Scott ford www.identityforge.com On Sep 14, 2012, at 10:54 AM, Sam Siegel s...@pscsi.net wrote: Walter - I have recently completed development of a COBOL and Assembler compatible API that allows the creation of full fidelity .xls and .xlsx spreadsheets. Below is a summary of supported functions. Full unicode support Ebcdic (all code pages) to unicode Packed, binary integers, ibm hex float Row oriented data insertion Cell oriented data insertion Jpeg, bmp image support Formulas Multiple tabs Lots more I also have a simple control card driven utility (built on the api) that allows a sequential file to be placed in a .xls or .xlsx format. I also have many sample COBOL and assembler programs for usage examples. There is no dependency on any third party products. No need for Java. The .xls and .xlsx file can be binary downloaded and opened directly by excel. Sam Sent from my Verizon Wireless BlackBerry -Original Message- From: Walter Marguccio walter_marguc...@yahoo.com Sender: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Date: Fri, 14 Sep 2012 06:44:23 To: IBM-MAIN@LISTSERV.UA.EDU Reply-To: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Phony IBM press release from 1980 for Mainframe-Attached Toilet
Here's a Friday topic if there ever was one. A friend who is cleaning out his place just sent me a scan of a purported IBM DPD press release (on what appears to be genuine DPD letterhead) from 12/11/1980 announcing the model 3082 Attached Toilet. (The 3082 is a multi-port, user-operated waste removal system with continuous roll forms ... featuring NCP (Network Commode Protocol).) It's a PDF of a medium quality scan, about 500K. If anyone wants a copy send me a private note: charlesm at mcn dot org. Charles -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: loading cryptographic coprocessor key part registers
Color me very confused. Do you not agree with the following statement from http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS189? Abstract:The ICSF, application key generation utility, KGUP, does not provide the capability to enter keys using dual custody of key parts. Without using a TKE Workstation there is no way to enter multiple values that will be used to create a key value. If a TKE Workstation is not desired nor required for any other reason, this working sample application provides the ability to enter application keys under multiple custody from the TSO terminal. I can't get the K function to even do anything for me. It either says CKDS RECORD EXISTS and when I press ENTER again says KEY NOT FOUND, or, in the case where the label in fact does not already exist it just says KEY NOT FOUND and then says it again when I press enter. From the documentation I'm looking at (Loading Operational Keys to the CKDS in the TKE Workstation Guide) it doesn't even show any examples (that I can see) of entering key components from this screen. So I am lost. In any case, we share operational keys with Visa and MasterCard, where they create the key parts and send them to us (triple custody). Would you agree that this is a case where this is required. Actually, I am referring to transport keys (key exchange keys), not operational keys, so perhaps I am going totally down the wrong path...? From: Rob Schramm rob.schr...@gmail.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Friday, September 14, 2012 10:29 AM Subject: Re: loading cryptographic coprocessor key part registers Frank, That is not true. Try option k. But the only reason you would need it would be if you need to store the operational key parts outside of the mainframe. Also, KGUP should support key part entry... although it is one of the oldest interfaces for ICSF. Auto generating keys is probably be the best if the keys are not required outside of the mainframe. Although you should be able to leverage a transport key or temporary session key if you need to exchange the key. The problems are that the management of the operational key parts are not really being managed outside of some interface like TKE or DKMS. TKE can actually enforce the presence of multiple people for key entry. DKMS has a whole host of ways of actually managing key materials. Rob Schramm Senior Systems Consultant Imperium Group On Fri, Sep 14, 2012 at 11:34 AM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: Key part entering is available in ICSF's ISPF interface only for master keys, not for operational keys. Bizarre but true. Operational keys can only be entered in full (not parts) or simply generated. From: Mark Jacobs mark.jac...@custserv.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, September 13, 2012 1:30 PM Subject: Re: loading cryptographic coprocessor key part registers ICSF has an ISPF interface that you'll use to enter the key parts. On 09/13/12 14:43, Frank Swarbrick wrote: We are migrating our PIN/card security process to use ICSF and a Crypto3 card. All of our vendor's other customers have used the TKE Workstation to load their operational keys (in multiple key part/component format). We were not planning on purchasing the TKE feature. But I cannot see any way outside of TKE to enter operational key components in to the cryptographic coprocessor's keypartregisters outside of using TKE. Help! Frank -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Mark Jacobs Time Customer Service Tampa, FL The quiet ones are the ones that change the universe... The loud ones only take the credit. Londo Mollari - Babylon 5 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Check out IBM Comedy 1970: Bob Newhart - A Call From Herman Hollerith
_IBM Comedy 1970: Bob Newhart - A Call From Herman Hollerith_ (http://businessphonesystemvoip.org/ibm-comedy-1970-bob-newhart-a-call-from-herman-holler ith.html) Well, for Friday's sake -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
C and LE -- when prepend userid on file names?
No doubt this is wonderfully documented somewhere but I am sitting here tearing my hair out. I have a C++ *batch* program that I could not get to open a conventional z/OS dataset by name to save my life until I finally figured out it was prepending my userid onto the specified name a la TSO. If I have encountered this behavior before and/or how to turn it on and off I have forgotten. It sure does not jump out at me from the manuals. IBM LE C running in batch: what determines whether it prepends your userid onto a conventional z/OS dataset name? Thanks! Charles -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: ShopzSeries SSL Connectivity Test
My bad -- DEBUG, not TRACE. Try DEBUG FLO DEBUG INT DEBUG ACC DEBUG SEC Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of John Chase Sent: Thursday, September 13, 2012 11:05 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: ShopzSeries SSL Connectivity Test On Thu, 13 Sep 2012 06:44:53 -0700, Charles Mills charl...@mcn.org wrote: Turn on some FTP tracing. You can do it in FTP.DATA. Take a look at the TRACE (?) statement in the CS configuration manuals and pick some plausible options. Charles Not much new with TRACE in the FTP.DATA: EZA1554I Connecting to: dispby-117.boulder.ibm.com 170.225.15.117 port: 21. 220-IBM's internal systems must only be used for conducting IBM's 220-business or for purposes authorized by IBM management. 220- 220-Use is subject to audit at any time by IBM management. 220- 220 dhebpcb01 secure FTP server ready. GU4945 ftpSetApplData: entered EZA1701I AUTH TLS 234 SSLv23/TLSv1 FC0994 authServer: secure_socket_init failed with rc = 420 (Socket closed by rem ote partner) EZA2897I Authentication negotiation failed EZA1534I *** Control connection with dispby-117.boulder.ibm.com dies. Still nothing substantive about rc = 420 that I can find anywhere. Time to try poke hole in firewall, I guess. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: loading cryptographic coprocessor key part registers
Frank, Sorry... I was just referring to ways to get operational keys in... Not under dual control or separation. If you need real control over MK and operational keys... Then TKE and DKMS is it. How many keys are you going to be managing? Rob Schramm On Sep 14, 2012 7:14 PM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: Color me very confused. Do you not agree with the following statement from http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS189? Abstract:The ICSF, application key generation utility, KGUP, does not provide the capability to enter keys using dual custody of key parts. Without using a TKE Workstation there is no way to enter multiple values that will be used to create a key value. If a TKE Workstation is not desired nor required for any other reason, this working sample application provides the ability to enter application keys under multiple custody from the TSO terminal. I can't get the K function to even do anything for me. It either says CKDS RECORD EXISTS and when I press ENTER again says KEY NOT FOUND, or, in the case where the label in fact does not already exist it just says KEY NOT FOUND and then says it again when I press enter. From the documentation I'm looking at (Loading Operational Keys to the CKDS in the TKE Workstation Guide) it doesn't even show any examples (that I can see) of entering key components from this screen. So I am lost. In any case, we share operational keys with Visa and MasterCard, where they create the key parts and send them to us (triple custody). Would you agree that this is a case where this is required. Actually, I am referring to transport keys (key exchange keys), not operational keys, so perhaps I am going totally down the wrong path...? From: Rob Schramm rob.schr...@gmail.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Friday, September 14, 2012 10:29 AM Subject: Re: loading cryptographic coprocessor key part registers Frank, That is not true. Try option k. But the only reason you would need it would be if you need to store the operational key parts outside of the mainframe. Also, KGUP should support key part entry... although it is one of the oldest interfaces for ICSF. Auto generating keys is probably be the best if the keys are not required outside of the mainframe. Although you should be able to leverage a transport key or temporary session key if you need to exchange the key. The problems are that the management of the operational key parts are not really being managed outside of some interface like TKE or DKMS. TKE can actually enforce the presence of multiple people for key entry. DKMS has a whole host of ways of actually managing key materials. Rob Schramm Senior Systems Consultant Imperium Group On Fri, Sep 14, 2012 at 11:34 AM, Frank Swarbrick frank.swarbr...@yahoo.com wrote: Key part entering is available in ICSF's ISPF interface only for master keys, not for operational keys. Bizarre but true. Operational keys can only be entered in full (not parts) or simply generated. From: Mark Jacobs mark.jac...@custserv.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, September 13, 2012 1:30 PM Subject: Re: loading cryptographic coprocessor key part registers ICSF has an ISPF interface that you'll use to enter the key parts. On 09/13/12 14:43, Frank Swarbrick wrote: We are migrating our PIN/card security process to use ICSF and a Crypto3 card. All of our vendor's other customers have used the TKE Workstation to load their operational keys (in multiple key part/component format). We were not planning on purchasing the TKE feature. But I cannot see any way outside of TKE to enter operational key components in to the cryptographic coprocessor's keypartregisters outside of using TKE. Help! Frank -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Mark Jacobs Time Customer Service Tampa, FL The quiet ones are the ones that change the universe... The loud ones only take the credit. Londo Mollari - Babylon 5 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
TSO it's prefix Scott ford www.identityforge.com On Sep 14, 2012, at 8:02 PM, Charles Mills charl...@mcn.org wrote: No doubt this is wonderfully documented somewhere but I am sitting here tearing my hair out. I have a C++ *batch* program that I could not get to open a conventional z/OS dataset by name to save my life until I finally figured out it was prepending my userid onto the specified name a la TSO. If I have encountered this behavior before and/or how to turn it on and off I have forgotten. It sure does not jump out at me from the manuals. IBM LE C running in batch: what determines whether it prepends your userid onto a conventional z/OS dataset name? Thanks! Charles -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
Say what? Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: Friday, September 14, 2012 5:29 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: C and LE -- when prepend userid on file names? TSO it's prefix Scott ford www.identityforge.com On Sep 14, 2012, at 8:02 PM, Charles Mills charl...@mcn.org wrote: No doubt this is wonderfully documented somewhere but I am sitting here tearing my hair out. I have a C++ *batch* program that I could not get to open a conventional z/OS dataset by name to save my life until I finally figured out it was prepending my userid onto the specified name a la TSO. If I have encountered this behavior before and/or how to turn it on and off I have forgotten. It sure does not jump out at me from the manuals. IBM LE C running in batch: what determines whether it prepends your userid onto a conventional z/OS dataset name? Thanks! Charles -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
PROFile NOPRE HELP PROFile In a message dated 9/14/2012 7:30:09 P.M. Central Daylight Time, scott_j_f...@yahoo.com writes: TSO it's prefix -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
On Fri, 14 Sep 2012 22:04:02 -0400, Ed Finnell wrote: PROFile NOPRE HELP PROFile In a message dated 9/14/2012 7:30:09 P.M. Central Daylight Time, scott_j_f...@yahoo.com writes: TSO it's prefix Does this apply even outside TSO? Does LE read the TSO profile data set to make the decision? I believe that in UNIX System services (USS) the cp(1) command et al. prefix any data set name not surrounded by apostrophes with the user ID (not the defined TSO prefix). Try surrounding your data set name with apostrophes. Not all the world is TSO. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
On Fri, Sep 14, 2012 at 5:02 PM, Charles Mills charl...@mcn.org wrote: No doubt this is wonderfully documented somewhere but I am sitting here tearing my hair out. I have a C++ *batch* program that I could not get to open a conventional z/OS dataset by name to save my life until I finally figured out it was prepending my userid onto the specified name a la TSO. If I have encountered this behavior before and/or how to turn it on and off I have forgotten. It sure does not jump out at me from the manuals. IBM LE C running in batch: what determines whether it prepends your userid onto a conventional z/OS dataset name? Look in the C/C++ programming guide in the chapter (5 i think) called opening files, sub chapter title 'How z/OS XL C/C++ determines what kind of file to open' Sam Thanks! Charles -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
As I said in the OP, ***BATCH***. //STEP1 EXEC PGM= Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ed Finnell Sent: Friday, September 14, 2012 7:04 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: C and LE -- when prepend userid on file names? PROFile NOPRE HELP PROFile In a message dated 9/14/2012 7:30:09 P.M. Central Daylight Time, scott_j_f...@yahoo.com writes: TSO it's prefix -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
Been through that section of the PG half a dozen times. I see no references at all to prepending userids. I come down in the flowchart to z/OS XL C/C++ opens an OS file. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sam Siegel Sent: Friday, September 14, 2012 9:49 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: C and LE -- when prepend userid on file names? On Fri, Sep 14, 2012 at 5:02 PM, Charles Mills charl...@mcn.org wrote: No doubt this is wonderfully documented somewhere but I am sitting here tearing my hair out. I have a C++ *batch* program that I could not get to open a conventional z/OS dataset by name to save my life until I finally figured out it was prepending my userid onto the specified name a la TSO. If I have encountered this behavior before and/or how to turn it on and off I have forgotten. It sure does not jump out at me from the manuals. IBM LE C running in batch: what determines whether it prepends your userid onto a conventional z/OS dataset name? Look in the C/C++ programming guide in the chapter (5 i think) called opening files, sub chapter title 'How z/OS XL C/C++ determines what kind of file to open' Sam -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C and LE -- when prepend userid on file names?
On Fri, Sep 14, 2012 at 10:01 PM, Charles Mills charl...@mcn.org wrote: Been through that section of the PG half a dozen times. I see no references at all to prepending userids. I come down in the flowchart to z/OS XL C/C++ opens an OS file. Agreed ... I miss read your post. Sorry about that. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sam Siegel Sent: Friday, September 14, 2012 9:49 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: C and LE -- when prepend userid on file names? On Fri, Sep 14, 2012 at 5:02 PM, Charles Mills charl...@mcn.org wrote: No doubt this is wonderfully documented somewhere but I am sitting here tearing my hair out. I have a C++ *batch* program that I could not get to open a conventional z/OS dataset by name to save my life until I finally figured out it was prepending my userid onto the specified name a la TSO. If I have encountered this behavior before and/or how to turn it on and off I have forgotten. It sure does not jump out at me from the manuals. IBM LE C running in batch: what determines whether it prepends your userid onto a conventional z/OS dataset name? Look in the C/C++ programming guide in the chapter (5 i think) called opening files, sub chapter title 'How z/OS XL C/C++ determines what kind of file to open' Sam -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Creating .xls on z/OS
If you are a DB2 pureXML (with XQuery Update) facility, I had a sample where, the unzipped .ods files are queried/modified as required by the ODF schema. The unzipped files are of course XML. http://opendocument.xml.org/resource/using-db2-purexml-and-odf-spreadsheets On 9/15/12, Scott Ford scott_j_f...@yahoo.com wrote: Wow, Sam very nice Scott ford www.identityforge.com On Sep 14, 2012, at 10:54 AM, Sam Siegel s...@pscsi.net wrote: Walter - I have recently completed development of a COBOL and Assembler compatible API that allows the creation of full fidelity .xls and .xlsx spreadsheets. Below is a summary of supported functions. Full unicode support Ebcdic (all code pages) to unicode Packed, binary integers, ibm hex float Row oriented data insertion Cell oriented data insertion Jpeg, bmp image support Formulas Multiple tabs Lots more I also have a simple control card driven utility (built on the api) that allows a sequential file to be placed in a .xls or .xlsx format. I also have many sample COBOL and assembler programs for usage examples. There is no dependency on any third party products. No need for Java. The .xls and .xlsx file can be binary downloaded and opened directly by excel. Sam Sent from my Verizon Wireless BlackBerry -Original Message- From: Walter Marguccio walter_marguc...@yahoo.com Sender: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Date: Fri, 14 Sep 2012 06:44:23 To: IBM-MAIN@LISTSERV.UA.EDU Reply-To: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU 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 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. We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, 1.2.0. Any thoughts, experiences links, books ? Walter Marguccio z/OS Systems Programmer BELENUS LOB Informatic GmbH Munich - Germany -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN