I am sure we have all used the Display Database Relations command, DSPDBR, to establish any file’s or table’s dependent objects. We can also use a SQL Table Function to give us more (better) columns of data than the DSPSBR command does.
But before I start giving examples of using this Table function I need something to work with. Let me start with a very simple DDL table:
01 CREATE TABLE MYLIB.TABLE1
02 (FIRST VARCHAR(20))
I do not need to insert data into the table.
Next I will create an Index over my Table: