Tweet
I am trying to reverse engineer a database from the AS/400(v5r2) using Microsoft Visio 2000 SR1 and I can not get it to work using visio's IBM DB2 universal database driver. I started the tracing for ODBC and the log shows that it is trying to execute a CLI stored procedure "SQLExecDirect" with the following statement: "select specificname from syscat.functions where origin = 'E' or origin = 'U'" The "functions" table does not exist on our computer. I would imagine that it would be in the SYSIBM library if it did exist because thats where the system catalog exists. I created a sql user defined function thinking that it might create the functions table...but that didn't help any. I can use the Generic ODBC driver to pull the tables but it does not pull the views(logicals) for the files. The whole purpose is to get all the information. Has any one had any luck accomplishing this? Thanks Michael