I've just written my first Stored procedure, but am struggling to get it to run in the required way; The procedure is fine, but it uses a file which is in a different library to the procedure, and can't therefore be found at run-time. So, I created a jobd for the user concerned, (the user defined on the ADO connection) and set the required libraries in there. This jobd was added to the users profile. Every time I run the job, QDFTJOBD is still used. Does anyone have any advice on the best way to control the library list please?
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Stored Procedures and Library Lists
Collapse