I have some queries regarding to COBOL and DB2....i tried to get answer from groups but i didn't get clarity.
Occurs class: Can we use 77 level number in occurs class.
eg;
01 Mdata
02 month occurs 12 times.
77 week x(4) occurs 4times. ....Is it correct or not in 2 dimensional array declaration.
Renames class: when we are using renames class, can we use diff level numbers in elementary data items.
eg: 01 salary
02 basic pic 9(5).
03 hra pic 9(5).
04 pf pic 9(4).
04 sa pic 9(2).
66 Nsal renames hra thru sa.
Is it correct declaration or not.
DB2: Is it possible to retrieve multiple rows from a table with out using cluster, if yes how it is possible.
Diff between index, unique index and cluster index.