IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only

  • 1.  Reading Input data from File for Stored Procedure

    Posted 01/03/12 12:01 PM

    Originally posted by: gvh216


    Hi

    I am using Stored Procedure and using DBQUERY i am calling in map

    DBQUERY("CALL Stored_Proc(123,Manu,30000)","-mdq Db_Query.mdq -dbname Sample -T")

    I am reading the Input data. I want to know how can i read these inputs from Input File ,Can anyone help me ,if possible can you give along with syntax..
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: Reading Input data from File for Stored Procedure

    Posted 01/03/12 01:25 PM

    Originally posted by: richlee


    Hi,

    Try...

    
DBQUERY(
"CALL Stored_Proc(" + Input_Item1 + 
"," + Input_Item2 + 
"," + Input_Item3 + 
")",
"-mdq Db_Query.mdq -dbname Sample -T")


    Richard.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: Reading Input data from File for Stored Procedure

    Posted 01/03/12 02:10 PM

    Originally posted by: gvh216


    Hey Richard

    Thank you so much.It worked,but I want to know can i use Get Function with this if so can you give me syntax i am getting syntax error .. Thank u so much for helping people like me
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


Related Content