+ Reply to Thread
Results 1 to 4 of 4

DB2 SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17

  1. DB2 SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17

    hello, i am using db2jcc.jar from db2 udb v8.1 fix pack 2. (type 4
    driver) i have this query select id, pono19, pono05, poqy38, pocd13
    from xxxxxx.view ORDER BY pono19 ASC, pono05 ASC and get the error DB2
    SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17,

    statement =
    conn.createStatement(
    ResultSet.TYPE_SCROLL_SENSITIVE,
    ResultSet.CONCUR_READ_ONLY);
    statement.executeQuery(sqlStr)

    i don't know why this error happened since i use this type of
    statement to execute query in the program everywhere. please help. so
    what is the right way to create a statement?

  2. Re: DB2 SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17

    Error message is pretty clear to me

    SQL0243N SENSITIVE cursor "" cannot be defined for
    the specified SELECT statement.

    Explanation:

    Cursor "" is defined as SENSITIVE, but the content
    of the SELECT statement requires DB2 to build a temporary result
    table of the cursor, and DB2 cannot guarantee that changes made
    outside this cursor will be visible. This situation occurs when
    the content of the query makes the result table read-only. For
    example, if the query includes a join, the result table is
    read-only. In this case, the cursor must be defined as
    INSENSITIVE or ASENSITIVE.

    The statement cannot be processed.

    User Response:

    Either change the content of the query to yield a result table
    that is not read-only, or change the type of the cursor to
    INSENSITIVE or ASENSITIVE.

    sqlcode : -243

    sqlstate : 36001

    PM


    "xixi" a écrit dans le message de news:
    c0f33a17.0308110920.55ba062a@posting.google.com...
    > hello, i am using db2jcc.jar from db2 udb v8.1 fix pack 2. (type 4
    > driver) i have this query select id, pono19, pono05, poqy38, pocd13
    > from xxxxxx.view ORDER BY pono19 ASC, pono05 ASC and get the error DB2
    > SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17,
    >
    > statement =
    > conn.createStatement(
    > ResultSet.TYPE_SCROLL_SENSITIVE,
    > ResultSet.CONCUR_READ_ONLY);
    > statement.executeQuery(sqlStr)
    >
    > i don't know why this error happened since i use this type of
    > statement to execute query in the program everywhere. please help. so
    > what is the right way to create a statement?




  3. Re: DB2 SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17

    Error message is pretty clear to me

    SQL0243N SENSITIVE cursor "" cannot be defined for
    the specified SELECT statement.

    Explanation:

    Cursor "" is defined as SENSITIVE, but the content
    of the SELECT statement requires DB2 to build a temporary result
    table of the cursor, and DB2 cannot guarantee that changes made
    outside this cursor will be visible. This situation occurs when
    the content of the query makes the result table read-only. For
    example, if the query includes a join, the result table is
    read-only. In this case, the cursor must be defined as
    INSENSITIVE or ASENSITIVE.

    The statement cannot be processed.

    User Response:

    Either change the content of the query to yield a result table
    that is not read-only, or change the type of the cursor to
    INSENSITIVE or ASENSITIVE.

    sqlcode : -243

    sqlstate : 36001

    PM


    "xixi" a écrit dans le message de news:
    c0f33a17.0308110920.55ba062a@posting.google.com...
    > hello, i am using db2jcc.jar from db2 udb v8.1 fix pack 2. (type 4
    > driver) i have this query select id, pono19, pono05, poqy38, pocd13
    > from xxxxxx.view ORDER BY pono19 ASC, pono05 ASC and get the error DB2
    > SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17,
    >
    > statement =
    > conn.createStatement(
    > ResultSet.TYPE_SCROLL_SENSITIVE,
    > ResultSet.CONCUR_READ_ONLY);
    > statement.executeQuery(sqlStr)
    >
    > i don't know why this error happened since i use this type of
    > statement to execute query in the program everywhere. please help. so
    > what is the right way to create a statement?




  4. Re: DB2 SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17

    Error message is pretty clear to me

    SQL0243N SENSITIVE cursor "" cannot be defined for
    the specified SELECT statement.

    Explanation:

    Cursor "" is defined as SENSITIVE, but the content
    of the SELECT statement requires DB2 to build a temporary result
    table of the cursor, and DB2 cannot guarantee that changes made
    outside this cursor will be visible. This situation occurs when
    the content of the query makes the result table read-only. For
    example, if the query includes a join, the result table is
    read-only. In this case, the cursor must be defined as
    INSENSITIVE or ASENSITIVE.

    The statement cannot be processed.

    User Response:

    Either change the content of the query to yield a result table
    that is not read-only, or change the type of the cursor to
    INSENSITIVE or ASENSITIVE.

    sqlcode : -243

    sqlstate : 36001

    PM


    "xixi" a écrit dans le message de news:
    c0f33a17.0308110920.55ba062a@posting.google.com...
    > hello, i am using db2jcc.jar from db2 udb v8.1 fix pack 2. (type 4
    > driver) i have this query select id, pono19, pono05, poqy38, pocd13
    > from xxxxxx.view ORDER BY pono19 ASC, pono05 ASC and get the error DB2
    > SQL error: SQLCODE: -243, SQLSTATE: 36001, SQLERRMC: SQL_CURSH200C17,
    >
    > statement =
    > conn.createStatement(
    > ResultSet.TYPE_SCROLL_SENSITIVE,
    > ResultSet.CONCUR_READ_ONLY);
    > statement.executeQuery(sqlStr)
    >
    > i don't know why this error happened since i use this type of
    > statement to execute query in the program everywhere. please help. so
    > what is the right way to create a statement?




+ Reply to Thread