Link table

From our DBA:

They can do this.  The linked table needs to be defined in Lawson dbdef so that you can see it with a custom Lawson program.  You would define the link the same way that you define a view.

Send me your email if you want to discuss offline. Judy Consoli

See Knowledge Base Article

KB 1208563

for information on building a view

Thanks Judy.

The thing to remember is there is no such thing as Linked Tables in SQL Server. There are Linked Servers, that allow you to Link Servers together to do the same thing as Fully Qualified Names. Once you link the servers you can create a View that references the Base Table(s) in the Foreign Database. You would then define the View up in Lawson's dbdef as described in the above KB article. The Lawson custom program can then  Add, Delete and Modify columns in one of the Foreign Base Tables referenced in the View. This can be done because SQL Server allows updating columns in only one base table that is in a View. If your View only references one table then this would not be a problem. Also, remember to define your column datatypes in your foreign Table(s) as types that are supported by dbdef. Either that or you will need to do cast or converts in your view.

Ari, Thanks for the information. I was able to create view and access the data using rngdbdump