scottklement.com

Hi Grizz, Nice to hear from you... haven't heard your name in a long time! The basic problem with your example is that the data isn't base64 encoded. I know that because Base64 data would look like the following iVBORw0KGgoAAAANSUhEUgAAASwAAADICAIAAADdvUsCAAAAA3NCSVQFBgUzC42AAAAQFklEQVR4 nO3dT2gbVx4...

Does this happen after you've previously made a TLS connection, where it might be accidentally preserving the settings from a previous session?

Or, how can I reproduce the problem?

Not sure about STRSQL.

If you use "Run SQL Scripts" you can use the "System Debugger" option off of the Run menu. This works very well for debugging UDTFs, is included with ACS (amongst other things) and is very easy to use.

What's happening... HTTPAPI is downloading the data as UTF-8, but then is converting it to EBCDIC before returning it to your RPG program. This will cause any character that doesn't exist in your particular EBCDIC encoding to be translated to x'3F' (this means "substitution character"). Wh...

dustinm wrote: ↑Thu Aug 22, 2024 8:26 pm Is the cookie being sent to me from the server and then HTTPAPI is sending it back?

Yes.

Where is this coming from and how do I get rid of it? When a prior request to the same host sent a cookie, HTTPAPI will automatically send it back on the next request (unless the cookie has expired.) This is a normal part of the HTTP standard. By default, HTTPAPI only 'remembers' and resends cookie...

okay... then you'd want to fill in all of the data you want to return in that one row the first time that doFetch is called. The second time doFetch is called, you'd set the SQL State to '02000' to indicate that there aren't any other rows.

so if I understand correctly in the dofetch routine I have to read all the records for that key on the first call (with a dow or dou loop) and at the end set the state to a value of 02000, instead of allowing dofetch to be called n times until the eof Is reached. Assuming that you want to return on...

It works almost, but i don't understand: what difference does it make the position of the dcl-f? When you define something inside a subprocedure, it only exists while that subprocedure is running -- that means that when the subprocedure ends, the file is closed and the memory it was using is return...

It looks like your file (copdc00f) is declared inside the subprocedure. Therefore it will be automatically closed when the subprocedure returns.

Move your 'dcl-f' so that it is before the first 'dcl-proc.'