View Create View -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ mysrsvab CREATE ALGORITHM=UNDEFINED VIEW `v63`.`mysrsvab` AS select `v63`.`pfrsvab`.`RAABON` AS `RAABON`,`v63`.`pfrsvab`.`RATIPO` AS `RATIPO`,`v63`.`pfrsvab`.`RACICL` AS `RACICL`,`v63`.`pfrsvab`.`RAFUNC` AS `RAFUNC`,`v63`.`pfrsvab`.`RAZONA` AS `RAZONA`,`v63`.`pfrsvab`.`RAFILA` AS `RAFILA`,`v63`.`pfrsvab`.`RALOCA` AS `RALOCA`,`v63`.`pfrsvab`.`RADESC` AS `RADESC`,`v63`.`pfrsvab`.`RADTOV` AS `RADTOV`,`v63`.`pfrsvab`.`RAPDTO` AS `RAPDTO`,`v63`.`pfrsvab`.`RAPRUS` AS `RAPRUS`,`v63`.`pfrsvab`.`RADATR` AS `RADATR`,`v63`.`pfrsvab`.`RADATE` AS `RADATE`,`v63`.`pfrsvab`.`RADATI` AS `RADATI`,`v63`.`pfrsvab`.`RAUSER` AS `RAUSER`,`v63`.`pfrsvab`.`RADISP` AS `RADISP`,`v63`.`pfrsvab`.`RASELC` AS `RASELC`,`v63`.`pfrsvab`.`RAFLG1` AS `RAFLG1`,`v63`.`pfrsvab`.`RAFLG2` AS `RAFLG2`,`v63`.`pfrsvab`.`RAFLG3` AS `RAFLG3`,`v63`.`pfrsvab`.`RAFLG4` AS `RAFLG4`,`v63`.`pfrsvab`.`RACOTA` AS `RACOTA`,`v63`.`pfrsvab`.`RACOPR` AS `RACOPR`,`v63`.`pfrsvab`.`RARFRS` AS `RARFRS` from `v63`.`pfrsvab` where exists(select 1 AS `Not_used` from `v63`.`pfabona` where ((`v63`.`pfabona`.`ABCABO` = `v63`.`pfrsvab`.`RAABON`) and exists(select `v63`.`pflradm`.`XLREDA` AS `XLREDA` from `v63`.`pflradm` where ((`v63`.`pflradm`.`XLREDA` = `v63`.`pfabona`.`ABREDA`) and (`v63`.`pflradm`.`XLCDIS` = _latin1'MYS'))))) 1 Row(s) affected View Create View -------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mysabona CREATE ALGORITHM=UNDEFINED VIEW `v63`.`mysabona` AS select `v63`.`pfabona`.`ABREDA` AS `ABREDA`,`v63`.`pfabona`.`ABCABO` AS `ABCABO`,`v63`.`pfabona`.`ABNDNI` AS `ABNDNI`,`v63`.`pfabona`.`ABNAME` AS `ABNAME`,`v63`.`pfabona`.`ABDIRE` AS `ABDIRE`,`v63`.`pfabona`.`ABPOBL` AS `ABPOBL`,`v63`.`pfabona`.`ABPROV` AS `ABPROV`,`v63`.`pfabona`.`ABPAIS` AS `ABPAIS`,`v63`.`pfabona`.`ABPOST` AS `ABPOST`,`v63`.`pfabona`.`ABTELF` AS `ABTELF`,`v63`.`pfabona`.`ABNFAX` AS `ABNFAX`,`v63`.`pfabona`.`ABPROF` AS `ABPROF`,`v63`.`pfabona`.`ABSEXO` AS `ABSEXO`,`v63`.`pfabona`.`ABOBS1` AS `ABOBS1`,`v63`.`pfabona`.`ABOBS2` AS `ABOBS2`,`v63`.`pfabona`.`ABFECA` AS `ABFECA`,`v63`.`pfabona`.`ABNREF` AS `ABNREF`,`v63`.`pfabona`.`ABUSRU` AS `ABUSRU`,`v63`.`pfabona`.`ABDATU` AS `ABDATU`,`v63`.`pfabona`.`ABBOFN` AS `ABBOFN`,`v63`.`pfabona`.`ABFOJU` AS `ABFOJU`,`v63`.`pfabona`.`ABFLG1` AS `ABFLG1`,`v63`.`pfabona`.`ABFLG2` AS `ABFLG2`,`v63`.`pfabona`.`ABFLG3` AS `ABFLG3`,`v63`.`pfabona`.`ABFLG4` AS `ABFLG4`,`v63`.`pfabona`.`ABREDT` AS `ABREDT`,`v63`.`pfabona`.`ABTIAB` AS `ABTIAB`,`v63`.`pfabona`.`ABMAIL` AS `ABMAIL`,`v63`.`pfabona`.`ABNACI` AS `ABNACI`,`v63`.`pfabona`.`ABCUOT` AS `ABCUOT`,`v63`.`pfabona`.`ABCRED` AS `ABCRED`,`v63`.`pfabona`.`ABMORO` AS `ABMORO`,`v63`.`pfabona`.`ABPASS` AS `ABPASS`,`v63`.`pfabona`.`ABVINC` AS `ABVINC`,`v63`.`pfabona`.`ABTIPVI` AS `ABTIPVI` from `v63`.`pfabona` where exists(select `v63`.`pflradm`.`XLREDA` AS `XLREDA` from `v63`.`pflradm` where ((`v63`.`pflradm`.`XLREDA` = `v63`.`pfabona`.`ABREDA`) and (`v63`.`pflradm`.`XLCDIS` = _latin1'MYS'))) 1 Row(s) affected