Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

------------------------------
Tim Fathers
------------------------------

Yes, you can do this via the Options parameter... see HTTP_GET and HTTP_GET_BLOB - IBM Documentation for more info.

But I guess I did misunderstand you... it is not calling them, but I guess on returning from an SQL based webservice ?

------------------------------
Paul Nicolay

Original Message:
Sent: Mon October 20, 2025 09:27 AM
From: Tim Fathers
Subject: Setting headers and cookies when using IWS with SQL

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

------------------------------
Tim Fathers
------------------------------

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

Tim, 

Are you "wrapping" a SQL Statment or Stored Procedure through IWS and then calling this service outside? 

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

We currently wrap stored procedures with a REST API using an internal framework we wrote years ago, which works very much like the Web Services Server as far as I can tell. One of the shortcomings of our existing framework is that it doesn't pass headers or cookies through and I was wondering if the IWS was able to do that when configured to use an SQL backend. I can see that individual request headers can be passed in but I can't see a way for response headers to be returned. I was also wondering if all request headers can be wrapped and passed in as a JSON structure, without having to specify a parameter for each one.

We wouldn't be calling SQL statements directly - only via a SP or UDF.

Tim

Tim, 

Are you "wrapping" a SQL Statment or Stored Procedure through IWS and then calling this service outside? 

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

Ok I now follow:  

On this link, yes it refers to that its possible :https://www.ibm.com/support/pages/node/6173517/ 

See on point number (2):  

Its specified in the format of case-insensitive name followed by a colon ':' and its value.

Quote from the help text : HTTP header information: Specify any HTTP headers the resource method will return. Each header must be specified on a separate line. An HTTP header consists of a case-insensitive name followed by a colon ':' and its value.

Though I do not see a way that you can return this based on a runtime value if you do choose the SQL route - this looks static. in RPGLE though, its just a matter of defining the parameter in an array and mapping that during the Service creation. 

@Nadir K Amra can perhaps guide or correct my reasoning here. 

HTH 

We currently wrap stored procedures with a REST API using an internal framework we wrote years ago, which works very much like the Web Services Server as far as I can tell. One of the shortcomings of our existing framework is that it doesn't pass headers or cookies through and I was wondering if the IWS was able to do that when configured to use an SQL backend. I can see that individual request headers can be passed in but I can't see a way for response headers to be returned. I was also wondering if all request headers can be wrapped and passed in as a JSON structure, without having to specify a parameter for each one.

We wouldn't be calling SQL statements directly - only via a SP or UDF.

Tim

Tim, 

Are you "wrapping" a SQL Statment or Stored Procedure through IWS and then calling this service outside? 

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

Many thanks for the reply. Yes, I saw that but as it appears to only support static values, it's not very useful unfortunately. I'd like to avoid going down the RPG route if I can help it.

Tim.

Ok I now follow:  

On this link, yes it refers to that its possible :https://www.ibm.com/support/pages/node/6173517/ 

See on point number (2):  

Its specified in the format of case-insensitive name followed by a colon ':' and its value.

Quote from the help text : HTTP header information: Specify any HTTP headers the resource method will return. Each header must be specified on a separate line. An HTTP header consists of a case-insensitive name followed by a colon ':' and its value.

Though I do not see a way that you can return this based on a runtime value if you do choose the SQL route - this looks static. in RPGLE though, its just a matter of defining the parameter in an array and mapping that during the Service creation. 

@Nadir K Amra can perhaps guide or correct my reasoning here. 

HTH 

We currently wrap stored procedures with a REST API using an internal framework we wrote years ago, which works very much like the Web Services Server as far as I can tell. One of the shortcomings of our existing framework is that it doesn't pass headers or cookies through and I was wondering if the IWS was able to do that when configured to use an SQL backend. I can see that individual request headers can be passed in but I can't see a way for response headers to be returned. I was also wondering if all request headers can be wrapped and passed in as a JSON structure, without having to specify a parameter for each one.

We wouldn't be calling SQL statements directly - only via a SP or UDF.

Tim

Tim, 

Are you "wrapping" a SQL Statment or Stored Procedure through IWS and then calling this service outside? 

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

------------------------------
Tim Fathers
------------------------------

Hi, on our TODO list to allow the programmatic setting of response HTTP headers in SQL web services.  So right now you cannot do that. 

------------------------------
Nadir K Amra

Original Message:
Sent: Mon October 20, 2025 09:27 AM
From: Tim Fathers
Subject: Setting headers and cookies when using IWS with SQL

Hello all,

Is there a way for SQL functions or stored procedures called via a REST service on the IWS to set headers and cookies? Also, is there a way to wrap all headers into an input parameter?

Many thanks,

Tim.

------------------------------
Tim Fathers
------------------------------