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>
32 lines
731 B
SQL
32 lines
731 B
SQL
SELECT
|
|
RTRIM(APTYPE) AS aptype,
|
|
RTRIM(APPART) AS appart,
|
|
"APSEQ#" AS "apseq#",
|
|
"APLIN#" AS "aplin#",
|
|
RTRIM(APVEND) AS apvend,
|
|
RTRIM(APODES) AS apodes,
|
|
APBQTY AS apbqty,
|
|
APTIME AS aptime,
|
|
APCOST AS apcost,
|
|
APFCSI AS apfcsi,
|
|
APFCSO AS apfcso,
|
|
APUNCS AS apuncs,
|
|
RTRIM(APDEPT) AS apdept,
|
|
RTRIM(APRESC) AS apresc,
|
|
RTRIM(APFUT1) AS apfut1,
|
|
RTRIM(APFUT2) AS apfut2,
|
|
RTRIM(APFUT3) AS apfut3,
|
|
RTRIM(APFUT4) AS apfut4,
|
|
RTRIM(APFUT5) AS apfut5,
|
|
RTRIM(APFUT6) AS apfut6,
|
|
RTRIM(APFUT7) AS apfut7,
|
|
RTRIM(APFUT8) AS apfut8,
|
|
RTRIM(APFUT9) AS apfut9,
|
|
RTRIM(APFUTA) AS apfuta,
|
|
APFUTB AS apfutb,
|
|
APFUTC AS apfutc,
|
|
APFUTD AS apfutd,
|
|
APFUTE AS apfute,
|
|
RTRIM(APPLNT) AS applnt
|
|
FROM LGDAT.METHDO
|