75 lines
1.9 KiB
SQL
75 lines
1.9 KiB
SQL
SELECT
|
|
RTRIM(IFA2) AS ifa2,
|
|
RTRIM(IFLCDT) AS iflcdt,
|
|
RTRIM(IFA6) AS ifa6,
|
|
IFMINC AS ifminc,
|
|
RTRIM(IFA5) AS ifa5,
|
|
IFLCHQ AS iflchq,
|
|
IFCLCR AS ifclcr,
|
|
IFCHCR AS ifchcr,
|
|
IFMLCR AS ifmlcr,
|
|
IFMHCR AS ifmhcr,
|
|
RTRIM(IFA10) AS ifa10,
|
|
IFGSGL AS ifgsgl,
|
|
RTRIM(IFCURR) AS ifcurr,
|
|
RTRIM(IFAA1) AS ifaa1,
|
|
IFAPGL AS ifapgl,
|
|
IFBKGL AS ifbkgl,
|
|
IFDSGL AS ifdsgl,
|
|
IFCOGL AS ifcogl,
|
|
RTRIM(IFAA4) AS ifaa4,
|
|
RTRIM(IFLRDT) AS iflrdt,
|
|
RTRIM(IFA7) AS ifa7,
|
|
RTRIM(IFBKNM) AS ifbknm,
|
|
IFCCGL AS ifccgl,
|
|
IFCGGL AS ifcggl,
|
|
IFFRGL AS iffrgl,
|
|
IFDTGL AS ifdtgl,
|
|
RTRIM(IFA45) AS ifa45,
|
|
RTRIM(IFCNAM) AS ifcnam,
|
|
"IFCOM#" AS "ifcom#",
|
|
RTRIM("IFBNK#") AS "ifbnk#",
|
|
CASE WHEN IFCDAT IN (DATE('0001-01-01'), DATE('9999-12-31')) THEN NULL ELSE IFCDAT END AS ifcdat,
|
|
RTRIM(IFBNKA) AS ifbnka,
|
|
RTRIM(IFFIID) AS iffiid,
|
|
RTRIM(IFFINM) AS iffinm,
|
|
IFHQGL AS ifhqgl,
|
|
RTRIM("IFBREF#") AS "ifbref#",
|
|
RTRIM("IFTRN#") AS "iftrn#",
|
|
RTRIM(IFEBNK) AS ifebnk,
|
|
RTRIM(IFPAYT) AS ifpayt,
|
|
RTRIM(IFFUT3) AS iffut3,
|
|
RTRIM(IFFUT4) AS iffut4,
|
|
IFFUT5 AS iffut5,
|
|
IFFUT6 AS iffut6,
|
|
IFFUT7 AS iffut7,
|
|
RTRIM(IFFLG1) AS ifflg1,
|
|
RTRIM(IFFLG2) AS ifflg2,
|
|
RTRIM(IFFLG3) AS ifflg3,
|
|
RTRIM(IFFLG4) AS ifflg4,
|
|
CASE WHEN IFEXDT IN (DATE('0001-01-01'), DATE('9999-12-31')) THEN NULL ELSE IFEXDT END AS ifexdt,
|
|
RTRIM(IFFUT1) AS iffut1,
|
|
RTRIM(IFFUT2) AS iffut2,
|
|
RTRIM(IFFUT8) AS iffut8,
|
|
IFISGL AS ifisgl,
|
|
IFICGL AS ificgl,
|
|
IFFAC1 AS iffac1,
|
|
IFFAC2 AS iffac2,
|
|
IFFAC3 AS iffac3,
|
|
IFFAC4 AS iffac4,
|
|
IFFAC5 AS iffac5,
|
|
IFPVGL AS ifpvgl,
|
|
RTRIM(IFFUT9) AS iffut9,
|
|
RTRIM(IFFUT10) AS iffut10,
|
|
RTRIM(IFFUT11) AS iffut11,
|
|
RTRIM(IFFUT12) AS iffut12,
|
|
RTRIM(IFFUT13) AS iffut13,
|
|
RTRIM(IFFUT14) AS iffut14,
|
|
RTRIM(IFFUT15) AS iffut15,
|
|
RTRIM(IFFUT16) AS iffut16,
|
|
RTRIM(IFFUT17) AS iffut17,
|
|
IFFUT18 AS iffut18,
|
|
IFFUT19 AS iffut19,
|
|
IFFUT20 AS iffut20
|
|
FROM LGDAT.CONT
|