Oninit cdi / Archive
Talk to an expert →

Problem with sysdate in SPL

Posted in 2015

Summary

A user on IDS 11.50 found that SYSDATE (and CURRENT) returns the same value, down to the fraction of a second, for every call inside a stored procedure loop, so all inserted rows got an identical timestamp. Respondents (Fernando Nunes, John Miller) explained this is intended SQL-standard behaviour: the time is fixed for the duration of the statement/procedure. Workaround offered was DBINFO('utc_to_datetime', sh_curtime) from sysmaster:sysshmvals, but that only gives second precision; for sub-second values Art Kagel and Paul Watson advised writing a trivial C/Java UDR calling gettimeofday(). No other fix was recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Stored Procedures & SPL, Server Administration, Platform-Specific Issues

SERVIO VELASCO — — source: IIUG Forums & Mailing Lists

Hello everbody We have a problem with sysdate in spl. The fractions of second is same during all executing of store procedure. The version of IDS is 11.50 FC9GE in Solaris Sparc 10. In the onconfig set USEOSTIME in 1. I created a table with camp datetime and two store procedures. create table 'informix'.aaaafecha ( idinternal SERIAL not null, fecha DATETIME YEAR TO FRACTION(5) not null ); CREATE PROCEDURE "informix".aaa_InsFecha( pfecha datetime year to fraction(5) ); insert into aaaaFecha (fecha) values( pfecha );END PROCEDURE; CREATE PROCEDURE "informix".aaa_InsFecha1( ); define vX INT; define vX1 INT; DEFINE my_dt DATETIME YEAR TO FRACTION(5); let vX = 0; WHILE vX<=2500 let vx1=0; SET STATEMENT CACHE OFF; let my_dt = (select sysdate from sysmaster:sysdual); execute procedure aaa_InsFecha(my_dt); LET vX = vX + 1; While VX1<=5000 LET vx1=vx1+1; END WHILE; END WHILE; END PROCEDURE; I execute the aaa_InsFecha1( ) and all records in the table have the same time. execute procedure aaa_InsFecha1( ); select distinct fecha from aaaaFecha; fecha 2015-11-03 10:15:03.93500 Anybody why is the cause or how to resolve it? Thank a lots Regards Servio Velasco

↪ replying to SERVIO VELASCO
Fernando Nunes — — source: IIUG Forums & Mailing Lists

It's not a problem. It's intended behavior. Of course, for you it's a problem :) If you just want precision up to second, then you can workaround it by: SELECT DBINFO('utc_to_datetime', sh_curtime) INTO current_time FROM sysmaster:sysshmvals; See this post for more details: http://informix-technology.blogspot.com.es/2009/08/current-time-really.html Regards On Tue, Nov 3, 2015 at 3:50 PM, SERVIO VELASCO <servio_velasco@hotmail.com> wrote: > Hello everbody > > We have a problem with sysdate in spl. The fractions of second is same > during > all executing of store procedure. > > The version of IDS is 11.50 FC9GE in Solaris Sparc 10. > > In the onconfig set USEOSTIME in 1. > > I created a table with camp datetime and two store procedures. > > create table 'informix'.aaaafecha ( > > idinternal SERIAL not null, > > fecha DATETIME YEAR TO FRACTION(5) not null > ); > > CREATE PROCEDURE "informix".aaa_InsFecha( pfecha datetime year to > fraction(5) > ); > > insert into aaaaFecha (fecha) values( pfecha );> END PROCEDURE; > > CREATE PROCEDURE "informix".aaa_InsFecha1( ); > > define vX INT; > > define vX1 INT; > DEFINE my_dt DATETIME YEAR TO FRACTION(5); > > let vX = 0; > > WHILE vX<=2500 > > let vx1=0; > > SET STATEMENT CACHE OFF; > > let my_dt = (select sysdate from sysmaster:sysdual); > > execute procedure aaa_InsFecha(my_dt);> > LET vX = vX + 1; > > While VX1<=5000 > > LET vx1=vx1+1; > > END WHILE; > END WHILE; > > END PROCEDURE; > > I execute the aaa_InsFecha1( ) and all records in the table have the same > time. > > execute procedure aaa_InsFecha1( );> > select distinct fecha from aaaaFecha;> > fecha > > 2015-11-03 10:15:03.93500 > > Anybody why is the cause or how to resolve it? > > Thank a lots > Regards > > Servio Velasco > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c39d50adb6410523a4433f

