Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    20

    Unanswered: An sql error "-7" occurred

    when I run my db2 command I get the error:
    An sql error "-7" occurred while processing the select string action string paramater.
    What does it mean?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    SQL0007N The character "<character>" following "<text>" is
    not valid.

    Explanation:

    The specified "<character>" is not a valid character in SQL
    statements. The "<text>" field indicates the 20 characters of
    the SQL statement that preceded the character that is not
    valid.

    Federated system users: some data sources do not provide the
    appropriate values for the "<character>" and "<text>" message
    tokens. In these cases, "<character>" and "<text>" will have the
    following format: "<data source>:UNKNOWN", indicating that the
    actual values for the specified data source are unknown.

    The statement cannot be processed.

    User Response:

    Remove or replace the character that is not valid.

    sqlcode : -7

    sqlstate : 42601
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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