On Tue, Apr 29, 2008 at 11:06 PM, OPLink <as400@...> 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
|