Hello,

I want to read a mainframe DB2 table that has 10 columns, but I only need to use two columns in my webfocexec.

Do I need to map all the columns in my Webfocus MFD or can I map just the columns I need in my Webfocexec.

Thanks!

Z/OS webfocus 7.7

You should map them all. Anyway, the tool does it for you.

Is the full DB2 table mapping required. Will my focexec fail without all the columns in the MFD even though I don't reference them ??? Thanks]

You don't need them all specified in the master - only the ones you know you will use.

Problem solved. Thanks to all!!!

You could also look into "Dynamic columns" when generating the metadata (mas and acx):

"To specify that the Master File created for the synonym should not contain column information, select the Dynamic columns check box.

If this option is selected, column data is retrieved dynamically from the data source at the time of the request."

Reference: Describing Data With Graphical Tools > Accessing Data and Creating Synonyms > Creating Synonyms in Developer Studio >