IBM Support

SQL statements in logs for LoadInventoryMismatch API

Question & Answer


Question

Can you retrieve 'INSERT' SQL statements in logs for LoadInventoryMismatch API running in BatchMode in IBM Sterling Order Management?

Cause

You want to identify the issue with LoadInventoryMismatch API running in BatchMode.

Answer

If LoadInventoryMismatch API have been implemented with BatchMode enabled and there is an error at SQL/Database level during API execution, there will be a need to identify which SQL caused the error.

Sterling Order Management System(OMS) do not have the logging ability for SQL statements being executed in batch mode of LoadInventoryMismatch API. BatchMode in LoadInventoryMismatch API have been provided as an enhancement to improve the performance of the API. For triage, API can be called with BatchMode=N in its input.

[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Documentation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21989635

Page Feedback