cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Sql Select Query : getting no response

Former Member
0 Kudos

Hi

I am working on a synchronous interface that has jdbc at the receiver side..

I need to be doing a select dynamically based on a filed from the request like

select locationId from dbTablename where empId = 'xxx' AND delFlag =0

the xxx will be populated from a filed in the request

For this i have set up a request structure with action as "SQL_QUERY" and the following query in the access field

SELECT location_id from dbtablename where empID='$cv_EMPID$' and delFlag=0

I have a key element which has a sub-element "cv_EMPID"

Unfortunately, the query doestn pull any records from the dbtable..

In sxmb_moni , I get a query like this

- <STATEMENT>

- <TABLENAME action="SQL_QUERY">

<TABLE>tablename</TABLE>

</TABLENAME>

<access>select cv_locationID from tablename where cv_empID='$cv_EmpID$'</access>

- <key>

<cv_EmpID>60000016</cv_EmpID>

</key>

</STATEMENT>

but there is no response

What do u think is the problem here?

Thanks

Krishna

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Krishna,

Even though the Problem solved by yourself,

if you share the solution it will be helpfull for others who come across the same prolem in future

Regards

Seshagiri

Former Member
0 Kudos

Solved by myself..

Thanks