Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    72

    Unanswered: Trigger Error SQLCODE=-696, I'm not quite sure what/how to correct this error.

    Hello all,

    I am trying to code an after delete DB2 z/OS TRIGGER but I am getting this following error:

    DSNT408I SQLCODE = -696, ERROR: THE DEFINITION OF TRIGGER T030G62 INCLUDES AN
    INVALID USE OF CORRELATION NAME OR TRANSITION TABLE NAME NEW. REASON CODE=1
    DSNT418I SQLSTATE = 42898 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNXICTR SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD = 170 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
    DSNT416I SQLERRD = X'000000AA' X'00000000' X'00000000' X'FFFFFFFF'
    X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
    ---------+---------+---------+---------+---------+---------+---------+---------+
    DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
    ---------+---------+---------+---------+---------+---------+---------+---------+
    DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72
    DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 3 DSNE621I NUMBER OF INPUT RECORDS READ IS 49
    D

    I am not very familiar with TRIGGERS and not quite sure what or how to correct the definition. Can I get some assistance in this regard?

    All response will be highly appreciated.

    Thanks everyone

    okonita

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    There's no NEW transition variable after you delete stuff, obviously.
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •