Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
some doubts about binding

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

New User


Joined: 15 Feb 2004
Posts: 8

PostPosted: Sun Feb 22, 2004 11:48 am    Post subject: some doubts about binding
Reply with quote

hi,
thanks for your timely help. can you give me answer to my folowing questions too


1.what are the differences between vasm and db2. why we r going for db2.

2.function of REBIND option

3.how to access even records(ie record 22, 24, ..... upto 40 from 20) in indexed organization and dynamic access mode using alternate indexes.


plse do clear these doubts.
Back to top
View user's profile Send private message

franclin

New User


Joined: 23 May 2003
Posts: 11
Location: Chennai, India

PostPosted: Sun Feb 22, 2004 8:28 pm    Post subject: Re
Reply with quote

Dear,

Quote:
1.what are the differences between vasm and db2. why we r going for db2.


VSAM means virtual storage access methods of storing your data permanantly in DASD.

DB2 is a relational database, which also stores data, but give you a high access control over it.

there is no relation b/w data in a VSAM file, but DB2 provides integirity and entity relationship among data.



Quote:
2.function of REBIND option


REBIND binds your DBRM again without disturbing your base program. You can prefer REBINDING whenever,

a) An INDEX is added to your table
b) RUNSTATS utility has been run

Always prefer rebinding, instead of bind, whenver any authorization changes have been made to the table, but not any SQL statements in your program.

Quote:
3.how to access even records(ie record 22, 24, ..... upto 40 from 20) in indexed organization and dynamic access mode using alternate indexes.


Begin with your START commend with indexed from 20NTH RECORD. Use READ NEXT commend twise. Display the second READ NEXT valued. It will give you all even records. Perform this loop 10 times.
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 -419 SQL error when binding senthamizh DB2 2 Sun Jun 12, 2016 8:20 pm
No new posts Doubts in MQ data Converstions Thamilselvi Java & MQSeries 3 Mon Jul 02, 2012 3:48 pm
No new posts Doubts related to insertion of table ... Vidya Kajale COBOL Programming 1 Tue Apr 24, 2012 11:54 am
No new posts difference between Static and Dynamic... dbzTHEdinosauer Mainframe Interview Questions 7 Tue Jun 28, 2011 7:46 pm
No new posts Doubts regarding Merging Rahul_kumar JCL & VSAM 5 Wed Apr 27, 2011 4:41 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us