↪ replying to SERVIO VELASCO
Ricardo Henriques — — source: IIUG Forums & Mailing Lists

Hi Servio, See this note: http://www-01.ibm.com/support/docview.wss?uid=swg21252128 Try to use: let my_dt = (select DBINFO('utc_to_datetime', sh_curtime)from sysmaster:sysshmvals); Keen regards On Tue, 3 Nov 2015 at 14:50 SERVIO VELASCO <servio_velasco@hotmail.com> wrote: > Hello everbody > > We have a problem with sysdate in spl. The fractions of second is same > during > all executing of store procedure. > > The version of IDS is 11.50 FC9GE in Solaris Sparc 10. > > In the onconfig set USEOSTIME in 1. > > I created a table with camp datetime and two store procedures. > > create table 'informix'.aaaafecha ( > > idinternal SERIAL not null, > > fecha DATETIME YEAR TO FRACTION(5) not null > ); > > CREATE PROCEDURE "informix".aaa_InsFecha( pfecha datetime year to > fraction(5) > ); > > insert into aaaaFecha (fecha) values( pfecha );> END PROCEDURE; > > CREATE PROCEDURE "informix".aaa_InsFecha1( ); > > define vX INT; > > define vX1 INT; > DEFINE my_dt DATETIME YEAR TO FRACTION(5); > > let vX = 0; > > WHILE vX<=2500 > > let vx1=0; > > SET STATEMENT CACHE OFF; > > let my_dt = (select sysdate from sysmaster:sysdual); > > execute procedure aaa_InsFecha(my_dt);> > LET vX = vX + 1; > > While VX1<=5000 > > LET vx1=vx1+1; > > END WHILE; > END WHILE; > > END PROCEDURE; > > I execute the aaa_InsFecha1( ) and all records in the table have the same > time. > > execute procedure aaa_InsFecha1( );> > select distinct fecha from aaaaFecha;> > fecha > > 2015-11-03 10:15:03.93500 > > Anybody why is the cause or how to resolve it? > > Thank a lots > Regards > > Servio Velasco > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11444b58dcbdd80523a42f35

↪ replying to Fernando Nunes
John Miller iii — — source: IIUG Forums & Mailing Lists

This is the intended behavior by the SQL standard. This was not dictated by Informix, but rather the way SQL operates. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 11/03/2015 07:08:26 AM: > From: "Fernando Nunes" <domusonline@gmail.com> > To: ids@iiug.org > Date: 11/03/2015 07:09 AM > Subject: Re: Problem with sysdate in SPL [35983] > Sent by: ids-bounces@iiug.org > > It's not a problem. It's intended behavior. > Of course, for you it's a problem :) > > If you just want precision up to second, then you can workaround it by: > > SELECT > > DBINFO('utc=5Fto=5Fdatetime', sh=5Fcurtime) > INTO> > current=5Ftime > FROM > > sysmaster:sysshmvals; > > See this post for more details: > http://informix-technology.blogspot.com.es/2009/08/current-time-really.html > > Regards > > On Tue, Nov 3, 2015 at 3:50 PM, SERVIO VELASCO <servio=5Fvelasco@hotmail.com> > wrote: > > > Hello everbody > > > > We have a problem with sysdate in spl. The fractions of second is same > > during > > all executing of store procedure. > > > > The version of IDS is 11.50 FC9GE in Solaris Sparc 10. > > > > In the onconfig set USEOSTIME in 1. > > > > I created a table with camp datetime and two store procedures. > > > > create table 'informix'.aaaafecha ( > > > > idinternal SERIAL not null, > > > > fecha DATETIME YEAR TO FRACTION(5) not null > > ); > > > > CREATE PROCEDURE "informix".aaa=5FInsFecha( pfecha datetime year to > > fraction(5) > > ); > > > > insert into aaaaFecha (fecha) values( pfecha );> > END PROCEDURE; > > > > CREATE PROCEDURE "informix".aaa=5FInsFecha1( ); > > > > define vX INT; > > > > define vX1 INT; > > DEFINE my=5Fdt DATETIME YEAR TO FRACTION(5); > > > > let vX =3D 0; > > > > WHILE vX<=3D2500 > > > > let vx1=3D0; > > > > SET STATEMENT CACHE OFF; > > > > let my=5Fdt =3D (select sysdate from sysmaster:sysdual); > > > > execute procedure aaa=5FInsFecha(my=5Fdt);> > > > LET vX =3D vX + 1; > > > > While VX1<=3D5000 > > > > LET vx1=3Dvx1+1; > > > > END WHILE; > > END WHILE; > > > > END PROCEDURE; > > > > I execute the aaa=5FInsFecha1( ) and all records in the table have the same > > time. > > > > execute procedure aaa=5FInsFecha1( );> > > > select distinct fecha from aaaaFecha;> > > > fecha > > > > 2015-11-03 10:15:03.93500 > > > > Anybody why is the cause or how to resolve it? > > > > Thank a lots > > Regards > > > > Servio Velasco > > > > > > > > > ***************************************************************************= **** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001a11c39d50adb6410523a4433f > > > ***************************************************************************= **** > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to John Miller iii
Fernando Nunes — — source: IIUG Forums & Mailing Lists

