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: 1761
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: 8086
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 Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts NDM syntax checking without actually ... GAPX1 All Other Mainframe Topics 0 Wed Jun 07, 2017 2:36 am
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am


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