Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Need help supporting AS400 using DTP
Need help supporting AS400 using DTP [message #33349] Mon, 23 July 2007 16:24 Go to next message
Neil Hauge is currently offline Neil HaugeFriend
Messages: 475
Registered: July 2009
Senior Member
We use the DTP DB Definition Model to generically support reading database
metadata for object mapping purposes. We currently have a problem
supporting AS/400, resulting in bug 193013
(https://bugs.eclipse.org/bugs/show_bug.cgi?id=193013). Ideally I would
like to rely on DTP to figure out how to get metadata from different DB
types, but we are not doing this as a result of DTP bug 182415
(https://bugs.eclipse.org/bugs/show_bug.cgi?id=182415).

So, I suppose there are a couple of different ways to resolve this issue,
but looking at the current code and our current problem, I'm hoping that
someone can help us figure out how to support AS400 DB with the DTP model

Currently we are trying to match the default catalog name from any
database type to try and get a hold of the schemas. We have a few
different cases to get the right catalog to get the schemas, but none of
these seem to support
AS400. The DTP DSE does manage to display the tables for AS400, so it
seems you guys are getting it right. It also worked in RDB.

This is what we currently have:

public String getDefaultCatalogName() {
if( !this.supportsCatalogs()) { // this database doesn't
support catalogs
return "";
}
String userName = this.profile.getUserName();
for (org.eclipse.datatools.modelbase.sql.schema.Catalog dtpCatalog
: this.dtpCatalogs()) {
if( dtpCatalog.getName().length() == 0) { // special catalog
that contains all schemata
return "";
}
else if( dtpCatalog.getName().equals( userName)) {
return userName; // returns user name as default
catalog
}
else if( dtpCatalog.getName().equals( this.getName())) {
return this.getName(); // special catalog with same
name as DB (PostgreSQL)
}
}

Are we missing the hook for AS400's "catalog" or lack thereof?

Neil
Re: Need help supporting AS400 using DTP [message #34189 is a reply to message #33349] Wed, 08 August 2007 21:44 Go to previous message
No real name is currently offline No real nameFriend
Messages: 2
Registered: July 2009
Junior Member
The as400 doesn't support catalog, so there is no catalog objects created
in the model. The container of schema is database. You can retrieve
schemas only from database.
Re: Need help supporting AS400 using DTP [message #587081 is a reply to message #33349] Wed, 08 August 2007 21:44 Go to previous message
No real name is currently offline No real nameFriend
Messages: 2
Registered: July 2009
Junior Member
The as400 doesn't support catalog, so there is no catalog objects created
in the model. The container of schema is database. You can retrieve
schemas only from database.
Previous Topic:SQL Editor appearance
Next Topic:how to get sql server special data type(like image) via dtp's dse
Goto Forum:
  


Current Time: Thu Mar 28 21:33:55 GMT 2024

Powered by FUDForum. Page generated in 0.03000 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top