How to get Complete OFS Response...

[@kon@]

Hi,

Can anyone guide me about, how to get the complete OFS Response as a
Reselt Set.

I created below script for posting FT, its running smoothly but
returns only ID of the FT application or i can also get other fields
of that FT application, but i need complete OFS response as a result
set ...

<query id="postFT" useConfig="t24">
<sql>SELECT SENDOFS FUNDS.TRANSFER,PK.WS.TEST/I/
PROCESS,ARIF001/123456/,
TRANSACTION.TYPE:: = set ?1
DEBIT.CURRENCY:: = set ?2
DEBIT.AMOUNT:: = set ?3
DEBIT.ACCT.NO:: = set ?4
CREDIT.ACCT.NO:: = set ?5
ORDERING.BANK:: = set ?6
END
</sql>

<result element="postFTResponse" rowName="return" >
<element name="id" column="@ID" />
</result>

<param name="tranType" sqlType="STRING" type="IN"
ordinal="1" />
<param name="currency" sqlType="STRING" type="IN"
ordinal="2" />
<param name="amount" sqlType="STRING" type="IN"
ordinal="3" />
<param name="debitAct" sqlType="STRING" type="IN"
ordinal="4" />
<param name="creditAct" sqlType="STRING" type="IN"
ordinal="5" />
<param name="ordringBank" sqlType="STRING" type="IN"
ordinal="6" />
</query>


Thanks,

[Dmitry.]

application request returns only id
but you can send sequential request to retrieve data by this id.
for example you have enquiry that selects all the data you need from FT by ID
then you could use this selet in service:

<sql>SELECT SENDOFS FUNDS.TRANSFER,PK.WS.TEST/I/
PROCESS,{{USER}}/{{PASS}}/,

                        TRANSACTION.TYPE::        = set ?1
                        DEBIT.CURRENCY::        = set ?2
                        DEBIT.AMOUNT::        = set ?3
                        DEBIT.ACCT.NO::        = set ?4
                        CREDIT.ACCT.NO::        = set ?5
                        ORDERING.BANK::        = set ?6
                 END

?1 = set @id

SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},FT.GET
                     FT.ID:EQ       =   set ?1
                 END
</sql>

Explanation:
1. FUNDS.TRANSFER,PK.WS.TEST sent to server
2. @id from the last record assigned into parameter #1
3. select enquiry FT.GET by FT.ID
--
Regards,
  Dmitry

[Arif Rana]

Hi

Thanks Dmitry,
i will try this

Regards,
Arif