Hi,
Thanks for the help. It was indeed very helpful.
-Engineering One
----- Original Message -----
From: "brother_of_kara" <
[email protected]>
To: <
[email protected]>
Sent: Wednesday, June 12, 2002 6:05 AM
Subject: Re: Check Out Status
Name'select sipathcd as "Path Code", simkey as "Machine", SIOBNM, siuser as
"User ID" from OBJ7333.F9861 where SISTCE != '1' order by siuser,
siobnm;Versions Checked Out:column VRENHV format A11 heading 'Environment'
select VRENHV, VRUSER as "User", VRPID as "Object", VRVERS as "Version",
VRMKEY as "Machine" from DV7333.F983051 where VRCHKOUTSTS='Y' order by
vruser, vrpid, vrvers;Objects Created but never checked in:column POOPATHCD
format A11 heading 'Path Code'column POOMWUSER format A11 heading 'User'
column POOMWOBJID format A20 heading 'Object Name' truncatecolumn POOMWMKEY
format A20 heading 'Machine'Select POOMWUSER, POOMWOBJID, POOMWMKEY,
POPATHCD from SYS7333.F98222 where POOMWOT !='UBEVER' and POOMWOST=01 and
POOMWCHS='1' order by POOMWUSER, POOMWOBJID, POPATHCD;Versions Created but
never checked in:column POOMWPRJID format A11 heading 'Project'column
POOPATHCD form!
column POOMWOBJID format A20 heading 'Object Name' truncatecolumn POOMWMKEY
format A20 heading 'Machine' Select POOMWUSER, POOMWOBJID, POOMWMKEY,
POPATHCD from SYS7333.F98222 where POOMWOST=01 and POOMWCHS='1' and
POOMWOT='UBEVER' order by POOMWUSER, POOMWOBJID, POPATHCD;
Engineering One