DBA > Job Interview Questions > Information Management System (IMS) Interview Questions

What for procopt is used? List some of them

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What for procopt is used? List some of them

Procopt parameter specifies PROCESSING OPTIONS that define the type of processing that can be performed on a segment. ex. K, G, L, LS. A, AS, I, IS.
Procopt = k --- means, the segment is key sensitive
Procopt = g -- means, the segement is data sensitive (like read only)
L - Load mode, means we can load database from scratch
A - Get, Insert, Delete, Replace - means it allows the program to issue all those calls
I - insert mode. That means onlu insert calls with insert mode can be issued

(Continued on next question...)

Other Job Interview Questions