Try this instead:
--Objects Checked Out
PRINT 'Objects Checked Out'
PRINT''
use JDE7334
select siuser as 'User ID', siobnm as 'Object Name ', simkey as 'Machine', sipathcd as 'Path Code'
from OBJ7334.F9861 where SISTCE != '1'
--Objects created never checked in
PRINT''
PRINT''
PRINT 'Objects created but never checked in'
PRINT''
use JDE7334
Select POOMWUSER as 'User', cast(POOMWOBJID as char(10)) as 'Object', POOMWMKEY as 'Machine', POPATHCD as 'Path Code '
from SYS7334.F98222
where POOMWOT !='UBEVER' and POOMWOST=01 and POOMWCHS='1'
order by POOMWUSER, POOMWOBJID, POPATHCD
--Versions created never checked in
PRINT''
PRINT''
use JDE7334
PRINT 'Versions created but never checked in'
PRINT''
Select POOMWUSER as 'User', cast(POOMWOBJID as char(20)) as 'Object', POOMWMKEY as 'Machine', POPATHCD as 'Path Code '
from SYS7334.F98222
where POOMWOT ='UBEVER' and POOMWOST=01 and POOMWCHS='1'
order by POOMWUSER, POOMWOBJID, POPATHCD
--Objects with tokens held
PRINT''
PRINT''
PRINT 'Objects with tokens held'
PRINT''
use JDE7334
Select POOMWUSER as 'User', cast(POOMWOBJID as char(20)) as 'Object', POOMWMKEY as 'Machine', POPATHCD as 'Path Code '
from SYS7334.F98222
where POOMWPOS1 !=0
--Versions Checked Out in DV7334
PRINT 'Versions Checked Out in DV7334'
PRINT ''
select VRUSER as 'User' , VRPID as 'Object', VRVERS as 'Version', VRMKEY as 'Machine', VRENHV as 'Environment '
from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=SERVERNAME;User ID=SQLID;Password=SQLPASSWORD'
).jde_dv7334.dv7334.f983051
where VRCHKOUTSTS='Y'
order by VRUSER
--Versions Checked Out in PY7334
PRINT ''
PRINT ''
PRINT 'Versions Checked Out in PY7334'
PRINT ''
select VRUSER as 'User' , VRPID as 'Object', VRVERS as 'Version', VRMKEY as 'Machine', VRENHV as 'Environment ' from
OPENDATASOURCE(
'SQLOLEDB',
'Data Source=SERVERNAME;User ID=SQLID;Password=SQLPASSWORD'
).jde_py7334.py7334.f983051
where VRCHKOUTSTS='Y'
order by VRUSER
--Versions Checked Out in PD7334
PRINT 'Versions Checked Out in PD7334'
PRINT ''
select VRUSER as 'User' , VRPID as 'Object', VRVERS as 'Version', VRMKEY as 'Machine', VRENHV as 'Environment '
from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=SERVERNAME;User ID=SQLID;Password=SQLPASSWORD'
).jde_pd7334.pd7334.f983051
where VRCHKOUTSTS='Y'
order by VRUSER
