App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

How to call Stored Procedure from My SQL in ESQL

  • 1.  How to call Stored Procedure from My SQL in ESQL

    Posted Mon January 22, 2024 05:22 AM

    How to call Stored Procedure from My SQL in ESQL(IBM ACE V12).I am calling Stored Procedure from MySQL in ESQL with Regular Syntax but i am getting error as  ' [MySQL][ODBC 8.2(a) Driver][mysqld-8.0.36]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{ CALL InsertEmployee (  ? , ? , ? )  }' at line 1 ' which is like syntax error. I tried all possibilities but i am not able to resolve that.



    ------------------------------
    Anand Macherla
    ------------------------------


  • 2.  RE: How to call Stored Procedure from My SQL in ESQL

    Posted Mon January 22, 2024 06:09 AM

    Hi Ananda,

    Interesting project you working on. Please try to update the odbc.in from you file system if you have not done so. Run the following mqsisetdbparms, mqsireload, mqsicvp command. Please send the screenshot when you are done. Once this is done then we can look into the source code. 

    Cool Thanks 

    Justice Tlabo Theledi



    ------------------------------
    Tlabo Justice Theledi
    ------------------------------

    Original Message


Related Content