Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
This is very similar to the SQL Server Linked Servers.
// CREATE SERVER oraserver TYPE oracle VERSION 8.1.7 WRAPPER net8 OPTIONS (NODE 'paris_node')
// CREATE NICKNAME DB2SALES FOR DB2SERVER.SALESDATA.EUROPE
select * from syscat.servers
I was unable to configure our developer edition to support the CREATE SERVER object. Though some configurations settings say its its correctly supporting federated it still gives me the same errors trying to create the objects. I am not sure but we may need to install a Enterprise edition to correctly configure the federated option. I read this but I am not sure why...
I've managed to configure some of the servers on aws to support federated and will build tree nodes with detail views. Will not add GUI's or scripting yet...
I've managed to configure some of the servers on aws to support federated and will build tree nodes with detail views. Will not add GUI's or scripting yet...
In order to correctly create this I need to create a Wrapper node. Under the wrapper node we will have Server Nodes that will contain two object folders, <User Mappings> & <Remote Tables>... I've figured out how to create all the objects and where to extract the needed information per db2 8.2 and above. Should have it ready in a day or two but will need lots of testing. Currently only linking db2 databases to db2 databases.
Will also have to add a <Nick Name> node under the server node for pointers to tables on servers...
In order to correctly create this I need to create a Wrapper node. Under the wrapper node we will have Server Nodes that will contain two object folders, <User Mappings> & <Remote Tables>... I've figured out how to create all the objects and where to extract the needed information per db2 8.2 and above. Should have it ready in a day or two but will need lots of testing. Currently only linking db2 databases to db2 databases.
Will also have to add a <Nick Name> node under the server node for pointers to tables on servers...
checking in initial work. still need to work on extraction for detail view for nicknames, remote tables & user mappings....
checking in initial work. still need to work on extraction for detail view for nicknames, remote tables & user mappings....
initial code complete. The nodes with there detail views are all complete now. There is a lot more work that can be added to this if customer request is significant enough.
a.) Extract and scripting of the objects
b.) GUI's
c.) Extra node information to further break down the remote objects; such as remote table columns and datatypes.
initial code complete. The nodes with there detail views are all complete now. There is a lot more work that can be added to this if customer request is significant enough.
a.) Extract and scripting of the objects
b.) GUI's
c.) Extra node information to further break down the remote objects; such as remote table columns and datatypes.
Issue #12279 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
I was unable to configure our developer edition to support the CREATE SERVER object. Though some configurations settings say its its correctly supporting federated it still gives me the same errors trying to create the objects. I am not sure but we may need to install a Enterprise edition to correctly configure the federated option. I read this but I am not sure why...