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 <[email protected]>
We are looking at storing PDF files as DB2 BLOB data and I have some info on
the COBOL programming aspect from a DB2 redbook. However we first have to
get the PDF file stored in an MVS dataset. Obviously we can FTP the file
but what would the attributes of the MVS dataset look like. Has anyone done
this already.
Jim McAlpine
Why do you have to get the PDF file in an MVS dataset?
I've uploaded pdf's and image files into an HFS directory as
binary. Then you can run a load job like this:
//SCOMSTO JOB ...
//STEP1 EXEC DSNUPROC,UID=SCOMSTO.LOADLOB
//SYSUT1 DD UNIT=SYSALLDA,SPACE=(TRK,(20,20))
//SORTOUT DD UNIT=SYSALLDA,SPACE=(TRK,(20,20))
//SYSIN DD *
LOAD DATA RESUME NO REPLACE INTO TABLE DOCS
(DOC POSITION (01) CHAR(30) BLOBF )
//SYSREC DD *
/u/scomsto/pdfs/part00105.pdf
/u/scomsto/pdfs/part00240.pdf
.
.
.
This actually seems to be a little more natural to me.
Kind regards,
-Steve Comstock
The Trainer's Friend, Inc.
303-393-8716
http://www.trainersfriend.com
z/OS Application development made easier
* Our classes include
+ How things work
+ Programming examples with realistic applications
+ Starter / skeleton code
+ Complete working programs
+ Useful utilities and subroutines
+ Tips and techniques
==> Check out the Trainer's Friend Store to purchase z/OS <==
==> application developer toolkits. Sample code in four <==
==> programming languages, JCL to Assemble or compile, <==
==> bind and test. <==
==> http://www.trainersfriend.com/TTFStore/index.html <==
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
