Professional Web Applications Themes

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

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 .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?...

  1. #1

    Default 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 .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?
    xixi Guest

  2. #2

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

    Error message is pretty clear to me

    SQL0243N SENSITIVE cursor "<cursor-name>" cannot be defined for
    the specified SELECT statement.

    Explanation:

    Cursor "<cursor-name>" 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" <dai_xi> a écrit dans le message de news:
    [email]c0f33a17.0308110920.55ba062aposting.google.com[/email]...
    > 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 .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?

    PM \(pm3iinc-nospam\) Guest

Similar Threads

  1. #25206 [Csd->Bgs]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: August 23rd, 12:33 AM
  2. #25206 [Fbk->Csd]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
    By jkshin at naver dot com in forum PHP Development
    Replies: 0
    Last Post: August 22nd, 11:29 PM
  3. #25206 [Opn->Fbk]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: August 22nd, 01:38 PM
  4. #25206 [NEW]: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-461
    By jkshin at naver dot com in forum PHP Development
    Replies: 0
    Last Post: August 22nd, 09:20 AM
  5. text extender error (sqlstate 38X13)
    By Roberto in forum IBM DB2
    Replies: 0
    Last Post: August 4th, 12:56 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139