Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
STRDBMON question
has no ratings.
Published: 23 Mar 2016
Revised: 24 Mar 2016 - 2292 days ago
Last viewed on: 30 Jun 2022 (3232 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

STRDBMON question Published by: Chris Proctor on 23 Mar 2016 view comments(7)

Good morning, all! I'm new to STRDBMON and I'm trying to figure out how to appease auditors (I know, good luck with that! Lol) by capturing database changes and I found an article where we could allow our BAs to use STRSQL or RUNSQLSTM to update records and the STRDBMON would capture those changes in a file. Much cleaner to look at then journal entries!! Lol.

Anyway, I noticed that if the update is done with RUNSQLSTM I see the complete SQL statement, but if I use STRSQL the variables are replaced with question marks. Is there a way to see the full SQL statement like I do with RUNSQLSTM? I'm hoping maybe it's a value in the STRDBMON command.

Any suggestions would be greatly appreciated!

Return to midrangenews.com home page.
Sort Ascend | Descend