XSL mapping issue

[Former Member]

Hello All,

I have a scenario - SOAP (Async)-> PI 7.1 -> JDBC (Sync) -> PI 7.1 -> SOAP (Async)

In the XSL mapping, I am using this query in "access" (for request -> SOAP-JDBC) -

The runtime parameter values are not being passed in the query ... any suggestions?

SELECT

V1.LR_ID, V1.NAME, V2.T_Id,

V2.FNumber AS FNumber,

DECODE(V1.LR_ID, NULL, 'FALSE', 'TRUE') AS FLAG

FROM TABLENAME V1,

(SELECT '$T_Id$' AS T_Id, '$FNumber$' AS FNumber FROM DUAL) V2

WHERE V1.LR_ID = '$FNumber$'

AND V2.FNumber = V1.LR_ID

Thanks for your help.

Abhi

[Former Member · Accepted solution]

Hi,

You can try using variable declarations in your XSL Mapping. Use the below code ...

XSL Mapping:-

.

.

<xsl:variable name="v_quote">&apos;</xsl:variable>

.

.

SELECT

V1.LR_ID, V1.NAME, V2.T_Id,

V2.FNumber AS FNumber,

DECODE(V1.LR_ID, NULL, 'FALSE', 'TRUE') AS FLAG

FROM TABLENAME V1,

(SELECT

<xsl:value-of select="$v_quote"/>

<xsl:value-of select="T_ID"/>

<xsl:value-of select="$v_quote"/> AS T_ID,

<xsl:value-of select="$v_quote"/>

<xsl:value-of select="FNumber"/>

<xsl:value-of select="$v_quote"/> AS FNumber,

FROM DUAL) V2

WHERE V1.LR_ID =

<xsl:value-of select="$v_quote"/>

<xsl:value-of select="FNumber"/>

<xsl:value-of select="$v_quote"/>

AND V2.FNumber = V1.LR_ID

.

.

You can also make a variable declaration for the outer join, but even the above one should work.

Hope this helps.

Regards,

Neetesh

[Former Member · Accepted solution]

Thanks a lot Neetesh ... this solved my problem !!

I appreciate your time and help.

--Abhi

[MichalKrawczyk]

hi,

try adding logSQLStatement as per oss note 801367

to see what is in the SQL statement

Regards,

Michal Krawczyk

[Former Member]

Hello Michal,

Thanks a lot for your reply. I checked this note, but it's not too helpful.

Any more suggestions? Is my query statement okay or shall I need to make any changes?

Thanks,

Abhi