Re: Data Dictionary

I got to thinking one more thing.  I've barely glanced at MS SQL Server. 
However maybe by data dictionary they meant the following.   Look at the 
views in the library QSYS2.  Especially SYSCOLUMNS.  The other ones are 
cool also, like SYSTABLES.  And, did you know, that SQL Server uses some 
of these same names?  So, on either machine, you can do a 

SELECT 
 SUBSTR(TABLE_SCHEMA,1,10),
 SUBSTR(TABLE_NAME,1,10) 
FROM SYSCOLUMNS 
WHERE COLUMN_NAME='IPROD' 

Granted, many applications on i5/os use different names for a column 
depending on what table it is in.  For example, product number may be 
called IPROD in one table, LPROD in another.  All because of some extra 
work required in RPG/400 that got much easier in RPGLE (prefix vs renaming 
all fields if you use two different tables in the same program with 
product number in it)

And iNav uses these views to create a GUI if that's what these people are 
used to.

Rob Berendt