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: 1772
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: 8132
Location: East Dubuque, Illinois, USA

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 Select numeric portion from CHAR data... balaji81_k DB2 1 Sat Aug 19, 2017 1:51 am
No new posts ALPHABETIC check in COBOL vidyaa COBOL Programming 8 Thu Aug 17, 2017 7:13 pm
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts Paasing symbolic parameter to instrea... Robert Sample JCL & VSAM 2 Thu Jul 27, 2017 1:22 pm
No new posts Passing data from REXX to C programme... chong.zhou CLIST & REXX 3 Wed Jul 26, 2017 9:11 pm


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