Query Gen Database to get Screens and the Tables/Fields Used by those Sceens

I don't have this specific GEN information for you, but ...  you could use a Lawson tool to do this.  Or you could use a script (If you're Unix) that I wrote to create web pages from the information.

I haven't looked at what Greg uploaded, but I would start by taking a look at the following gen tables:

filedef
filefld
fileind
fileindfld
system
docfile
element

HTH,
-Shane

I just checked out Greg's script. It's good. I have a more spartan script to do the same thing, but his does all the error checking I didn't put into mine.

Now if you need this info for GEN, I'll dig out my script for that and post it, since dbdoc/dburf do not work for GEN.

Also, if you need function codes (FCs) for the forms, that isn't in GEN at all. You'll have to either parse the form xml files created by xscrgen, or parse the output from the Xpress servlet.

Kwane