• Stored Procedure

    By tek prince 1 decade ago

    Hi,

    I am using EXT 8.5.3, how can I call stored procedure in XPages.

     

    Regards,

    Naseer

    • In case of DB2 you could use this way

      By Andrejus Chaliapinas 1 decade ago

      Suppose you have defined your UDF (User Defined Function) in DB2 like this:

      CREATE FUNCTION my_function1(param1 VARCHAR(100))

        RETURNS VARCHAR(100)

        RETURN 'Hello ' || param1

       

      Then in your code you could have this JDBC definition:

                  sqlQuery="select my_function1('XPages user') as col1 from sysibm.dual"
            var="jdbcData1">
           

      and then for some xe:viewPanel column you could have:

       

          
                  id="viewColumnHeader1">    
          


       

      • thanks,I will try that

        By tek prince 1 decade ago

        thanks, I will try that.

         

        regards,

        tek

      • db2 output parameter

        By tek prince 1 decade ago

        Hi Andrejus,

        How can I replace the field value on XPage from the db2 output parameter from stored procedure.

        regards,

        Naseer