Stored procedures : library list

[Guest.Visitor]

We would like to use stored procedures (on AS400 : RPG-programs with embedded SQL-statements) from NT-clients (application developed in VisualBasic 6.0). Unfortunately, we have problems to get access to objects dispersed over multiple libraries. We tried to define the necessary library list in the data-source (DSN) of the ADO-connection, but we only manage to reach the objects of the first library in the list. Any assistance would be greatly appreciated ! SGS CORTEX

[Guest.Visitor]

SGS, I am not sure I understand the problem, but you should be able to add libraries to your path with the following SQL statements: SET PATH = CURRENT_PATH, addlib SET PATH = lib1,lib2,lib3 Most functional calls, etc. will look at this path. To retrieve or display the current path, you can specify CURRENT_PATH in a select statement. David Morris