Results 1 to 2 of 2

Thread: db2look problem

  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Question Unanswered: db2look problem

    hi,

    I encounter problem in using db2look utility on db2 codepage 950 at AIX environment.

    Command issue: db2look -d vbs -z wb1

    Error Output:
    % No userid was specified, db2look tries to use Environment variable USER
    % USER is: DB2
    % Specified SCHEMA is: WB1
    % Use LaTeX format
    SQL0863W A successful connection was made, but only single byte characters
    should be used. SQLSTATE=01539

    How can i soleve this problem?

    Many thanks,
    Fool

  2. #2
    Join Date
    Mar 2003
    Posts
    33

    Re: db2look problem

    Maybe you have notice this...:

    SQL0863W A successful connection was made, but only single byte
    characters should be used.

    Explanation: The server database and client application are
    using codepages for different language types and any characters
    outside the 7-bit ASCII range cannot be guaranteed (only the
    characters in the 7-bit ASCII range exist in all codepages). For
    example, the connection might be between a Japanese and a Latin-1
    codepage, but none of the Japanese characters will be available
    in the Latin-1 codepage, so all of these characters should be
    avoided (English characters are fine though).

    Federated system users: possible causes are:

    o The federated database supports single-byte and double-byte
    characters but the database client system supports only
    single-byte characters.

    o The data source supports single-byte and double-byte
    characters but the federated system supports only single-byte
    characters.



    User Response: Do not submit SQL statements or commands that use
    characters which are not common between the application and
    database codepages.

    Federated system users: do not submit SQL statements or commands
    that use characters which are not common between the client
    system, the federated system, and the data source.

    sqlcode: +863

    sqlstate: 01539
    -r-

Posting Permissions

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