Troubleshooting
Problem
This document provides information about a problem where message SQL0552 is received when running CREATE PROCEDURE from RUNSQLSTM.
Resolving The Problem
You might see message SQL0552 when creating a SQL Stored Procedure because authority is lacking to the SQL Catalog tables. Ensure that public authority on QSYS2/SYSPROCS is set to *USE and QSYS2/SYSPARMS is set to *CHANGE, or you can refer to the following for additional information on the required authorities:
For CREATE PROCEDURE to work, the following authorities are required:
| Library QSYS2 | *EXECUTE authority |
| File QSYS2/SYSPROCS | *OBJOPR authority |
| File QSYS2/SYSROUTINE | *OBJOPR, *ADD authority |
| File QSYS2/SYSPARMS | *OBJOPR, *ADD authority |
| File QSYS2/SYSRTNDEP | *OBJOPR, *ADD authority |
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0"}]
Historical Number
475151514
Was this topic helpful?
Document Information
Modified date:
11 November 2019
UID
nas8N1013930