ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

HTTPAPI with SQLRPGLE - sql error 1003, Nested /copy Statements Not Allowed

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • HTTPAPI with SQLRPGLE - sql error 1003, Nested /copy Statements Not Allowed

    I have an RPGLE program that uses Scott Klement's HTTPAPI to pick up a csv file from a web server and write it to the IFS. Works very well.

    Then I needed to do some SQL within the program, so I changed it to SQLRPGLE. But now when I compile, I get sql error 1003 "Nested /copy statements not allowed". It's referring to the /copy that brings in HTTPAPI_H which itself contains a /copy to CONFIG_H. So there's the nested /copy statements that it now doesn't like anymore.

    So in my SQLRPGLE, I changed /Copy qrpglesrc,httpapi_h to /Include qrpglesrc,httpapi_h, and now it compiles. Is this what you all are doing to get around this?

  • #2
    That is the reason the /include directive was created. Lots of people use this for dealing with this, and similar, problems...

    Comment


    • #3
      I use /include exclusively.

      Comment

      Working...
      X