Clear the SQL CLI - Q1ACLRSQL

Owned by Kathy Kurth
Last updated: Dec 20, 2019 by Aaron Fistler

Many BRMS operations use the SQL Call-Level Interface (CLI) with open data sources. CLI open data sources may conflict with other non-BRMS operations that use the SQL CLI in the same job. The conflicts will cause the operations to fail with message SQ99999. To avoid the SQL CLI conflicts in a job, the following commands must be run in that job:

  • CRTDTAARA DTAARA(QTEMP/Q1ACLRSQL) TYPE(*CHAR)
  • QSYS/CALL PGM(QBRM/Q1AOLD) PARM('CLSSQLENV ')


NOTE: In releases IBM i 7.1 or earlier, the following PTFs or their superseding PTFs are required:

  • 7.1 SI43868
  • V6R1M0 SI43869
  • V5R4M0 SI43862

Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.