Hi,
I was looking at a list of user generated functions from the syscat.function s table, and I noticed that some of the deleted functions (by using DataStudio), still appear in that table. This is problematic to me, because I want to use that table to get all the function signatures and generate tables from them, avoiding the deleted functions, obviously.
Is there a flag somewhere which will tell me firmly which function...
User Profile
Collapse
-
DB2 syscat.functions table
-
DB2 Federation - Command line based
1) I am using the InfoSphere Fed Server, with DB2, both releases 10.5. I am trying to create some wrappers for a federated database. The source databases are MySQL and PostGres. I am getting various errors when attempting to create a wrapper like:
CREATE WRAPPER ODBC LIBRARY 'libdb2rcodbc.s o' OPTIONS (MODULE '/opt/IBM/WSII/V10.5/lib64/libdb2rcodbc.so ');
The SQL statement or command failed because of a database system error....
No activity results to display
Show More