cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC: how count record?

Former Member
0 Kudos

just like: select * from TAB where field=A;

use JDBC receiver adapter?

Regards.

Accepted Solutions (0)

Answers (2)

Answers (2)

agasthuri_doss
Active Contributor
0 Kudos

Hi,

>>just like: select * from TAB where field=A;

use JDBC receiver adapter?

Receiver JDBC Adapter

For Example:

Actio=INSERT

Statements with this action cause table values to be inserted. Therefore, the statement corresponds to an SQL INSERT statement.

The <access> block contains the new column values.

A statement with the action INSERT must have at least one <access>element. It cannot have a <key> element.

The corresponding SQL statement for StatementName2 in the example above is as follows:

INSERT INTO dbTableName (col1, col2) VALUES(val1, val2)

INSERT INTO dbTableName (col1) VALUES(val11)

The response document contains the following element as well as the number of inserted table lines, including 0.

<insert_count>count</insert_count>

Regards,

Sangeetha

Edited by: Sangeetha on Jul 4, 2008 5:41 PM

Edited by: Sangeetha on Jul 4, 2008 5:49 PM

Former Member
0 Kudos

Then how to get the value exactly?

I don't understand response document really.

Former Member
0 Kudos

Hi,

We dont have option to use this type of queries in the JDBC Receiver

We can use in JDBC Sender side

Regards

Seshagiri

Former Member
0 Kudos

How can I get the value?

SQL: select count(*) as c from TAB.

message mapping:

c-->

Former Member
0 Kudos

HI SHEN

you cannot use select queries using JDBC receiver adapter...

but to get the total count you can write the stored procedure

regards

kummari

aashish_sinha
Active Contributor
0 Kudos

Hi,

Have a look into this, it may help you.

http://help.sap.com/saphelp_nw04s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Regards

Aashish SInha

PS : reward points if helpful