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
