App Connect

 View Only
  • 1.  Calling a esql file.

    Posted Fri November 05, 2021 01:53 AM
    Hi Team,
                 I have created a basic message flow in which I wanted to incorporate esql file which will be maintained separately from the message flow.
                 How to call the esql file in that message flow and how to deploy that file in app connect.

    Thanks,
    Preethi B V

    ------------------------------
    Preethi B V
    ------------------------------


  • 2.  RE: Calling a esql file.

    IBM TechXchange Speaker
    Posted Fri November 05, 2021 05:59 AM
    1. Create a Shared Library, for example called "MySharedLib"
    2. Create an ESQL file in the Shared Library (for example, ESQL file name = Preethi, Schema = MySchema, Module type = COMPUTE)
    3. Create Application, for example called "MyApplication"
    4. Right click MyApplication and choose "Manage Library References" and select the Shared library "MyShared"
    5. Create Message Flow inside the application (eg HTTPInput > Compute > HTTPReply). The Compute node ends up "running" the ESQL.
    6. On the Compute node properties set the ESQL Module = {MySchema}:Preethi
    7. Do the rest of your ESQL / flow development
    8. Create a BAR file containing both the Shared Library and the Application

    ------------------------------
    Ben Thompson
    IBM UK
    ------------------------------



  • 3.  RE: Calling a esql file.

    Posted Fri November 05, 2021 06:39 AM
    Thanks Ben Thompson, After following the steps you mentioned I can now able to use ESQL file in my message flow.

    ------------------------------
    Preethi B V
    ------------------------------