Re: How to query SQL statements used?

the data is stored in multiple records and the statement should be
rebuit..
but You can query it easily using IBM Navigator for I (under database SQl
performance monitor..)
the statement can be displayed including the values...

Paul





From: Rob Berendt <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 06/11/2018 17:44
Subject: Re: How to query SQL statements used?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



cl: STRDBMON OUTFILE(ROB/ROBDBMON) JOB(*ALL) FTRFILE((ERPLXF/*ALL));

select *
from erplxf.rco;

INSERT INTO erplxf.rco(cmpny)
VALUES (55);

update erplxf.rco
set cmpny=66 where cmpny=55;
select * from erplxf.rco where cmpny=66;
delete from erplxf.rco where cmpny=66;
commit;
select * from rob.robdbmon;
select
qqjob as JobName,
qquser as JobUser,
qqjnum as JobNumber,
qqstim as StartTime,
qqc183 as IPAddress,
qq1000 as SqlStatement1,
qvc102 as CurrentUser1,
qvc1284 as CurrentUser2,
qvc3001 as SoftwareTitle,
qvc3002 as CurrentUser3,
qvc3003 as PCName,
qvc3005 as PCOSVersion,
qvc3006 as PCProgramandDirectory,
qqsmint5 as sqlstatementif1,
qq1000L as SqlStatement2,
qqclob2 as SchemaList,
dbmon.*
from rob.robdbmon dbmon
where qqsmint5=1
order by StartTime asc
;
cl: ENDDBMON JOB(*ALL);

SQLSTATEMENT1
select * from erplxf.rco
update erplxf.rco set cmpny=? where cmpny=?
select * from erplxf.rco where cmpny=?
delete from erplxf.rco where cmpny=?
select pord, pline, pqrec from ERPLXF.hpol01 hpo where pqrec>? and
pltdt>=? order by Pord, pline
select * from erplxf.rco
update erplxf.rco set cmpny=? where cmpny=?
select * from erplxf.rco where cmpny=?
delete from erplxf.rco where cmpny=?
select pord, pline, pqrec from ERPLXF.hpol01 hpo where pqrec>? and
pltdt>=? order by Pord, pline

Ok, I would rather see the actual values instead of substitution flags.


Rob Berendt