How to retain formats / labels in the query window

[Ebele]

Hi,
I have registered SQL Server tables in the metadata.
In the registered metadata, I have changed some attributes like column formats and column descriptions. Attributes which cannot be stored in the SQL server table.

When I query the table using the query builder in EG 4.3 through a library assigned with metadata libname engine,
the formats / labels are not retained to the resulting table.

Is there a way to achieve this ?

Thanks,
Ebele

[Patrick]

Hi

The library needs to be pre-assigned in order for table metadata to be used.

Eventually you could add option "defer=yes" to the metadata library definition so the connection to the database will only be established when you actually use one of the tables (at least I think this is how it works).

Do NOT use "defer=yes" if this is an OLEDB connection: http://support.sas.com/kb/41/581.html


HTH
Patrick

[Ebele]

Hi Patrick... yes, that's it!
I thought using the meta engine would be enough, but you also need to pre-assign it.
Thanks a lot.
Ebele