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 wrote:
On Fri, Sep 14, 2012 at 10:01 PM, Charles Mills 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.
>
>
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 Sie
My other programs do not behave this way, apostrophes or no.
Charles
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Paul Gilmartin
Sent: Friday, September 14, 2012 8:18 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: C and LE -- when pr
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 Fri, Sep 14, 2012 at 5:02 PM, Charles Mills 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
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 decisi
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 l
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
TSO it's prefix
Scott ford
www.identityforge.com
On Sep 14, 2012, at 8:02 PM, Charles Mills 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 nam
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"
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: Shop
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
_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 / signof
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 us
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
remo
Wow, Sam very nice
Scott ford
www.identityforge.com
On Sep 14, 2012, at 10:54 AM, Sam Siegel 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 s
W dniu 2012-09-14 23:08, Martin Packer pisze:
.CSV won't contain formulae. Don't know if that's what bothers the OP -
but it bothers ME as I'd like to generate them in REXX.
There are many things which cannot be kept in .CSV: graphs, complex
formula, column formatting, page setup, multiple spr
Martin,
I have no trouble with formulae in .csv, I do it all the time from Rexx on
z/OS. I will generate two calculation cells like this, for instance:
"=IF(D2>0,(F2-D2),"" "")","=IF(D2>0,(H2/D2),"" "")",
I found that I have to surround the formula with double quotes (because of the
embedded
Have you tried putting in =A1+B2 between commas for a cell value?
1,2,=SUM(A1:B1)
11,22,=SUM(A2:B2)
=SUM(A1:A2),=SUM(B1:B2),=A1+B2
On Fri, Sep 14, 2012 at 4:08 PM, Martin Packer wrote:
> .CSV won't contain formulae. Don't know if that's what bothers the OP -
> but it bothers ME as I'd like to ge
.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
(For record purposes)
I solved the problem using Dave's job:
//SMPCNTLDD *
SET BDY(GLOBAL).
REJECT HOLDDATA NOFMID
PRODUCT
DELETEFMID(HKAH33T HWRE330 JWRE33C H09F210).
IMHO it's worth to note, that output from REJECT ...CHECK is misleading,
it lies about Products and Features del
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
BUT, HEED THE ADVICE FROM PAT HUGHES.
The intent behind the change is all important in determining what you
really need to change. If the intent is to alter the physical retention
of the tape, just changing EXPDT may not do it. The retention
scheduling rule that is in place for the volume ma
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 , Pat Hughes1
wrote:
> All, the various solutions given are the reason I suggested the
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 re
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."
wrote:
> I've used POI to create simple, straightforward spreadsheets and it works
> fine.
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. W
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, 20
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
To: IBM-MAIN@LISTSERV.U
I have successfully used the java based jexcelapi.
http://jexcelapi.sourceforge.net/
Its open source.
Denis.
-Original Message-
From: Walter Marguccio
To: IBM-MAIN
Sent: Fri, Sep 14, 2012 3:44 pm
Subject: Creating .xls on z/OS
Hello all,
I've been asked if there is the poss
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
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
O
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. Thi
Lizette,
I loved SAS, did a lot of network performance with SNA with it.
Scott ford
www.identityforge.com
On Sep 14, 2012, at 10:37 AM, Lizette Koehler wrote:
> John,
>
> I have used ODS in SAS and you can generate the XLS into a PDSE file that is
> then send (via email or other FTP to a sit
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
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 Req
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
>To: IBM-MAIN@LISTSERV.UA.EDU
>Sent
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.
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 re
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 wrote:
> Frank,
>
> I would strongly recommend a checklist style with places for initials
> for eac
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 o
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
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 *
jo
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:/
I'm not sure, but looking at
http://support.sas.com/rnd/base/ods/templateFAQ/Excel1.pdf
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 fil
You don't have SAS? I believe it can.
Kees.
"Walter Marguccio" wrote in message
news:<1347630263.5695.yahoomail...@web114704.mail.gq1.yahoo.com>...
> Hello all,
>
> I've been asked if there is the possibility to create Excel tables (.xls)
> files on z/OS,
> using a batch job. I've searched
That might or might not work. A lot of the CPAN modules require support
subroutines written in C. So the OP would need a C compiler licensed on z/OS.
And, even then, I don't know if the CPAN C source would compiler on z/OS. Much
of it is based on other libraries (many from GNU) which might not e
Since you have Perl, I'd look into one of the dozens of brilliant CPAN modules,
e.g. Spreadsheet::WriteExcel
Regards,
Boris
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.ed
Please ignore my response about xsl - it looked like xls for a minute.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Walter Marguccio
Sent: Friday, September 14, 2012 9:44 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Creating .xls on z/
> -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" sta
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
Hel
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
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 in
Supposedly, but I haven't actually tried. Look at:
http://poi.apache.org/
The Apache POI Project's mission is to create and maintain Java APIs for
manipulating various file formats based upon the Office Open XML standards
(OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In short, y
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.
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 / sign
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 w
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 PRODU
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
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
als
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
-
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/mydeve
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
64 matches
Mail list logo