SELECT ABALPH, FSOBNM, RLFRROLE, RLTOROLE
FROM sy910.F00950, sy910.F95921, sy910.F0092, PRDNDTA.F0101
WHERE FSOBNM = 'P3006' AND
FSUSER = RLFRROLE AND
RLTOROLE = ULUSER AND
ULAN8 = ABAN8 ;
SELECT
sy910.F95921.RLTOROLE "USER",
sy910.F95921.RLFRROLE "ROLE",
sy910.F95921.RLEFFDATE,
sy910.F95921.RLEXPIRDATE,
sy910.F00950.fssety,
sy910.F00950.FSOBNM,
trim(sy910.F00950.fsfrdv) "version",
sy910.F00950.fssy,
sy910.F00950.fsfmnm,
sy910.F00950.fsinsl,
sy910.F00950.fsrun,
sy910.F00950.FSVWYN,
sy910.F00950.FSA "Add",
sy910.F00950.FSCHNG "Change",
sy910.F00950.FSDLT "Delete",
sy910.F00950.FSIOK "OK/Select",
sy910.F00950.fsicpy "Copy",
sy910.F00950.fsiupt,
sy910.F00950.fsatn1,
sy910.F00950.fsatn2,
sy910.F00950.fsatn3,
sy910.F95921.RLUPMJ,
SY910.F95921.RLUPMT,
TO_DATE(TO_CHAR(sy910.F00950.fsupmj+1900000),'YYYYDDD')"UPMJ",
sy910.F00950.fsupmt,
sy910.F0093.llll,
sy910.F0093.llseq
FROM
sy910.F95921,
sy910.F00950,
sy910.F0093
WHERE
sy910.F00950.FSUSER = sy910.F95921.RLFRROLE
and LLUSER = RLFRROLE
/*AND sy910.F95921.RLEFFDATE <= 115240
AND
(
sy910.F95921.RLEXPIRDATE >= 115240
or SY910.F95921.RLEXPIRDATE = 0
)*/
and SY910.F0093.LLLL = 'JUSPD910'
and sy910.F95921.RLTOROLE in ( /*'BMANDA01', 'JKAMAR01','KYADAP01', 'CSINGA01','SVULUV01', 'KBHASK01', 'SKANN01'*/ 'MSEEFR01')
and SY910.F95921.RLTOROLE not like 'STRE%'
AND SY910.F95921.RLTOROLE NOT LIKE 'TEST%'
/*AND SY910.F95921.RLFRROLE NOT IN('P:USPROCHG', 'USHRSECURE')*/
/*AND SY910.F95921.RLFRROLE IN ('USBTF2SF', 'USBTF2PLN')*/
and sy910.F00950.FSOBNM like '%4116%'/* in('R04431', 'R04431A', 'P48013')*/
ORDER BY
sy910.F95921.RLFRROLE,
sy910.F00950.FSOBNM,
sy910.F00950.FSFRDV,
sy910.F95921.RLTOROLE, sy910.F00950.FSSETY;
select * from sy910.f95921 where rltorole in ( 'BMANDA01', 'JKAMAR01','KYADAP01', 'CSINGA01','SVULUV01', 'KBHASK01', 'SKANN01') order by rlfrrole, rltorole;
select * from sy910.F00950 where fsuser = 'P:DEV';
FROM sy910.F00950, sy910.F95921, sy910.F0092, PRDNDTA.F0101
WHERE FSOBNM = 'P3006' AND
FSUSER = RLFRROLE AND
RLTOROLE = ULUSER AND
ULAN8 = ABAN8 ;
SELECT
sy910.F95921.RLTOROLE "USER",
sy910.F95921.RLFRROLE "ROLE",
sy910.F95921.RLEFFDATE,
sy910.F95921.RLEXPIRDATE,
sy910.F00950.fssety,
sy910.F00950.FSOBNM,
trim(sy910.F00950.fsfrdv) "version",
sy910.F00950.fssy,
sy910.F00950.fsfmnm,
sy910.F00950.fsinsl,
sy910.F00950.fsrun,
sy910.F00950.FSVWYN,
sy910.F00950.FSA "Add",
sy910.F00950.FSCHNG "Change",
sy910.F00950.FSDLT "Delete",
sy910.F00950.FSIOK "OK/Select",
sy910.F00950.fsicpy "Copy",
sy910.F00950.fsiupt,
sy910.F00950.fsatn1,
sy910.F00950.fsatn2,
sy910.F00950.fsatn3,
sy910.F95921.RLUPMJ,
SY910.F95921.RLUPMT,
TO_DATE(TO_CHAR(sy910.F00950.fsupmj+1900000),'YYYYDDD')"UPMJ",
sy910.F00950.fsupmt,
sy910.F0093.llll,
sy910.F0093.llseq
FROM
sy910.F95921,
sy910.F00950,
sy910.F0093
WHERE
sy910.F00950.FSUSER = sy910.F95921.RLFRROLE
and LLUSER = RLFRROLE
/*AND sy910.F95921.RLEFFDATE <= 115240
AND
(
sy910.F95921.RLEXPIRDATE >= 115240
or SY910.F95921.RLEXPIRDATE = 0
)*/
and SY910.F0093.LLLL = 'JUSPD910'
and sy910.F95921.RLTOROLE in ( /*'BMANDA01', 'JKAMAR01','KYADAP01', 'CSINGA01','SVULUV01', 'KBHASK01', 'SKANN01'*/ 'MSEEFR01')
and SY910.F95921.RLTOROLE not like 'STRE%'
AND SY910.F95921.RLTOROLE NOT LIKE 'TEST%'
/*AND SY910.F95921.RLFRROLE NOT IN('P:USPROCHG', 'USHRSECURE')*/
/*AND SY910.F95921.RLFRROLE IN ('USBTF2SF', 'USBTF2PLN')*/
and sy910.F00950.FSOBNM like '%4116%'/* in('R04431', 'R04431A', 'P48013')*/
ORDER BY
sy910.F95921.RLFRROLE,
sy910.F00950.FSOBNM,
sy910.F00950.FSFRDV,
sy910.F95921.RLTOROLE, sy910.F00950.FSSETY;
select * from sy910.f95921 where rltorole in ( 'BMANDA01', 'JKAMAR01','KYADAP01', 'CSINGA01','SVULUV01', 'KBHASK01', 'SKANN01') order by rlfrrole, rltorole;
select * from sy910.F00950 where fsuser = 'P:DEV';