Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-18 Thread Jim McAlpine
On Fri, Nov 14, 2008 at 4:45 AM, Kirk Wolf [EMAIL PROTECTED] wrote: Jim, You are right, my response was a little rude. I apologize. A PDF is simply a stream of binary data - records are of no consequence. You can store a PDF in any kind of dataset you want, so long as you can read it

Re: storing a PDF file in DB2 for z/OS

2008-11-13 Thread Jim McAlpine
On Wed, Nov 12, 2008 at 8:54 PM, Wayne Driscoll [EMAIL PROTECTED]wrote: Jim, For DB2 V7 (now out of service) and DB2 V8, you need the PTF for APAR PK35437. Wayne Driscoll Product Developer NOTE: All opinions are strictly my own. Cheers Wayne. Jim McAlpine

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-13 Thread Roland Schiradin
See the last two steps in member SHOWJCL or X2PJCL. Roland On Tue, Nov 11, 2008 at 7:24 PM, Roland Schiradin [EMAIL PROTECTED]wrote: Look into the SHOWzOS distribution www.cbttape.org. It contains a JCL to generate a PDF and transfer this MVS dataset to your PC. Roland I'm not having

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-13 Thread Kirk Wolf
Jim, You are right, my response was a little rude. I apologize. A PDF is simply a stream of binary data - records are of no consequence. You can store a PDF in any kind of dataset you want, so long as you can read it from your COBOL program and load it into the BLOB. RECFM=U, BLKSIZE=27998

Re: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Jim McAlpine
Thanks to all for the replies. Jim McAlpine On Tue, Nov 11, 2008 at 5:03 PM, Jim McAlpine [EMAIL PROTECTED]wrote: Sorry, there was a typo in the title. -- Forwarded message -- From: Jim McAlpine [EMAIL PROTECTED] Date: Tue, Nov 11, 2008 at 5:02 PM Subject: string a PDF

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Jim McAlpine
On Tue, Nov 11, 2008 at 11:07 PM, Kirk Wolf [EMAIL PROTECTED] wrote: This question has great potential for a really long IBM-MAIN thread :-) Is it a question about: - how to store a PDF in a dataset? - how to load PDFs into DB2? - how to transfer a PDF to a mainframe dataset? - how to

Re: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Jim McAlpine
On Tue, Nov 11, 2008 at 5:39 PM, Wayne Driscoll [EMAIL PROTECTED]wrote: Well, DB2 ships with a PDF file in the DSN!!0.SDSNIVPD dataset, member DSNDR, and it is a VB dataset, lrecl=8188. Wayne Driscoll Product Developer NOTE: All opinions are strictly my own. I can't find that member in

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Jim McAlpine
On Tue, Nov 11, 2008 at 7:24 PM, Roland Schiradin [EMAIL PROTECTED]wrote: Look into the SHOWzOS distribution www.cbttape.org. It contains a JCL to generate a PDF and transfer this MVS dataset to your PC. Roland I'm not having much luck finding stuff. I've downloaded file 492 but I can't

Re: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Gary DiPillo
Jim, The member is present in DSN910.SDSNIVPD. The data set has attributes: DSORG=PO RECFM=VB LRECL=8188 BKLSIZE=27998. The transfer to a PC requires that the NORDW FTP setting be set or defaulted. The PDF is the DB2 Version 9.1 for z/OS OS Diagnosis Guide and Reference. Gary DiPillo On

Re: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Wayne Driscoll
Jim, For DB2 V7 (now out of service) and DB2 V8, you need the PTF for APAR PK35437. Wayne Driscoll Product Developer NOTE: All opinions are strictly my own. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Jim McAlpine Sent: Wednesday,

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Grant Williams
I upload (as binary) to recfm=U lrecl=0 blksize=19069 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-12 Thread Paul Gilmartin
On Wed, 12 Nov 2008 17:28:26 -0600, Grant Williams wrote: I upload (as binary) to recfm=U lrecl=0 blksize=19069 Ah, yes. I remember 19069. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email

Re: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Wayne Driscoll
Well, DB2 ships with a PDF file in the DSN!!0.SDSNIVPD dataset, member DSNDR, and it is a VB dataset, lrecl=8188. Wayne Driscoll Product Developer NOTE: All opinions are strictly my own. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Jim

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Paul Gilmartin
On Tue, 11 Nov 2008 09:34:52 -0800, Jack wrote: If I create a PDF file with SAS and don't specify attributes, it assigns Organization . . . : PS Record format . . . : VB Record length . . . : 259 Block size . . . . : 27998 I have also used LRECL=8096,BLKSIZE=0. I suppose it depends largely

Re: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Paul Gilmartin
On Tue, 11 Nov 2008 11:39:11 -0600, Wayne Driscoll wrote: Well, DB2 ships with a PDF file in the DSN!!0.SDSNIVPD dataset, member DSNDR, and it is a VB dataset, lrecl=8188. 8188? 8096? What motivates these numbers? 3390 track geometry. What's SDSNIVPD's BLKSIZE? -- gil

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Steve Comstock
Jim McAlpine wrote: Sorry, there was a typo in the title. -- Forwarded message -- From: Jim McAlpine [EMAIL PROTECTED] Date: Tue, Nov 11, 2008 at 5:02 PM Subject: string a PDF file in DB2 for z/OS To: IBM Mainframe Discussion List ibm-main@bama.ua.edu We are looking at storing

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Roland Schiradin
Look into the SHOWzOS distribution www.cbttape.org. It contains a JCL to generate a PDF and transfer this MVS dataset to your PC. Roland Sorry, there was a typo in the title. -- Forwarded message -- From: Jim McAlpine [EMAIL PROTECTED] Date: Tue, Nov 11, 2008 at 5:02 PM

Fwd: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Jim McAlpine
Sorry, there was a typo in the title. -- Forwarded message -- From: Jim McAlpine [EMAIL PROTECTED] Date: Tue, Nov 11, 2008 at 5:02 PM Subject: string a PDF file in DB2 for z/OS To: IBM Mainframe Discussion List ibm-main@bama.ua.edu We are looking at storing PDF files as DB2 BLOB

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Jack . Hamilton
If I create a PDF file with SAS and don't specify attributes, it assigns Organization . . . : PS Record format . . . : VB Record length . . . : 259 Block size . . . . : 27998 I have also used LRECL=8096,BLKSIZE=0. -- Jack Hamilton Management Information Analysis - Analytic Information

Re: Fwd: storing a PDF file in DB2 for z/OS

2008-11-11 Thread Kirk Wolf
This question has great potential for a really long IBM-MAIN thread :-) Is it a question about: - how to store a PDF in a dataset? - how to load PDFs into DB2? - how to transfer a PDF to a mainframe dataset? - how to process DB2 LOBs in COBOL ? Pick your favorite aspect, or anything slightly