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 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| INSERT INTO proddta.F4941 (RSSHPN,
RSRSSN,
RSMOT, RSOVRM,
RSCARS, RSOVRC,
RSROUT, RSRTN,
RSDLNO, RSFRSC,
RSZON, RSVMCU,
RSLDNM, RSTRPL,
RSSTSQ, RSANID,
RSORGN, RSANCC,
RSWGTS, RSWTUM,
RSSCVL, RSVLUM,
RSLGTS, RSWTHS,
RSHGTS, RSGTHS,
RSLUOM, RSNPCS,
RSNCTR, RSCCUB,
RSDSTN, RSUMD1,
RSDSRC, RSELTM,
RSUM, RSAEXP,
RSFEA, RSCRCD,
RSECST, RSPPDJ,
RSPMDT, RSRSDJ,
RSRSDT, RSLDDT,
RSLDTM, RSADDJ,
RSADTM, RSDLDT,
RSDLTM, RSRRTR,
RSRATR, RSDPCR,
RSREFQ, RSREFN,
RSFRTD, RSFRTV,
RSFRVC, RSFRVF,
RSCRCP, RSFRCC,
RSFRCF, RSCRDC,
RSINTF, RSIBRS,
RSLSLT, RSLSUT,
RSLALT, RSLAUT,
RSTPUF, RSTPUT,
RSTDLF, RSTDLT,
RSDEPU, RSDLPU,
RSDEDL, RSDLDL,
RSDKID, RSPRNB,
RSPRTE, RSLNMB,
RSCNMR, RSURCD,
RSURDT, RSURAT,
RSURAB, RSURRF,
RSUSER, RSPID,
RSJOBN, RSUPMJ, RSTDAY)
SELECT (IQSHPN, IQRSSN, TMMOT, '', TMCARS, '', '',
IQRTN, IQDLNO, 'SONA', '', IQVMCU, TMLDNM, 1, 1, 0,
IQORGN, IQANCC, IQWTCA, TMWTUM, IQNPCS,
TMVLUM, 0, 0, 0, 0, 'MT', IQNPCS, 0, 0,
0, 'KM', TMDSRC, 0, '', IQAEXP, 0, 'XOF',
IQECST, TMPPDJ, 0, TMPPDJ, 0, TMADDJ, TMADTM,
TMADDJ, TMADTM, '', 0, 0, 1, 1, '', '', '', '',
TMFRVC, 0, 'XOF', 0, 0, 'XOF', 1, '', 0, 0, 0, 0,
0, 0, 0, 0, '', '', '', '', '', 0, '', 0, '', '', '', 0, 0, '',
TMUSER, TMPID, TMJOBN, TMUPMJ, TMTDAY)
from proddta.F4960 join proddta.F49633
on TMLDNM=IQLDNM
WHERE TMLDNM IN (60000105, 62000032, 60000306, 60000307) |
Partager