Time zone is an environment level variable.  The intersystems data server response is at the application level, so likely returning gmt is correct.  The application can adjust based on the environment (geolocation).

Hi Mike, 

While I'm not total familiar with the syntax for your ~/.{{tcsh,bash}rc|profile|...} it seems to me that the end should be:

<Location>CSP On  SetHandler csp-handler-sa</Location>

as opposed to: <Location />CSP On  SetHandler csp-handler-sa</Location>

Minor I know, and if it html syntax likely doesn't matter at all.  Still if it is in fact a {u,li}nix resource file, syntax would be important.

Chris

drop table if exists [stair];
create table [stair] (
    [purse] integer
);
insert into [stair] (purse) values(9);
insert into [stair] (purse) values(2);
insert into [stair] (purse) values(7);
--++++++
declare cursorA cursor 
for select purse from [dbo].[stair]
declare @col integer
declare @tot integer
open cursorA
set @tot = 0
fetch next from cursorA into @col
while @@FETCH_STATUS=0
begin
   set @tot = @tot + @col;
   print convert(varchar,@col) + ', ' + convert(varchar,@tot);
   fetch next from cursorA INTO @col;
end
close cursorA;
deallocate cursorA;
drop table [stair];
 

Hi Praj, 

In the past, the following has worked for me using Intersystems Cache ODBC interface: 

{fn CONCAT(string-expression1,string-expression2)}

Hopefully this helps.

Chris Kennedy