Skip to Content
0
Former Member
Mar 19, 2009 at 07:28 AM

JDBC response requirement

20 Views

hi

we are triggering a JDBC stored procedure using MsSQL where we select a name based on the location that we get in the source file.

the structure of the response MT is like below:

<MT_response>

<row> 1..n

<Name> 0..1

what we require is ..that even if the DB doesn't return any rows from a particular location, the response should have the row field nonetheless with the Name field missing.

for example the source file has 2 cities - london and delhi

the Stored proc resultset has 4 names for london and none for delhi.

so we want that 4 rows with Name field should come in the MT_response corresponding to london

and 1 row with no Name field should come in the response for delhi.

please help.