Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Sample COBOL program with Select query on CLOB data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ssundaram

New User


Joined: 22 Jan 2007
Posts: 8
Location: USA

PostPosted: Thu Aug 01, 2013 12:15 am    Post subject: Sample COBOL program with Select query on CLOB data
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 01, 2013 12:49 am    Post subject:
Reply with quote

Hello,

See if this will help:
http://ibmmainframes.com/viewtopic.php?t=36854
Back to top
View user's profile Send private message
ssundaram

New User


Joined: 22 Jan 2007
Posts: 8
Location: USA

PostPosted: Thu Aug 01, 2013 2:29 am    Post subject:
Reply with quote

Quote:

Hello,

See if this will help:
http://ibmmainframes.com/viewtopic.php?t=36854
_________________
Hope this helps,

d.sch.

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
View user's profile Send private message
ssundaram

New User


Joined: 22 Jan 2007
Posts: 8
Location: USA

PostPosted: Wed Aug 07, 2013 9:59 pm    Post subject:
Reply with quote

I am still looking for some examples. It would be helpful if I get some assistance on this!

Thanks!
Satya S
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 07, 2013 10:16 pm    Post subject:
Reply with 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.
Back to top
View user's profile Send private message
ssundaram

New User


Joined: 22 Jan 2007
Posts: 8
Location: USA

PostPosted: Wed Aug 07, 2013 11:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Aug 07, 2013 11:18 pm    Post subject:
Reply with quote

ssundaram wrote:
I tried searching in the IBM Manuals but was unable to find the correct example.

Like this?
Back to top
View user's profile Send private message
ssundaram

New User


Joined: 22 Jan 2007
Posts: 8
Location: USA

PostPosted: Wed Aug 07, 2013 11:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Wed Aug 07, 2013 11:34 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us