Check Out Status

[engineering_one]

[smile]

Hi,

Can someone please tell me in which OL table the Object Check Out/In status (DD Item OMWOST) is stored? I am trying to erase check out for a large number of objects and I was thinking of submitting a SQL directly on the table.

Thanks in advance.

 

[Christian Audet]

Hi,

The checkout is actually store in F9861 as a separate record for the machine that hold the check-out. Look in F9861 in the column SIOBNM and you will see the extra record for every check-out.

Christian Audet

 

[bmansfield]

Hi

You would need to modify data in tables f9861(Object Liberian - Status detail) and f983051 (Version table).
Check the SISTCE column for object status. You would need to write a query joining the associated versions which would also need to be updated (set vrchkoutsts = N)

Brad

 

[brother_of_karamazov]

Try these...

Objects Checked Out:

column siobnm format A11 heading 'Object 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' truncate
column 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 format A11 heading 'Path Code'
column POOMWUSER format A11 heading 'User'
column POOMWOBJID format A20 heading 'Object Name' truncate
column 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;

 

[Adrian_Chimirel]

Well done Brother,
May I suggest to have your scripts added to the Tips & Tricks Forum? I'm sure they're going to make A LOT OF people happy!
Thank you,
Adrian Chimirel
PS Christian/Eric/Sef, what do you think?

 

[Christian Audet]

I agree with you Adrian,

Nice script Brother ! most CNC will appreciate.

Christian Audet

 

[engineering_one]

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

 

[engineering_one]

Thanks for the help !!

-Engineering_One

Message -----
From: "bmansfield" <[email protected]>
To: <[email protected]>
Sent: Tuesday, June 11, 2002 11:10 PM
Subject: Re: Check Out Status


detail) and f983051 (Version table).Check the SISTCE column for object
status. You would need to write a query joining the associated versions
which would also need to be updated (set vrchkoutsts = N)Brad



Engineering One

 

[engineering_one]

Hi Christian,

Thanks for the help.

-Engineering
----- Original Message -----
From: "christian_audet" <[email protected]>
To: <[email protected]>
Sent: Tuesday, June 11, 2002 6:15 PM
Subject: Re: Check Out Status


machine that hold the check-out. Look in F9861 in the column SIOBNM and you
will see the extra record for every check-out.Christian Audet



Engineering One

 

[Christian Audet]

Engineering One,

I just want ot add that when you don't have to send three eMail to say thanks to everybody since we will receive all of them. Just One eMail and everybody will receive it. Anyway we now know that you appreciated ! [smile]

Christian

 

[brother_of_karamazov]

Thanks.

In case anyone wondered those were the Oracle versions. Here are the SQL Server versions:

Objects Checked Out:

use JDE7333
select sipathcd as 'Path Code', simkey as 'Machine', siobnm as 'Object Name', siuser as 'User ID' from OBJ7333.F9861 where SISTCE != '1'


Versions Checked Out:

use JDE_DV7333
select VRENHV, VRUSER, VRPID, VRVERS, VRMKEY from DV7333.F983051 where VRCHKOUTSTS='Y'
or
use JDE_PY7333
select VRENHV, VRUSER, VRPID, VRVERS, VRMKEY from PY7333.F983051 where VRCHKOUTSTS='Y'


Objects Created but never checked in:

use JDE7333
Select POOMWUSER as 'User', POOMWOBJID as 'Object', POOMWMKEY as 'Machine', POPATHCD as 'Path Code 'from SYS7333.F98222
where POOMWOT !='UBEVER' and POOMWOST=01 and POOMWCHS='1' order by POOMWUSER, POOMWOBJID, POPATHCD


Versions Created but never checked in:

use JDE7333
Select POOMWUSER as 'User', POOMWOBJID as 'Object', POOMWMKEY as 'Machine', POPATHCD as 'Path Code 'from SYS7333.F98222
where POOMWOT ='UBEVER' and POOMWOST=01 and POOMWCHS='1' order by POOMWUSER, POOMWOBJID, POPATHCD