Field, Alan C. wrote:
Do you really mean Kingdome?
Wasn't that the stadium in Seattle that got imploded a couple of years
ago.
"Keys to the Kingdom"
Alan :)
No, I really meant Kingdome. Most of the stuff we
teach can be a little boring so we try to slip in
surprises in the data to see if anyone catches it.
It's not a big laugh, but every bit helps. :-)
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Steve Comstock
Sent: Tuesday, October 14, 2008 15:42 PM
To: [email protected]
Subject: Re: IBM DB2 Version 9 for z/OS
Roland Schiradin wrote:
Haven't tried but the DB2 LOAD support paths for LOB columns.
Roland
Dear all,
Is it possible to use for the DB2 LOAD UTILITY (DB2 Version 9 for
z/OS) a
file from Unix Filesystem? I mean can a PATH parameter be given to
the DD
statement refering a file in a zFS instead of having a normal MVS
dataset?
I have; works fine for BLOBs anyway. I'm giving a talk
on it in Columbia, MD on Thursday, so I thought it'd be
good to test it out. [Actually, I put the path on the
data statements.]
Here's a cut from the job I ran:
//STEP1 EXEC DSNUPROC,UID=SCOMSTO.LOADLOB
//SYSUT1 DD UNIT=&UNIT,SPACE=(TRK,(20,20))
//SORTOUT DD UNIT=&UNIT,SPACE=(TRK,(20,20))
//SYSIN DD *
LOAD DATA RESUME NO REPLACE CONTINUEIF(72:72)='X' INTO TABLE ITEMS
(PARTNO POSITION (01) CHAR(9),
DESCRIPTION POSITION (10) CHAR(30),
QOH POSITION (42) INTEGER EXTERNAL(2),
PICTURE POSITION (80) CHAR(30) BLOBF )
//SYSREC DD *
Part00105Keys to the Kingdome 001075003483 X
/u/scomsto/blobs/part00105.bmp
Part00240Overtime Hours 001750000288 X
/u/scomsto/blobs/part00240.bmp
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
