Basic CL program

This is a discussion on Basic CL program within the C# Programming forums, part of the General Programming Boards category; Does anyone know the following error message when running a CL program. Message ID . . . . . . ...

  1. #1
    Registered User
    Join Date
    Oct 2002
    Posts
    1

    Question Basic CL program

    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/EXEC SQL
    C+ UPDATE DSLIF/ZPA SET IDPA = 'NO'
    C+ WHERE PKEY = 'AUTOALBA'
    C/END-EXEC


    Thanks,
    Derryn.

  2. #2
    the hat of redundancy hat nvoigt's Avatar
    Join Date
    Aug 2001
    Location
    Hannover, Germany
    Posts
    3,139
    What exactly is CL ? It doesn't seem to be Common Language or C#...
    hth
    -nv

    She was so Blonde, she spent 20 minutes looking at the orange juice can because it said "Concentrate."

    When in doubt, read the FAQ.
    Then ask a smart question.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Using variables in system()
    By Afro in forum C Programming
    Replies: 8
    Last Post: 07-03-2007, 01:27 PM
  2. Basic encryption program???
    By Finchie_88 in forum C++ Programming
    Replies: 14
    Last Post: 09-10-2004, 10:01 AM
  3. basic animation program
    By Noobie in forum C++ Programming
    Replies: 16
    Last Post: 02-17-2003, 06:33 PM
  4. IDEA: A basic drawing program
    By ygfperson in forum Contests Board
    Replies: 0
    Last Post: 08-13-2002, 12:15 AM
  5. Replies: 2
    Last Post: 05-10-2002, 05:16 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21