AnsweredAssumed Answered

Syntax of Stored Procedure to Read MySQL Database

Question asked by nirupama110156 on Sep 8, 2017

I am trying to import the below SP to call MySQL Database in DB read Profile:

 

CREATE PROCEDURE ESS_GEN_PARTNER_SALES_DATA_FILE()
begin

 

  SELECT BARCODE, TRANS_DOC, TRANS_DATE,TRANS_TYPE,QUANTITY, VALUE,
  SUPSTORE, LPC, PRICE_INDICATOR
  FROM Boomi.INTERFACE_PARTNER_AME_SLS
  WHERE 
   CREATEDBY ='SYSTEM' 
   AND PROCESS_STATUS='N';

 

end;

 

But while calling the SP it is showing below message:

 

So what will be the syntax of SP to add columns so that I can add fields to the Profile and read data from table?

Outcomes