Data Manager gives me malformed sql.
I have an OLEDB connection to an iSeries DB2/400 database. The iSeries uses a mechanism called library lists. This allows for a kind of override on tables and procedures: the iSeries will go through the library list to find the first match for your query. A table by the same name may exist in more than one library, but you only want the first one in the list, and you have no idea which library that will be (differs from user to user).
When using the Sense Data Manager, it will build the LOAD statement, but it is wrong: the table name is prefixed with the database name (it does not recognise the owner level for some reason - which translates to the library), but this combination is invalid for the server. And even if it did recognize the owner level and added it, that would still be invalid as the system will decide on the actual library upon execution of the statement, and that library may be different from user to user.
Is there a way of qualifying less for the table names in Data Manager?
it will now do something like:
SELECT field1, field2
FROM databasename.tablename; // semantically incorrect
If it did recognize the owner level it would build:
SELECT field1, field2
FROM databasename.ownername.tablename; // semantically correct but not functionally correct in my case
I need an option that allows me to qualify less on the tablenames and get this:
SELECT field1, field2
FROM tablename; // semantically correct and also functionally correct in my case.
Does anyone know how this lesser qualification can be done?
Is there an option somewhere?
The Data Manager throws an error every time I try to add data, because the database server refuses the malformed query.
It also will not give me preview of the data (for the same reason) and makes everything very slow.
I personally use the Data Load Editor and type all my SQL, but for other users this is not an option.