Yes... That's how I started the article... On Tue, Nov 3, 2015 at 4:30 PM, John Miller iii <miller3@us.ibm.com> wrote: > This is the intended behavior by the SQL standard. This was not dictated > by Informix, but rather the way SQL operates. > > John F. Miller III > STSM, Lead Architect > miller3@us.ibm.com > 503-747-1366 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 11/03/2015 07:08:26 AM: > > > From: "Fernando Nunes" <domusonline@gmail.com> > > To: ids@iiug.org > > Date: 11/03/2015 07:09 AM > > Subject: Re: Problem with sysdate in SPL [35983] > > Sent by: ids-bounces@iiug.org > > > > It's not a problem. It's intended behavior. > > Of course, for you it's a problem :) > > > > If you just want precision up to second, then you can workaround it by: > > > > SELECT > > > > DBINFO('utc=5Fto=5Fdatetime', sh=5Fcurtime) > > INTO> > > > current=5Ftime > > FROM > > > > sysmaster:sysshmvals; > > > > See this post for more details: > > > http://informix-technology.blogspot.com.es/2009/08/current-time-really.html > > > > > Regards > > > > On Tue, Nov 3, 2015 at 3:50 PM, SERVIO VELASCO > <servio=5Fvelasco@hotmail.com> > > wrote: > > > > > Hello everbody > > > > > > We have a problem with sysdate in spl. The fractions of second is same > > > during > > > all executing of store procedure. > > > > > > The version of IDS is 11.50 FC9GE in Solaris Sparc 10. > > > > > > In the onconfig set USEOSTIME in 1. > > > > > > I created a table with camp datetime and two store procedures. > > > > > > create table 'informix'.aaaafecha ( > > > > > > idinternal SERIAL not null, > > > > > > fecha DATETIME YEAR TO FRACTION(5) not null > > > ); > > > > > > CREATE PROCEDURE "informix".aaa=5FInsFecha( pfecha datetime year to > > > fraction(5) > > > ); > > > > > > insert into aaaaFecha (fecha) values( pfecha );> > > END PROCEDURE; > > > > > > CREATE PROCEDURE "informix".aaa=5FInsFecha1( ); > > > > > > define vX INT; > > > > > > define vX1 INT; > > > DEFINE my=5Fdt DATETIME YEAR TO FRACTION(5); > > > > > > let vX =3D 0; > > > > > > WHILE vX<=3D2500 > > > > > > let vx1=3D0; > > > > > > SET STATEMENT CACHE OFF; > > > > > > let my=5Fdt =3D (select sysdate from sysmaster:sysdual); > > > > > > execute procedure aaa=5FInsFecha(my=5Fdt);> > > > > > LET vX =3D vX + 1; > > > > > > While VX1<=3D5000 > > > > > > LET vx1=3Dvx1+1; > > > > > > END WHILE; > > > END WHILE; > > > > > > END PROCEDURE; > > > > > > I execute the aaa=5FInsFecha1( ) and all records in the table have the > same > > > time. > > > > > > execute procedure aaa=5FInsFecha1( );> > > > > > select distinct fecha from aaaaFecha;> > > > > > fecha > > > > > > 2015-11-03 10:15:03.93500 > > > > > > Anybody why is the cause or how to resolve it? > > > > > > Thank a lots > > > Regards > > > > > > Servio Velasco > > > > > > > > > > > > > > > > ***************************************************************************= > **** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --001a11c39d50adb6410523a4433f > > > > > > > > ***************************************************************************= > **** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a1140ec248a639b0523a4ca32

