SELECT "OWNER","OWNERID","TNAME","TOBJID","CALLORDER" from sys.exu7pst
WHERE (ownerid, tname) in
(SELECT i.owner#, i.name
FROM sys.incexp i, sys.incvid v
WHERE i.expid > v.expid AND i.type# = 2)
SELECT "OWNER"
, "OWNERID"
, "TNAME"
, "TOBJID"
, "CALLORDER"
FROM SYS.EXU7PST
WHERE (OWNERID
, TNAME) IN
(SELECT I.OWNER#
, I.NAME
FROM SYS.INCEXP I
, SYS.INCVID V
WHERE I.EXPID > V.EXPID
AND I.TYPE# = 2)
|
|
|