cancel
Showing results for 
Search instead for 
Did you mean: 

Sql senteces for DB2 database

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Did I resolve this problem....tks

Cristian

Former Member
0 Kudos

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

VijayKonam
Active Contributor
0 Kudos

Place you statements here.. then some would be able to help you..

VJ

Former Member
0 Kudos

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*

Former Member
0 Kudos

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

Former Member
0 Kudos

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

justin_santhanam
Active Contributor
0 Kudos

Cristian,

Did you executed the same query on your DB2 , whether it got executed successfully?

raj.

Former Member
0 Kudos

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