Does anyone know the following error message when running a CL program.
Message ID . . . . . . : SQL7008
Date sent . . . . . . : 15/10/02 Time sent . . . . . . : 10:19:16
Message . . . : ZPAL01 in DSLIF not valid for operation.
Cause . . . . . : The reason code is 3:
Code 3 -- ZPAL01 is not journaled, or you do not have authority to the journal. Files with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be journaled to the same journal.
My CL uses the following SQL Statement anmd I can't see why it needs to have the file ZPA journalled:
C+ UPDATE DSLIF/ZPA SET IDPA = 'NO'
C+ WHERE PKEY = 'AUTOALBA'