Needed help in understanding how to do an LOB insert operation on the columns created using the script below.
--CREATE TABLE TO HOLD LOB DATA
CREATE TABLE SVK.EMP_PHOTO_RESUME
(EMPNO CHAR(6) NOT NULL,
EMP_ROWID ROWID NOT NULL GENERATED ALWAYS,
PRIMARY KEY (EMPNO))
--DEFINE A LOB TABLE SPACE AND AN AUX TABLE TO HOLD THE EMP RESUMES
CREATE LOB TABLESPACE RESUMETS
CREATE AUXILIARY TABLE EMP_RESUME_TAB
CREATE UNIQUE INDEX XRESUME
Being naive to the LOB section in DB2 I tried reading docs and ended up creating the table and columns as you see above. I have two queries.
1. How can I move resume in PDF or DOC format to the Mainframe Terminal to be pushed to the columns (Tried FTP but ended up with errors)
--While transferring a pic the error encountered was : Copying files to remote side failed.
Invalid data set name "1.JPG". Use MVS Dsname conventions.
--While transferring DOC file the error encountered was
: Copying files to remote side failed.
Invalid data set name "form.pdf". Use MVS Dsname conventions.
2. If transfer is not required how do I do it using SQL queries. I do not want to write a cobol application or any application programing to do the same.
The versions of product I use are:
zOs - 2.2
DB2 V 11.0
Open Text Host Explorer 14 x64 for accessing the Mainframe terminal
Any help here will be appreciated.