#BRJAVA
Datei $TEXTE\$AKZ_NORM.xml
SQL
Select *
from sba_vgkontroll
where sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
select *
From bwverw
Where ma_nr in (Select sba_vg_manr
from sba_vgkontroll
where sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ')))
Report
XML
SQL
SELECT *
from sba_zverst
where akz = '$AKZ'
or akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from sba_bg_gesamt
where akz = '$AKZ'
or akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from sba_bg_verstoss
where akz = '$AKZ'
or akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from sba_schaub
where sb_nr in(
SELECT sb_nr from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from sba_messw
where sb_nr in(
SELECT sb_nr from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from sba_fverst
where sb_nr in(
SELECT sb_nr from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT * from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ')
Report
XML
SQL
SELECT *
from sba_fz
where kennz in (
SELECT sba_vg_kennz from sba_vgkontroll where
(sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))))
or kennz in (
SELECT sb_kennz
from sba_schaub
where sb_nr in(
SELECT sb_nr from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ')))
Report
XML
SQL
SELECT *
from sba_gruende
where akz = '$AKZ'
or akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from sba_dok
where akz = '$AKZ'
or akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from sba_pruefung
where sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))
Report
XML
SQL
SELECT *
from bt
where bt_nr in (
SELECT sba_vg_btnr from sba_vgkontroll where
sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ')))
or bt_nr in (
SELECT sb_fahrer from sba_schaub where
sb_nr in (
SELECT sb_nr from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ')))
Report
XML
SQL
SELECT *
from bt_art
where bt_nr in (
SELECT sba_vg_btnr from sba_vgkontroll where
sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ')))
or bt_nr in (
SELECT sb_fahrer from sba_schaub where
sb_nr in (
SELECT sb_nr from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ')))
Report
XML
SQL
SELECT *
from bs
where bs_nr in (
SELECT sba_bs_nr from sba_vgkontroll where
(sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))))
Report
XML
SQL
SELECT *
from sba_bs
where bs_nr in (
SELECT sba_bs_nr from sba_vgkontroll where
(sba_vg_akz = '$AKZ'
or sba_vg_akz in (
SELECT akz from sba_zug where
(akz = '$AKZ' or akz_zugeordnet = '$AKZ'))))
Report
XML
SQL
Select *
from sba_pflege
Report
NoHeader
XML
SQL
Select *
from agkatde
where subid in (
select subid from katidx
where gruppe = 'Sozialvorschriften')
Report
NoHeader
XML
SQL
Select *
from cnf
Report
XML
SQL
Msg Der Vorgang $AKZ wurde in die Datei $TEXTE\$AKZ_NORM.xml entladen
Execute NULL
|
