var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: I have linked an as400 database to Sql 7.0, now how do I select data from it?
I am trying to get data from an AS400 database (JD Edwards). I have created the linked server, and can see all the tables, but how do I reference them in a sql statement?
Select * from [LinkedServerName.DatabaseName.OwnerName.TableName]
How do I find the database name and owner name of the JD Edwards Database on the AS400?
Figured it out - Thanks
On the AS/400, I had to go to WRKRDBDIRE (Work with Relational Database Directory Entries).
If an RDB Directory Entry doesn't exist for '*Local' on the AS400, one must be added. I created one named TEST for the local server.
So, the final syntax is is like this:
[Linked Server Name].[RDB Entry Name].[Library].[File]