INSERT from existing records of the same table

[michael Tepperis]

the following SQL is not acceepted by DB2 V7:

INSERT
INTO BLT15
VALUES
SELECT
A.TNR
, A.LNR
, A.LINDEX
, 'P'
, 'E'
, 'S'
, CURRENT DATE
, CURRENT TIME
FROM
BLT15 A
WHERE
A.BA_TAB = 'S'
AND NOT EXISTS
( SELECT 1 FROM BLT15 B
WHERE
A.TNR = B.TNR
AND A.LNR = B.LNR
AND A.LINDEX = B.LINDEX
AND B.BA_TAB = 'P' )
;

any ideas how to realize with SPUFI/QMF?

greetings michael

[Mark A]

"michael Tepperis" <ex******************************@volkswagen.de> wrote in
message news:bp*********@doiweb4.volkswagen.de...

the following SQL is not acceepted by DB2 V7:

INSERT
INTO BLT15
VALUES
SELECT
A.TNR
, A.LNR
, A.LINDEX
, 'P'
, 'E'
, 'S'
, CURRENT DATE
, CURRENT TIME
FROM
BLT15 A
WHERE
A.BA_TAB = 'S'
AND NOT EXISTS
( SELECT 1 FROM BLT15 B
WHERE
A.TNR = B.TNR
AND A.LNR = B.LNR
AND A.LINDEX = B.LINDEX
AND B.BA_TAB = 'P' )
;

any ideas how to realize with SPUFI/QMF?

greetings michael

Get rid of the VALUES clause. Values clause is not used when a full-select
is present for the data.