↪ replying to SERVIO VELASCO
Art Kagel — — source: IIUG Forums & Mailing Lists

Servio: Looks like you've got your direct answer. If the suggested solution won't work for you because you need sub-second resolution, you will have to write a small "C" or Java language UDR that calls the gettimeofday() system call and returns the time to you in whatever format you need it to be in. This is a very simple UDR, so go for it. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 3, 2015 at 9:50 AM, SERVIO VELASCO <servio_velasco@hotmail.com> wrote: > Hello everbody > > We have a problem with sysdate in spl. The fractions of second is same > during > all executing of store procedure. > > The version of IDS is 11.50 FC9GE in Solaris Sparc 10. > > In the onconfig set USEOSTIME in 1. > > I created a table with camp datetime and two store procedures. > > create table 'informix'.aaaafecha ( > > idinternal SERIAL not null, > > fecha DATETIME YEAR TO FRACTION(5) not null > ); > > CREATE PROCEDURE "informix".aaa_InsFecha( pfecha datetime year to > fraction(5) > ); > > insert into aaaaFecha (fecha) values( pfecha );> END PROCEDURE; > > CREATE PROCEDURE "informix".aaa_InsFecha1( ); > > define vX INT; > > define vX1 INT; > DEFINE my_dt DATETIME YEAR TO FRACTION(5); > > let vX = 0; > > WHILE vX<=2500 > > let vx1=0; > > SET STATEMENT CACHE OFF; > > let my_dt = (select sysdate from sysmaster:sysdual); > > execute procedure aaa_InsFecha(my_dt);> > LET vX = vX + 1; > > While VX1<=5000 > > LET vx1=vx1+1; > > END WHILE; > END WHILE; > > END PROCEDURE; > > I execute the aaa_InsFecha1( ) and all records in the table have the same > time. > > execute procedure aaa_InsFecha1( );> > select distinct fecha from aaaaFecha;> > fecha > > 2015-11-03 10:15:03.93500 > > Anybody why is the cause or how to resolve it? > > Thank a lots > Regards > > Servio Velasco > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0103e3662edb8d0523a54436

↪ replying to Ricardo Henriques
SERVIO VELASCO — — source: IIUG Forums & Mailing Lists

Thanks for yours answers, but DBINFO returns until seconds. We need fractions of second. Exists any forms to convert or DBINFO returns fractions of second. Thanks a lots

↪ replying to SERVIO VELASCO
Paul Watson — — source: IIUG Forums & Mailing Lists

As Art suggested write a simple UDR that uses getimeofday, it will be trivial Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SERVIO VELASCO Sent: Tuesday, November 03, 2015 12:11 PM To: ids@iiug.org Subject: Re: Problem with sysdate in SPL [35988] Thanks for yours answers, but DBINFO returns until seconds. We need fractions of second. Exists any forms to convert or DBINFO returns fractions of second. Thanks a lots **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Paul Watson
Everett Mills — — source: IIUG Forums & Mailing Lists

Why not just use this: SELECT CURRENT YEAR TO FRACTION FROM sysmaster:sysdual > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Paul Watson > Sent: Tuesday, November 03, 2015 12:15 PM > To: ids@iiug.org > Subject: RE: Problem with sysdate in SPL [35989] > > As Art suggested write a simple UDR that uses getimeofday, it will be > trivial > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > SERVIO VELASCO > Sent: Tuesday, November 03, 2015 12:11 PM > To: ids@iiug.org > Subject: Re: Problem with sysdate in SPL [35988] > > Thanks for yours answers, but DBINFO returns until seconds. > > We need fractions of second. Exists any forms to convert or DBINFO > returns fractions of second. > > Thanks a lots > > *********************************************************************** > ***** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Everett Mills
Paul Watson — — source: IIUG Forums & Mailing Lists

