IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
Back to discussions
Expand all | Collapse all

Datbase Interface designer: Unable to get the resultset

  • 1.  Datbase Interface designer: Unable to get the resultset

    Posted 02/23/13 07:36 AM

    Originally posted by: Vinod.M.Lanjekar


    Hi All,
    In DID ,We are calling Stored procedure using the DBQUERY function as below.

    =F_DATA(SUBSTITUTE(DBQUERY("CALL%SCHEMA%.STOREDPROCUDRE('"TRIMRIGHT(EmpID)"'?,?)","-MDQ %MDQNAME% -DBNAME %DBVAL% -T dbtrace.txt"),"<CR><LF>",""))

    The output should be:
    MSG
    CODENO
    Slno Name EmpID Desgnation
    Slno Name EmpID Desgnation
    Slno Name EmpID Desgnation
    Slno Name EmpID Desgnation
    Slno Name EmpID Desgnation

    I am able to get MSG and CODENO value.But unable to get the Resultset as mentioned above.
    Kinldy provide your inputs to get the result set.

    Thanks and Regards,

    Vinod
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


Related Content