[Squirrel-sql-develop] Implementing DB2 Properties...Name & Remarks

Im not sure if im missing something or if the following is an issue. It seems the DB2 Plugin does not reconize a few 

driver properties :



DB2 Plugin does not consider the option selection 'System" for the Driver Properties "naming". DB2 Plugin will always use the SQL dot notation for naming files regardless of the 'naming' selection. (this is not on statements entered in the SQL editor but rather the plugin itself)

 

Example:   in the UDFParentExpander.java the FROM file in the SELECT statement will always us the dot notation  ".SYSIBM.SYSFUNCTIONS..."  regardless of the naming convention selected in the Driver Properties. If I were to select the "System" as the naming convention I can use the standard i5/OS forward slash, "/" instead of the dot notation for SQL statements. In addition, using the 'System" properties will allow the searching of a library list to go into effect. 

 

To reproduce this error:

Select the "IBM DB2 App Driver" then select "Properties", then "Driver properties" tab.

>From the "driver properties"  check off "Use driver properties'

Then select "System" for the "naming' properties. 

Then select OK 



After setting up the driver properties execute the driver and then  from the objects tree select a library folder then double click UDF. 

The following message should appear:

Error: UDF: java.sql.SQLException: [SQL5016] Qualified object name SYSFUNCS not valid.

-----

There is also a nice feature in the Driver Properties called "Remarks". This will allow the use of the remarks as a column name instead of the field name. This remark information is the actual expanded text info of the field name defined in DDS on the i5/OS. 

This feature does not seem to work.



thanks

joe mcdonald