|
Background: We are running Domino 4.6.6c on V4R4 of OS/400. We have an RPGLE program called SPTEST2. It is NOT registered as a stored procedure. The agent below works fine. The problem I am trying to solve is 'why does the library have to be equal to the user id?'. I created the user profile RON2 with the following command: CRTUSRPRF USRPRF(RON2) PASSWORD(TEST) GRPPRF(SSA) OWNER(*GRPPRF) Notice, no special job description to get a library list from or anything. Also when the user signs on to a 5250 session the library RON2 does not appear in their library list. Yet the program works if it exists in a library called RON2. And from the WRKRDBDIRE I have the following: Display Relational Database Detail Relational database . . . . . . : GDISYS Remote location: Remote location . . . . . . . : *LOCAL Text . . . . . . . . . . . . . . : Sub addusingstoredprocedure Dim session As New notessession Dim conn As New ODBCconnection Dim query As New ODBCquery Dim result As New ODBCResultSet Dim p1 As Integer Dim p2 As String Dim servername As String Dim n As Integer Dim tables As Variant Dim msg As String If session.isonserver Then servername="GDISYS" Else servername="GDISYS-RON" End If Msgbox "Connecting to " & servername If Not conn.connectto(servername,"RON2","TEST") Then Print "Could not connect to the AS/400 " & servername & "." Msgbox "Could not connect to the AS/400 " & servername & ". Try again later.",,"Error Connecting" Exit Sub End If tables = conn.ListProcedures() msg = "GDISYS contains the following stored procedures:" & Chr(10) If Ubound(tables) = 0 Then Messagebox "No procedures",, "Stored Procedures list" ' Exit Sub End If For n% = Lbound(tables) To Ubound(tables) msg = msg & Chr(10) & tables(n%) Next Msgbox msg Msgbox "Connected to " & servername +--- | This is the Domino/400 Mailing List! | To submit a new message, send your mail to DOMINO400@midrange.com. | To subscribe to this list send email to DOMINO400-SUB@midrange.com. | To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: meechamw@ptd.net +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.