SQL View mit Cobol bearbeiten

[KingofKning]

So:
CREATE VIEW DAT008 AS SELECT SOID1, SOID2, SODNBI, SODNVO, SOID4, SO
EIPR, SOSA16, SOEIP2 FROM SON01PF WHERE SOFA = 1 AND SOSTS = 0
AND SOABKZ = 0 AND SOJHVO = 1 AND SOEIPR > 0 AND (SODNBI >= YEAR(CU
RRENT DATE)*10000 + MONTH(CURRENT DATE)*100 + DAY(CURRENT DATE)) GRO
UP BY SOID1, SOID2, SODNBI, SODNVO, SOID4, SOEIPR, SOSA16, SOEIP2 RC
DFMT DAT008SATZ

Für ne DDS Datei zu kompliziert