Question

Object references

  • 30 June 2020
  • 0 replies
  • 187 views

Userlevel 5
Badge +15

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


0 replies

Be the first to reply!

Reply