SQLP

SQLP  procId procName schemaName locationName

• This record generates a row in the DMH_SQL_PROC table of the data base, if it does not exist.
• This record can generate a row in the DMH_ANALYSIS_QUEUE table of the data base, if the stored procedure dynamic name resolution is required, and it does not exist.
• A START CU record must be encountered before a SQLP record can be processed.
• Only one SQLP record is required, per compile unit, regardless of the number of references to the stored procedure.
• The first two attribute fields must be specified:
  • procId is a consecutive integer beginning with one used to uniquely identify the SQL stored procedure within the bounds of this compile unit.
  • procName is a character string naming the actual stored procedure.
• The final two attribute fields are optional:
  • schemaName is a character string naming the authorization id of the owner of the stored procedure.
  • locationName is a character string naming the remote server as it is known to the local DB2 SQL applications.