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
 

 

Db2 and Vsam

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

New User


Joined: 06 Sep 2005
Posts: 17

PostPosted: Thu Sep 15, 2005 9:59 am    Post subject: Db2 and Vsam
Reply with quote

hi

1. Can you display the index?
2. Commenly facing errors in cobol-db2 program?
3.What is diff b/w check pending and copy pending>
4. how to repair the table?
5. how to increase table space in db2?
6. How to read last record in vasam file?
7 i have 1000 records in vasam, i want read records 500 to 600?
8. explain REUSE
9.How to read vsam file?
10 what is packed decimal?


thanks
malli
Back to top
View user's profile Send private message

amalli

New User


Joined: 06 Sep 2005
Posts: 17

PostPosted: Thu Sep 15, 2005 5:25 pm    Post subject: interview questions
Reply with quote

the above qustions are one interview qustions....any one knows?



malli
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Fri Sep 16, 2005 11:11 am    Post subject: Re: Db2 and Vsam
Reply with quote

Hi,

Quote:
2. Commenly facing errors in cobol-db2 program?


If you search in forum you will get the answer of this question.

Quote:
7 i have 1000 records in vasam, i want read records 500 to 600?


If I am recalling you correctly you want to read 100 records from 500 to 600 in a flat fle. then You an use following code.

//STEP01 EXEC PGM=SORT
Code:
//SORTIN  DD DSN=VSAM Name,DISP=SHR       
//SORTOUT DD DSN=Output file,                   
//            DISP=(NEW,CATLG,DELETE),                     
//            UNIT=TEMP,                                   
//            DCB=...,                   
//            SPACE=...                   
//SYSIN   DD *                                             
 SORT FIELDS=(1,56,CH,A),                                   
 SKIPREC=500,STOPAFT=100                                   
/*                                                         
//SYSOUT       DD SYSOUT=*                                 
//SYSUDUMP   DD SYSOUT=*
//


Quote:
9.How to read vsam file?


If you want to read VSAM in CObol then you can read same as Flat file Using READ.


Quote:
10 what is packed decimal?


The number stored in COMP-3 field is called as packed decimal number.
Packed decimal is nothing but the hexadecimal equivalent of the data that you have entered. It will not be visible when the file having packed decimal data is opened in edit mode unless you use a HEX ON. It is used to provide optimum storage. A variable with PIC X(5) COMP-3 will occupy only 3 bytes in the storage memory.


Regards
Rupesh
Back to top
View user's profile Send private message
amalli

New User


Joined: 06 Sep 2005
Posts: 17

PostPosted: Fri Sep 16, 2005 11:24 am    Post subject: db2 and vsam
Reply with quote

thnk u rupesh...


But how to search the topic in forum?


byeee
malli
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Fri Sep 16, 2005 11:27 am    Post subject: Re: Db2 and Vsam
Reply with quote

Hi,

Use following link to search topics.

http://www.ibmmainframes.com/search.php

Regards
Rupesh
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 Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm


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