Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Writing Custom Scripts to Run Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

Writing Custom Scripts to Execute Batch Jobs

Stored Procedure Definition for Batch Unmerge Jobs

Stored Procedure Definition for Batch Unmerge Jobs

The following sample shows a stored procedure definition for a Batch Unmerge Job:
PROCEDURE BATCH_UNMERGE( IN_BO_TABLE_NAME IN CMXLB.CMX_TABLE_NAME, IN_XREF_LIST_TO_BE_UNMERGED IN CMXLB.CMX_TABLE_NAME, OUT_UNMERGED_XREF_LIST IN CMXLB.CMX_TABLE_NAME, IN_ROWID_JOB_CTL IN CMXLB.CMX_ROWID, IN_INTERACTION_ID IN INT, OUT_UNMERGED_XREF_COUNT OUT INT, OUT_ERROR_MSG OUT CMXLB.CMX_MESSAGE, OUT_RETURN_CODE OUT INT, OUT_TMP_TABLE_LIST IN OUT CMXLB.CMX_BIG_STR, IN_USER_NAME IN CMXLB.CMX_USER_NAME DEFAULT NULL, IN_ALLOW_COMMIT_IND IN INT DEFAULT 1 )

0 COMMENTS

We’d like to hear from you!