This should be achievable in COBOL.
I've done CLOBs. Handled exactly like any other column type, the only
difference being around how to declare the host variables in the cobol
source:
EXEC SQL
BEGIN DECLARE SECTION
END-EXEC.
01 WS-CLOB USAGE IS SQL TYPE IS CLOB (1M).
EXEC SQL
END DECLARE SECTION
END-EXEC.
- I'd guess a BLOB would use the same structure(?)
I recall DV2 v7.1 had extra restrictions around tables including large
objects, but 8.1 makes most of the differences/difficulties go away.
HTH,
Mike.
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On
Behalf Of Jim McAlpine
Sent: 11 April 2008 16:01
To: [email protected]
Subject: storing pdf documents an DB2
We have a need to store pdf documents in DB2 tables. I know that DB2
supports blob columns which we can presumably use to store the pdfs.
The question I have is can we use COBOL to manipulate/insert the data
into the
DB2 blob columns. I had a quick look at the COBOL FMs but there seems
to be little mention of blobs. Has anyone successfuly done this.
Jim McAlpine
----------------------------------------------------------------------
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
This e-mail has come from Experian, the only business to have been twice named
the UK's 'Business of the Year’
Register for our free online seminar on 24th April where we advise marketers on
how to achieve marketing relevance with their customer communications. Visit
www.experianim.com/marketingrelevancewebinar (simply paste the URL into your
browser)
===================================================================================
Information in this e-mail and any attachments is confidential, and may not be
copied or used by anyone other than the addressee, nor disclosed to any third
party without our permission. There is no intention to create any legally
binding contract or other binding commitment through the use of this electronic
communication unless it is issued in accordance with the Experian Limited
standard terms and conditions of purchase or other express written agreement
between Experian Limited and the recipient.
Although Experian has taken reasonable steps to ensure that this communication
and any attachments are free from computer virus, you are advised to take your
own steps to ensure that they are actually virus free.
Companies Act information:
Registered name: Experian Limited
Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH
Place of registration: England and Wales
Registered number: 653331
----------------------------------------------------------------------
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
