Paul Trowbridge
6a3ac0e436
Full-reload modules for the CMS/DB2 tables migrated off /opt/sync, landing in cms.*. Columns introspected fresh from DB2 (QSYS2.SYSCOLUMNS). Three large tables use incremental merge ported from the legacy sync instead of full reload: iprcctn/iprccto (date watermark on t8date/t7date), ffpdglr1 (fiscal- period watermark via rprh join, keyed on btid). Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
47 lines
1.1 KiB
SQL
47 lines
1.1 KiB
SQL
SELECT
|
|
RTRIM(AOTYPE) AS aotype,
|
|
RTRIM(AOPART) AS aopart,
|
|
"AOSEQ#" AS "aoseq#",
|
|
"AOLIN#" AS "aolin#",
|
|
RTRIM(AODEPT) AS aodept,
|
|
RTRIM(AORESC) AS aoresc,
|
|
RTRIM(AOOPNM) AS aoopnm,
|
|
AOSETP AS aosetp,
|
|
AORUNS AS aoruns,
|
|
RTRIM(AORTYP) AS aortyp,
|
|
AOSCRW AS aoscrw,
|
|
RTRIM(AOREPP) AS aorepp,
|
|
AOLAGT AS aolagt,
|
|
AOTBTH AS aotbth,
|
|
RTRIM(AOUNIT) AS aounit,
|
|
RTRIM("AOPRC#") AS "aoprc#",
|
|
AOEFF AS aoeff,
|
|
RTRIM(AOBK03) AS aobk03,
|
|
"AO#MEN" AS "ao#men",
|
|
"AO#MCH" AS "ao#mch",
|
|
AOEFC1 AS aoefc1,
|
|
AOEFC2 AS aoefc2,
|
|
RTRIM(AOBK04) AS aobk04,
|
|
AOCTME AS aoctme,
|
|
AOMULT AS aomult,
|
|
AOCNOR AS aocnor,
|
|
AOBCDR AS aobcdr,
|
|
RTRIM(AOFUT1) AS aofut1,
|
|
RTRIM(AOFUT2) AS aofut2,
|
|
RTRIM(AOFUT3) AS aofut3,
|
|
RTRIM(AOFUT4) AS aofut4,
|
|
RTRIM(AOFUT5) AS aofut5,
|
|
RTRIM(AOFUT6) AS aofut6,
|
|
RTRIM(AOFUT7) AS aofut7,
|
|
RTRIM(AOFUT8) AS aofut8,
|
|
RTRIM(AOFUT9) AS aofut9,
|
|
RTRIM(AOFUTA) AS aofuta,
|
|
RTRIM(AOFUTB) AS aofutb,
|
|
AOFUTC AS aofutc,
|
|
AOFUTD AS aofutd,
|
|
AOFUTE AS aofute,
|
|
AOFUTF AS aofutf,
|
|
RTRIM(AOPLNT) AS aoplnt,
|
|
AOSMCH AS aosmch
|
|
FROM LGDAT.METHDR
|