Database relations and file usage

Here you'll find a program to collect all database relations into a database file.

In regards to database relations and file usage, not only do you need to know what a physical files database relations are, but also what programs use it and in what capacity.

I run a job every weekend to collect all database relations into a database file. This allows me to run reports against a physical file to locate all programs that use it or any of it's logical files.

/* FILE CROSS REFERENCE REPORT */

Once a week I run the following command in Job Scheduler:

DSPPGMREF PGM(*ALL/*ALL) OUTPUT(*OUTFILE) OUTFILE(PGMREFPF)

Click here to view the code.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Ask your programming questions--or help out your peers by answering them--in our live discussion forums.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.


This was first published in January 2003

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close