In IFS 75 version Reference_sys package during refresh active list has validation that CASCADE option is only valid for P - primary key.
Since IFS 8 version there is no that validation. I want to ask whether CASCADE option for A - attribute column or K - key are proper AQS behaviour? It make sens to use it?
Check following query which shows many examples from standard code
SELECT DVC.LU_NAME,
DVC.VIEW_NAME,
DVC.COLUMN_NAME,
DVC.COLUMN_REFERENCE,
DVC.TYPE_FLAG
FROM DICTIONARY_SYS_VIEW_COLUMN DVC
WHERE DVC.COLUMN_REFERENCE IS NOT NULL
AND DVC.COLUMN_NAME NOT IN
('OBJID', 'OBJVERSION', 'OBJEVENTS', 'OBJSTATE')
AND SUBSTR(DVC.VIEW_NAME, -4) <> '_REP'
AND COLUMN_REFERENCE LIKE '%CASCADE%'
AND TYPE_FLAG NOT in ('P'/*,'K'*/)
order by lu_name
Be the first to reply!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.