Hi Rony,

found a sample fort he box function and test it, but got the same error

 

††† 47 *-* stmt3 = con~prepareStatement("INSERT INTO test VALUES(:name, :place)"

)

†††††† >V>†† CON => "com.ibm.db2.jcc.uw.UWConnection@59824bc"

†††††† >L>†† "INSERT INTO test VALUES(:name, :place)"

†††††† >A>†† "INSERT INTO test VALUES(:name, :place)"

†††††† >M>†† "PREPARESTATEMENT" => "com.ibm.db2.jcc.am.jo@2dcb4eaa"

†††††† >>>†† "com.ibm.db2.jcc.am.jo@2dcb4eaa"

†††††† >=>†† STMT3 <= "com.ibm.db2.jcc.am.jo@2dcb4eaa"

††† 48 *-* name = 'Roger Bilau'

†††††† >L>†† "Roger Bilau"

†††††† >>>†† "Roger Bilau"

†††††† >=>†† NAME <= "Roger Bilau"

††† 49 *-* place = 'Bonn'

†††††† >L>†† "Bonn"

††††† †>>>†† "Bonn"

†††††† >=>†† PLACE <= "Bonn"

††† 50 *-* name = box('string', name)

†††††† >L>†† "string"

†††††† >A>†† "string"

†††††† >V>†† NAME => "Roger Bilau"

†††††† >A>†† "Roger Bilau"

†††††† >F>†† BOX => "java.lang.String@7e999262"

†††††† >>>†† "java.lang.String@7e999262"

†††††† >=>†† NAME <= "java.lang.String@7e999262"

††† 51 *-* place = box('string', place)

†††††† >L>†† "string"

†††††† >A>†† "string"

†††††† >V>†† PLACE => "Bonn"

†††††† >A>†† "Bonn"

†††††† >F>†† BOX => "java.lang.String@1459a0dd"

††††† †>>>†† "java.lang.String@1459a0dd"

†††††† >=>†† PLACE <= "java.lang.String@1459a0dd"

††† 52 *-* stmt3~setJccStringAtName("name", name)

†††††† >V>†† STMT3 => "com.ibm.db2.jcc.am.jo@2dcb4eaa"

†††††† >L>†† "name"

†††††† >A>†† "name"

†††††† >V>†† NAME => "java.lang.String@7e999262"

†††††† >A>†† "java.lang.String@7e999262"

††† 93 *-* syntax:

††† 94 *-* trace o

jexc~toString: org.apache.bsf.BSFException: /// Java-exception (RexxAndJava) occ

urred: [java.lang.reflect.InvocationTargetException], getCause(): [com.ibm.db2.j

cc.am.SqlSyntaxErrorException: [jcc][10448][12695][3.64.106] Ung≥ltiges Argument

: Parametermarke 'name' war in der SQL-Zeichenfolge nicht vorhanden. ERRORCODE=-

4461, SQLSTATE=42815] \\\

BSF4ooRexx subfunction "invoke": object 'com.ibm.db2.jcc.am.jo@2dcb4eaa' - metho

d [SETJCCSTRINGATNAME], method not found or error (exception) executing method!

jobj~toString: java.lang.reflect.InvocationTargetException

 

regards

Roger