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.