|
From: Robert M. <rob...@gm...> - 2008-04-30 13:45:24
|
On Tue, Apr 29, 2008 at 11:06 PM, OPLink <as...@op...> wrote: > Robert, > > > The DB2 Plugin was developed against DB2 LUW (andsupport for OS/400 > > > added with help from others). The "IBM DB2 JDBC Universal Driver" > > that I use to connect to LUW doesn't allow you to specify a "System" > > property, so I am not able to see this behavior. Would it be solved > > by simply detecting the system property you mentioned and then > > re-phrasing the SQL with "/" instead of "." in the table identifiers? > > Do table aliases work the same way in this case? > Yes it seems the DB2 Plugin will work if it could detect the naming > convention selected on the driver properties > and then switch to that notation, in this case from SQL to System or '.' to > '/'. I tried changing the plugin myself > I was able to get rid of the message but then nothing would display if > double click on the UDF folder where I am > able to display the functions in that folder if I use the SQL notation. > However it may be my end as I did not > take my time on it. I will attempt again this week. Aliases files should > work the exact same way with members or no members. Ok, let me know if there is anything I can do to help. If you have a patch that works, I'd happy to apply it for you in CVS. > ---------------- > > > > Again, my driver doesn't seem to support this property. When you say > > doesn't work, I assume you mean that you execute some SQL in the > > editor and it fails when using column remarks instead of the column > > name - even though the property is set? It appears as though that > > setting might be ignored by the driver? > The SQL does not fail it excutes fine, however, it will always display the > Column-Name(field name) and not the Remarks(full length text) regardless of > the properties setting for Remarks. The Remarks setting gives me a choice of > 'sql' or 'system' I would think the Remarks data would be displayed for > heading if selected 'system'. > -------------- > To re-phrase: > -------------- > When I double click a file from the object tree I can display the right > pane. From there - in the 'column' tab you will find both the COLUMN_NAME > and REMARKS. It would be great if SQL could display the REMARKS in place of > the COLUMN_NAME based on the driver properties setting for Remarks. But > maybe thats not the DB2 Plugin's responsibility ? I would think that the driver would be responsible for making the switch, given that it's a driver property. We use the metadata that we get from JDBC, so I would think it would be easy for someone to write a small test that shows that the driver doesn't do this and then perhaps submit it as a bug to the DB2 support people. We don't have APIs for the plugin to make this switch in every place that column names would appear. Rob |
