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: <p>"select specificname from syscat.functions where origin = 'E' or origin = 'U'" <p>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. <p>I created a sql user defined function thinking that it might create the functions table...but that didn't help any. <p>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. <p>Has any one had any luck accomplishing this? <p>Thanks <BR>
Michael