|
View previous topic :: View next topic
|
| Author |
Message |
amalli
New User
Joined: 06 Sep 2005
Posts: 17
|
|
|
|
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 |
|
 |
amalli
New User
Joined: 06 Sep 2005
Posts: 17
|
|
|
|
the above qustions are one interview qustions....any one knows?
malli |
|
| Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 463
|
|
|
|
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 |
|
|
amalli
New User
Joined: 06 Sep 2005
Posts: 17
|
|
|
|
thnk u rupesh...
But how to search the topic in forum?
byeee
malli |
|
| Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 463
|
|
| Back to top |
|
|
|
|
