Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
Can I use a SRVPGM in an RPG Stored Procedure?
has no ratings.
Published: 02 Apr 2013
Revised: 03 Apr 2013 - 2150 days ago
Last viewed on: 21 Feb 2019 (6255 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Can I use a SRVPGM in an RPG Stored Procedure? Published by: Chris Proctor on 02 Apr 2013 view comments(3)

Good afternoon! I have an RPG stored procedure (SQL calls the RPG pgm) that I would like to use a service program with, but it appears that when I try to test it from iNav the stored procedure can't find the service program. I get the following error:

 

SQL State: 38501
Vendor Code: -443
Message: [MCH3401] Cannot resolve to object SODSRVPGM. Type and Subtype X'0203' Authority X'0000'. Cause . . . . . :   Either a system pointer or a data pointer can not be resolved. For a system pointer, it can not be resolved to object SODSRVPGM, type and subtype X'0203', authorization X'0000', because either the named object was not in any context referred to or the correct object was located but the user profile did not have the required authority. The object types for some common type or subtype codes follow: -- 0190-Access group, 0201-Program, 0401-Library, -- 0701-Journal receiver, 0801-User profile, 0901-Journal, -- 0B90-Data space, 0C01-Directory, 0C90-Data space index, -- 0E01-Job queue, 0E02-Output queue, 0E03-Message file, -- 0E02-User index, 0A01-Data queue, 1401-Class of service description -- 1501-Mode description, 0E05-Session description, -- 1001-Device description, 1101-Line description, -- 1201-Controller description, 1901-File, 1902-Message queue, -- 1903-Job description, 1904-Class, 1905-Command, 1906-Table, -- 1908-Edit description, 1909-Subsystem description, -- 190A-Data area, 190C-Graphic symbol set, 190D-Chart format, -- 1911-Query definition, 1912-Folder, -- 1915-Panel group, 1916-Menu group description, -- 1920-Data dictionary, 192D-Management collection, 19D0 Work control block table, -- 19D2-System value, 1B01-Process control space, -- 1E01-Byte stream file, 1E03-Local socket, 1E06-Character special file, -- 1E07-First-in first-out special file For a data pointer, it can not be resolved because the named object is not located within any program activation currently known to the process. Recovery  . . . :   Either specify the correct object name or specify the correct authority for the object.

Is there a way to get around this, or can you not use SRVPGMs with a RPG sproc program? Any ideas would be appreciated.

Chris

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS