View previous topic :: View next topic
|
Author |
Message |
ssundaram
New User
Joined: 22 Jan 2007 Posts: 8 Location: USA
|
|
|
|
Hi,
I have a DB2 table with a CLOB column. the CLOB column has a CLOB locator. It will be helpful if some one can help me with a sample COBOL program with a CLOB locator. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
Back to top |
|
|
ssundaram
New User
Joined: 22 Jan 2007 Posts: 8 Location: USA
|
|
|
|
Hello,
I read thru the information in the provided link. It was helpful. It talks about how to insert data in to a BLOB datatype. The example provided is not using a locator to access data that is stored in the table. Will be helpful if I an get an example with locator for select or insert. |
|
Back to top |
|
|
ssundaram
New User
Joined: 22 Jan 2007 Posts: 8 Location: USA
|
|
|
|
I am still looking for some examples. It would be helpful if I get some assistance on this!
Thanks!
Satya S |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
We do not use "locators" - at least as i understand your question.
Is there not a sample in the IBM material? They usually have examples with the documentation of the feature. |
|
Back to top |
|
|
ssundaram
New User
Joined: 22 Jan 2007 Posts: 8 Location: USA
|
|
|
|
Quote: |
Hello,
We do not use "locators" - at least as i understand your question.
Is there not a sample in the IBM material? They usually have examples with the documentation of the feature.
_________________
Hope this helps,
|
In COBOL CLOB data is accessed three different ways.
1) Host Variable ( example provided in this forum).
2) Using LOB Locator.
3) Using File reference.
I tried searching in the IBM Manuals but was unable to find the correct example. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
ssundaram wrote: |
I tried searching in the IBM Manuals but was unable to find the correct example. |
Like this? |
|
Back to top |
|
|
ssundaram
New User
Joined: 22 Jan 2007 Posts: 8 Location: USA
|
|
|
|
Akatsukami,
The example provided helps! Thanks for sharing. The sample code provided is using C language. Would appreciate if there is an example in COBOL. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
Did you look at the end of the posted link where it has
Quote: |
COBOL
lobeval.sqb -- Demonstrates how to use a Large Object (LOB) (IBM COBOL)
lobloc.sqb -- Demonstrates the use of LOB locators (IBM COBOL)
This topic can be found in: Application Development Guide: Programming Server Applications.
|
|
|
Back to top |
|
|
|