Key fields on RECFIELD

Works in Oracle DB only.

 SELECT RECNAME ,FIELDNAME ,(TRUNC((USEEDIT/1),0) - TRUNC((USEEDIT/2),0) * 2) KEY ,(TRUNC((USEEDIT/2),0) - TRUNC((USEEDIT/4),0) * 2) DUPORDERKEY ,(TRUNC((USEEDIT/256),0) - TRUNC((USEEDIT/512),0) * 2) REQUIRED FROM PSRECFIELD WHERE RECNAME = '&RECNAME'