IBM i Global

IBM i Global

Connect, learn, share, and engage with IBM Power.

 View Only
  • 1.  New sql http function in qsys2 RFE

    Posted Wed February 16, 2022 03:01 AM

    Hi IBM i community,

    have you tried the new sql http functions in qsys2?
    I personally find them very fast, and above all they no longer use java. When the http functions of the systools came out we made extensive use of them, now I find myself on the system dozens of open JVMs that take up a lot of RAM, with all the problems related to Java, including CLI interface errors. (have you ever tried to do an http_get_clob and then a cpyfrmimpf in the same job?)
    So the new functions for me are better. But there is no possibility to download a binary file, such as a .zip. This is why I made this RFE, please vote it!

    https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=154150

    Many thanks



    ------------------------------
    Paolo Salvatore
    ------------------------------


  • 2.  RE: New sql http function in qsys2 RFE

    Posted Thu February 17, 2022 08:38 AM
    in a recent DB2 group a new set of "http" functions were released.
    some do not require JAVA, so maybe they would work for you.

    New HTTP functions added to SYSTOOLS
    -and-
    HTTP functions

    the following has existed for a very long time and works quite well.
    Hypertext Transfer Protocol API
    Scott still supports it.











    ------------------------------
    Bryan Dietz
    ------------------------------