on 11-13-2007 2:49 PM
Hi everybody.
I have a scenario with JDBC Adapter, and my database is db2.
I need an example of sql sentences for db2 on jdbc adapter, because my sentences i get error.
Regards
Cristian
Hi
Did I resolve this problem....tks
Cristian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello friends.
My problem is in the sentence UPDATE in the Communication Channel, i get an error in the execution.
"Database-level error reported by JDBC driver while executing statement 'UPDATE CLIARC SET CLICL3 = 0 WHERE clicl1 = 10"
The sentence is follow:
UPDATE CLIARC SET CLICL3 = 0 WHERE clicl1 = 10
Please help me ..many thanks
Crisian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Place you statements here.. then some would be able to help you..
VJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Refer these links:
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm
sender JDBC adapter.: http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm
receiver JDBC adapter.: http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm
Document Formats for the Receiver JDBC Adapter.: http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm
Do let us know what you are trying to do. I mean JDBC to * or * to JDBC scenario:)
Thanks
Farooq.
*Rewards Points if you find it useful*
This is error ...
Database-level error reported by JDBC driver while executing statement 'UPDATE
CLIARC SET CLICL3 = 0 WHERE clicl1 = 10
'. The JDBC driver returned the following error message: 'java.sql.SQLException: CLIARC en PROXL07 de tipo *FILE no encontrado. Causa . . . . . : CLIARC en PROXL07 tipo *FILE no se ha encontrado. Si se trata de una sentencia ALTER TABLE y el tipo es *N, no se ha encontrado una restricción o partición. Si no se trata de una sentencia ALTER TABLE y el tipo es *N, no se ha encontrado una función, procedimiento o desencadenante. Si no se ha encontrado una función, CLIARC es el programa de servicio que contiene la función. La función no se encontrará si el nombre externo y el nombre de uso no coinciden exactamente. Examine en las anotaciones de trabajo para ver si encuentra un mensaje que dé más detalles sobre el nombre de función que se está buscando y el nombre que no coincide. Recuperación . : Cambie el nombre y vuelva a intentar la petición. Si el objeto es un grupo de nodos, asegúrese de que el producto DB2 Multisystem está instalado en el sistema y cree un grupo de nodos con el mandato CL CRTNODGRP. Si no se ha encontrado la función externa, asegúrese de que las mayúsculas y minúsculas del EXTERNAL NAME en la sentencia CREATE FUNCTION coinciden exactamente con las mayúsculas y minúsculas del nombre exportado por el programa de servicio.'. For details, contact your database server vendor.The sentences in using are following:
Query Sql Statement: select clicl2 from proxl.cliarc where clicl1 = 10
Update Sql Statement: UPDATE CLIARC SET CLICL3 = 0 WHERE clicl1 = 10
Tks for your help anybody
Hello friend.
My problem is in the sentence UPDATE in the Communication Channel, i get an error in the execution.
"Database-level error reported by JDBC driver while executing statement 'UPDATE CLIARC SET CLICL3 = 0 WHERE clicl1 = 10"
The sentence is follow:
UPDATE CLIARC SET CLICL3 = 0 WHERE clicl1 = 10
Please help me ..many thanks
Cristian
Hi Raj.
No, I executed the same query on DBVisualizer, and it got executed successully. I don't have access on DB2 directly.
The SELECT sentence was execute successfully on SAP-XI and DBVisualizer, but the UPDATE sentence was execute successfully on DBVisualizer only.
Many thanks for your help, I hope an early solution for this problem.
Cristian
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.