We have an as400 db2 system using several libraries.
Library “X” contains the compiled pgms and stored procedures. “Y” contains the more dynamic tables of our db2 database. “Z” contains the more static/less dynamic tables of the db2 database.
We’ve created a web app using Notes 6 running on Domino on the as400.
We have a DB directory entry defined as “MCIC” *local. We have a user profile “ABC” defined which contains “X”,“Y”,“Z” as part of the library list.
We connect using this statement: conAS400.ConectTo(‘MCIC’,‘ABC’,‘password’)
If we trigger an sql with an explicit reference to the library and filename, no problem. If we trigger an sql with no library explicitly specified, we get this error: “FILENAME in ABC type *FILE not Found.” In other words the as400 library list means squat to Notes and Domino.
How do we apply the library list to a stored procedure being called from a notes agent?
Once called, will the stored procedure know the library list and be able to use it? Or do we need to code every file reference and sub-pgm call to a specific library and file or library and pgm? This task would be huge. And it sure is bloddy disconcerting to discover this at this stage of the game.
I guess, my question is, as far as the library list goes, where does notes end and as400 begin on a call to a stored procedure?
Any help on this would be greatly, greatly appreciated.
Thanks in advance,
Terry
Subject: as400 library list and stored procedure
I know this is a really old post, but if you’re using the iSeries access ODBC Driver, the DSN configuration has a place where you can specify your library list.
Subject: as400 library list and stored procedure
Terry, I have to tackle a similar situation later this week with Domino hitting DB/400 via LS:DO SQL calls.
One thought I had for you is that Domino runs under the QNOTES user profile. Can you associate the library list with QNOTES?
In my case, I’m just trying to run my Domino code against a test set of databases on the same 400 as the production databases. No stored procedures involved. It will be nice if I don’t have to give all the test databases a “test” name to distinguish them from the real thing. Any thoughts?
Subject: RE: as400 library list and stored procedure
We touched base with our IBM support people to advise them on several items that we will need help with.
When we mentioned multiple libraries, the long silent pause was quite discomfitting.
They are sending us one of their guys to help us deal with these, and other, issues.
It will be interesting to know what he has to say about Domino’s support of the as/400 multiple libraries architecture.
Subject: RE: as400 library list and stored procedure
Looking at my code again, I realize that I am already specifying the library in every call. Something like library.database. So it’s no problem for me to point to a different library.
I wonder if you can use the same “dot notation” in your calls?