Re: Q: SPL, CURRENT, BEGIN, COMMIT ?
In article <9611201632.aa15060@qwsserv.qws.msk.su>, Victor Kronberg
<kron@qws.msk.su> writes
>Hi all,
>
>We are running INFORMIX (Online 7.10.UC1) on SCO UNIX 3.2v5.0.0.
>Database created with log.
>
>
I had a client who had a lot of problems with 7.10. I would move to
at least 7.11 as it has >140 bug fixes! You will find either
7.12,7.13,7.20 or even 7.21 is the latest release and it should be
a free upgrade if you talk to Technical Support and get a bug number
for your problem.
>Test N 1 :
>----------
>CREATE PROCEDURE xxx()
> DEFINE current_date_time DATETIME YEAR TO FRACTION(2);>
>{ 1 } LET current_date_time = CURRENT;
>
>END PROCEDURE;
>EXECUTE PROCEDURE xxx();>dbaccess: Procedure executed.
>
>
>Test N 2 :
>----------
>CREATE PROCEDURE xxx()
> DEFINE current_date_time DATETIME YEAR TO FRACTION(2);>
>{ 1 } BEGIN WORK;
>{ 2 } LET current_date_time = CURRENT;
>{ 3 } COMMIT WORK;
>
>END PROCEDURE;
>EXECUTE PROCEDURE xxx();>dbaccess: Procedure executed.
>
>
>Test N 3 !!! :
>--------------
>DROP PROCEDURE xxx;
>CREATE PROCEDURE xxx()
> DEFINE current_date_time DATETIME YEAR TO FRACTION(2);>
>{ 1 } BEGIN WORK;
>{ 2 } COMMIT WORK;
>
>{ 3 } LET current_date_time = CURRENT;
>
>END PROCEDURE;
>EXECUTE PROCEDURE xxx();>dbaccess: 1263: A field in a datetime or interval value is out of range
> or incorrect.
>
>Does anybody can explain me such behaviour ?
>Many thanks in advance.
>
>Best Regards, QWERTYS Ltd.
>Victor Kronberg, 10, Elektrodnaya St.,
>+7 (095) 368-8061 App # 425,
>E-Mail : kis@qws.msk.su Moscow, Russia,
>November 20, 1996, 16:30 111524.
>
--
David Williams