IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to manipulate record by using key?


IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Thirumurgann

New User


Joined: 13 Feb 2008
Posts: 36
Location: India

PostPosted: Mon Jun 02, 2008 7:56 pm
Reply with quote

How to manipulate records by using a key in COBOL.

Thanks,
Thiru
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA

PostPosted: Mon Jun 02, 2008 8:08 pm
Reply with quote

icon_question.gif icon_question.gif icon_question.gif icon_question.gif
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Mon Jun 02, 2008 10:17 pm
Reply with quote

Hello Thiru,

Please rephrase your question and show some data examples. Show what you "have" (input) and what you want to do with what you have (result/output).

While your question is clear to you, it is not clear to everyone who has read it.

Once you clarify what you want/need, we can offer suggestions.

It may help if you define your meaning of manipulate - typically records are read or written. If these are vsam files, mention this also.
Back to top
View user's profile Send private message
Sinkaravelan S

New User


Joined: 21 Apr 2008
Posts: 27
Location: coimbatore-TN india

PostPosted: Tue Jun 03, 2008 3:29 pm
Reply with quote

I think, You are asking about extract records from db thru key..right?..

if yes then search your db which one is your primary key field..

if my answer is wrong then pls give some more detail abt your queries..
Back to top
View user's profile Send private message
vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex

PostPosted: Tue Jun 03, 2008 3:55 pm
Reply with quote

Assuming the question, using a COBOL program you can access the file like VSAM KSDS file, which comprises of key field using such key as a search field manipulate (update,delete,read,append....etc) accordingly.
Back to top
View user's profile Send private message
Thirumurgann

New User


Joined: 13 Feb 2008
Posts: 36
Location: India

PostPosted: Tue Jun 03, 2008 4:30 pm
Reply with quote

Hi friends, My querry is how the records are mapped in to key fields.

For Eg, In below code Key is EXT-KEY. How it is pointing to the particular record.Much confused about Acessing files by ket field...

SELECT F001EXT ASSIGN TO IF001EXT
ORGANIZATION IS INDEXED
ACCESS IS DYNAMIC
RECORD KEY IS EXT-KEY
FILE STATUS IS EXT-STAT.

Thanks for sugessions
Regards,
Thiru
Back to top
View user's profile Send private message
vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex

PostPosted: Tue Jun 03, 2008 4:44 pm
Reply with quote

HELLO,

Quote:

SELECT F001EXT ASSIGN TO IF001EXT
ORGANIZATION IS INDEXED
ACCESS IS DYNAMIC
RECORD KEY IS EXT-KEY
FILE STATUS IS EXT-STAT.


The above statements are declaration EXT-KEY is not pointing to any record that you have to populate in the procedure division of the cobol program and read randomly or dynamically.

For more infosearch in google or in manuals above this page in this forum if you are new to COBOL
Back to top
View user's profile Send private message
Thirumurgann

New User


Joined: 13 Feb 2008
Posts: 36
Location: India

PostPosted: Tue Jun 03, 2008 7:55 pm
Reply with quote

Thanks Visanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> COBOL Programming

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
Search our Forums:

Back to Top