Cos within a SPL statement the CURRENT value will be static i.e. won't change within the SPL . However, if the SPL doesn't care about the time changing then your SQL is fine select oni_gettimeofday(NULL) from sysmaster:sysdual; select oni_gettimeofday("%Y-%m-%d %H:%M:%S") from sysmaster:sysdual; create procedure sp_test() returning datetime year to fraction(5) define t datetime year to fraction(5); select current year to fraction(5) into t from sysmaster:sysdual; return t with resume; select current year to fraction(5) into t from sysmaster:sysdual; return t with resume; select current year to fraction(5) into t from sysmaster:sysdual; return t with resume; select current year to fraction(5) into t from sysmaster:sysdual; return t with resume; end procedure; (expression) 2015-11-04 15:27:03.00743 (expression) 2015-11-04 15:27:03.00744 (expression) 2015-11-04 15:27:03.75067 2015-11-04 15:27:03.75067 2015-11-04 15:27:03.75067 2015-11-04 15:27:03.75067 4 row(s) retrieved. Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Everett Mills Sent: Wednesday, November 04, 2015 9:20 AM To: ids@iiug.org Subject: RE: Problem with sysdate in SPL [35996] Why not just use this: SELECT CURRENT YEAR TO FRACTION FROM sysmaster:sysdual > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Paul Watson > Sent: Tuesday, November 03, 2015 12:15 PM > To: ids@iiug.org > Subject: RE: Problem with sysdate in SPL [35989] > > As Art suggested write a simple UDR that uses getimeofday, it will be > trivial > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > SERVIO VELASCO > Sent: Tuesday, November 03, 2015 12:11 PM > To: ids@iiug.org > Subject: Re: Problem with sysdate in SPL [35988] > > Thanks for yours answers, but DBINFO returns until seconds. > > We need fractions of second. Exists any forms to convert or DBINFO > returns fractions of second. > > Thanks a lots > > *********************************************************************** > ***** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Paul Watson
Everett Mills — — source: IIUG Forums & Mailing Lists

Good point. I usually do much more 4gl than SPL and sometimes I forget there are some differences. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Paul Watson > Sent: Wednesday, November 04, 2015 09:32 AM > To: ids@iiug.org > Subject: RE: Problem with sysdate in SPL [35997] > > Cos within a SPL statement the CURRENT value will be static i.e. won't > change within the SPL . However, if the SPL doesn't care about the time > changing then your SQL is fine > > select oni_gettimeofday(NULL) from sysmaster:sysdual; select > oni_gettimeofday("%Y-%m-%d %H:%M:%S") from sysmaster:sysdual; > > create procedure sp_test() > returning datetime year to fraction(5)> > define t datetime year to fraction(5); > > select current year to fraction(5) into t from sysmaster:sysdual; > > return t with resume; > > select current year to fraction(5) into t from sysmaster:sysdual; > > return t with resume; > > select current year to fraction(5) into t from sysmaster:sysdual; > > return t with resume; > > select current year to fraction(5) into t from sysmaster:sysdual; > > return t with resume; > > end procedure; > > (expression) 2015-11-04 15:27:03.00743 > (expression) 2015-11-04 15:27:03.00744 > > (expression) > > 2015-11-04 15:27:03.75067 > 2015-11-04 15:27:03.75067 > 2015-11-04 15:27:03.75067 > 2015-11-04 15:27:03.75067 > > 4 row(s) retrieved. > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Everett Mills > Sent: Wednesday, November 04, 2015 9:20 AM > To: ids@iiug.org > Subject: RE: Problem with sysdate in SPL [35996] > > Why not just use this: > > SELECT CURRENT YEAR TO FRACTION FROM sysmaster:sysdual > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Paul Watson > > Sent: Tuesday, November 03, 2015 12:15 PM > > To: ids@iiug.org > > Subject: RE: Problem with sysdate in SPL [35989] > > > > As Art suggested write a simple UDR that uses getimeofday, it will be > > trivial > > > > Cheers > > Paul > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > SERVIO VELASCO > > Sent: Tuesday, November 03, 2015 12:11 PM > > To: ids@iiug.org > > Subject: Re: Problem with sysdate in SPL [35988] > > > > Thanks for yours answers, but DBINFO returns until seconds. > > > > We need fractions of second. Exists any forms to convert or DBINFO > > returns fractions of second. > > > > Thanks a lots > > > > > ********************************************************************** > > * > > ***** > > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > ********************************************************************** > > * > > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > *********************************************************************** > ***** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary