Defining conditions to database field

Products

• CA 2E

Issue/Introduction

Running the command YDOCMDLFLD PRTFLDDTL(*YES) PRTCND(*YES) provides a report of conditions, but does not tie the conditions to a database field.

Is there a method to create a query to tie the information on the edit field details?

Environment

CA 2E 8.7.x

Resolution

Unfortunately, there is no command in CA 2E at this point in time which can provide a report that:

a.  Lists out the Referencing field, the related Reference field and the list of conditions associated with that Referencing field OR

b.  Lists out the conditions and the individual Referencing fields using those conditions 

Try the below query:

select a.CND, a.OBJATR, b.FLD                                   
from YCNDDTARFP a inner join YFLDDTARFP b on a.@@OWN = b.@@DOM  
where (b.OBJATR = 'REF' and b.@@FLD > 1024)                     
order by b.@@DOM, b.@@FLD, a.OBJATR

Notes:

1.  Set set the library list for the model and run the STRSQL tool from the command line

2.  Once inside the tool, enter SQL Query and execute it