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
 
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 Where to get sample for processing RM... vice_versa PL/I & Assembler 2 Tue Jan 16, 2018 2:03 pm
No new posts VSAM dataset not found abdulrafi JCL & VSAM 5 Fri Jan 12, 2018 11:19 am
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

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