1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
CdeLIV:
LOAD
OADIVI as %KEY_Societe,
OAORNO as Commande,
OAWHLO as Agence,
OAMODL,
OAORST,
OAORSL,
OARLDZ
;
SQL SELECT
OADIVI,
OAORNO,
OAWHLO,
OAMODL,
OAORST,
OAORSL,
OARLDZ
FROM PRDM3.M3FDBPRD.OOHEAD
where OACONO = 100 and OAMODL = 'LIV' and OAORST < 77 and OAORST > 05
;
Art100000:
LOAD
OBDIVI as %KEY_Societe,
OBORNO as Commande,
OBWHLO as Agence,
OAMODL,
OAORST,
OAORSL,
OARLDZ
;
SQL SELECT
OBDIVI,
OBORNO,
OBWHLO,
OAMODL,
OAORST,
OAORSL,
OARLDZ
FROM PRDM3.M3FDBPRD.OOLINE, PRDM3.M3FDBPRD.OOHEAD
where OACONO=OBCONO and OADIVI=OBDIVI and OAORNO=OBORNO
and OBCONO = 100 and OBITNO = '100000' and OAMODL = 'LIV' and OAORST < 77 and OAORST > 05
; |
Partager