We are using iDM 764 and UniVerse adapter to connect to UniVerse database. I generated a synonym for a table which has multivalued fields. When I retrieve the sample data for the synonym I am not seeing any data for the mutlivalued columns. Is there any configuration in the master file/synonym I need to do to extract multivalue field data?

EDASPROF has the following-
ENGINE SQLUV SET CONNECTION_ATTRIBUTES UnivDev...
ENGINE SQLUV SET OPENMODE NNF

According to the R764 doco:
The OPENMODE NNF setting determines how tables with multivalued columns are treated.
For the Adapter for Universe to function properly, OPENMODE must be set to NNF in
edasprof.prf.

Since you already have that, have you tried creating a simple procedure to read the table rather than using the 'Sample Data' option? With some types of data I have seen the Sample Data option not work.

Using "Sample Data" wizard and a procedure which has a UV SQL I am able to fetch the data in all the columns in the table except the multivalued columns.

Is there a technique to fetch the data in multi-valued columns other than setting the OPENMODE to NNF?