O'Reilly logo

The Programmer’s Guide to iSeries Navigator by Paul Touhy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

8. Get the Picture

They say that a picture can paint a thousand words, and never a truer word was spoken when it comes to a relational database.

Have you ever tried to work out what the dependencies exactly are on a physical file? You must use a combination of commands like Display File Description (DSPFD) and Display Database Relationships (DSPDBR).

Figure 8.1 shows an example of the output for the DSPFD command for the SAMPL00001 (SAMPLE_EMPLOYEE) table. If you feel like whiling away 10 or 20 minutes, you can spend it dissecting the contents of the output and, using your trusted pen and paper, make a list of the journal, constraints, and triggers associated with the file. There is no point in looking for dependent logical files, because they ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required