Programmer Utilities › Lists › Convert Object Lists › Converting Database Relations into an Object List

Converting Database Relations into an Object List

The Toolkit command Convert Database Relations (YCVTDBR) converts the output of the Display Database Relations command (DSPDBR) into an object list. This gives you an alternative way of identifying all of the logical files dependent on a physical file or files.

For example, the effect of the following three commands would be to print a list of all logical files which are based on physical files in library QGPL, but which are not themselves in QGPL:

YCVTDBR FILE(QGPL/*ALL) /* build list */
YFLTOBJLST FILTER(*OMIT) OBJ((*ALL QGPL)) /*filter list */
YDOCOBJLST /* print list */