RE: [U2] DATE.FORMAT illegal when a transaction is active

[phil walker]

Universe triggers start an implicit transaction. As a transaction
requires that is is recoverable, then by default Universe does not allow
the execution of certain verbs within a transaction. You get around that
by putting an H into field of the VOC entry as suggested.


> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Ken Ford
> Sent: Thursday, 16 April 2009 2:52 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] DATE.FORMAT illegal when a transaction is active
> 
> Thank you to those who assisted with this issue.  Adding 'H' to the
> DATE.FORMAT verb did the trick.   However, it is not apparent why it
> did!
> Perhaps Universe thinks it is running a transaction when a file
trigger
> subroutine executes.  No transaction was active.
> 
> Regards,
> 
> Ken Ford
> 
> Universe Software Developer
> 
> [cid:image001.gif@01C9BE8F.CF28AD00]<http://www.firstmac.com.au/>
> 
> Phone:
> 
> (07) 3013 8686
> 
> Email:
> 
> ken.f...@firstmac.com.au<mailto:mark.b...@firstmac.com.au>
> 
> Web:
> 
> www.firstmac.com.au<http://www.firstmac.com.au/>
> 
> 
> 
> 
>
###
> ##
> 
> This email (inc all attachments) is for the use of the intended
> recipient(s)
> only.
> Privileged or confidential information may be contained in this
> communication.
> If you have received this email in error, please notify the sender
> immediately
> and then
> delete all copies of this message from your computer network. If you
> are not
> the
> intended recipient, you must not keep, use, disclose, copy or
> distribute this
> email
> without the author's prior permission. If you are the intended
> recipient and
> you do
> not wish to receive similar electronic messages from us in future,
then
> please
> respond to the sender to this effect.
> 
> We have taken precautions to minimise the risk of transmitting
software
> viruses, but
> advise you to carry out your own virus checks on this email and its
> attachments. We
> do not accept liability for any loss or damage caused by software
> viruses and
> do not
> represent that this transmission is free from viruses or other
defects.
> 
> FirstMac Limited (ABN 59 094 145 963)  (AFSL 290600)
>
###
> ##
> 
> 
> [demime 1.01d removed an attachment of type image/gif which had a name
> of image001.gif]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] DATE.FORMAT illegal when a transaction is active

[Ken Ford]

Thank you to those who assisted with this issue.  Adding 'H' to the
DATE.FORMAT verb did the trick.   However, it is not apparent why it did!
Perhaps Universe thinks it is running a transaction when a file trigger
subroutine executes.  No transaction was active.

Regards,

Ken Ford

Universe Software Developer

[cid:image001.gif@01C9BE8F.CF28AD00]

Phone:

(07) 3013 8686

Email:

ken.f...@firstmac.com.au

Web:

www.firstmac.com.au




#

This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this communication.
If you have received this email in error, please notify the sender immediately
and then
delete all copies of this message from your computer network. If you are not
the
intended recipient, you must not keep, use, disclose, copy or distribute this
email
without the author's prior permission. If you are the intended recipient and
you do
not wish to receive similar electronic messages from us in future, then please
respond to the sender to this effect.

We have taken precautions to minimise the risk of transmitting software
viruses, but
advise you to carry out your own virus checks on this email and its
attachments. We
do not accept liability for any loss or damage caused by software viruses and
do not
represent that this transmission is free from viruses or other defects.

FirstMac Limited (ABN 59 094 145 963)  (AFSL 290600)
#


[demime 1.01d removed an attachment of type image/gif which had a name of 
image001.gif]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] DATE.FORMAT illegal when a transaction is active

[Boydell, Stuart]

I had the same issue with the ENVIRONMENT verb. By amending the VOC
entry you can allow PERFORM and EXECUTE to run the verb in a
transaction.
Put an 'H' in attribute 4 of the voc entry it should then run.
Documented in sysdesc.pdf 3-14

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Ross Ferris
Sent: Tuesday, 7 April 2009 17:03
To: u2-users@listserver.u2ug.org
Subject: [U2] DATE.FORMAT illegal when a transaction is active

On Apr 7, 3:09 pm, ken.f...@firstmac.com.au wrote:
> I get the error in the subject line when updating a file that has an
> associated file trigger.  The file trigger subroutine does what it
> should still.  There is no reference to 'DATE.FORMAT' in the trigger
> subroutine or anything called by it explicitly.  Any ideas what could
> be causing this?  I am using Universe 10.2 under AIX 5.2.
> 
> Regards,
> Ken Ford.

I picked this up from CDP, and thought Ken may have more luck in this
forum

Ross Ferris
Stamina Software
Visage > Better by Design!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] DATE.FORMAT illegal when a transaction is active

[Nick Gettino]

I found this in the Unidata Extensions documentation.  Could this be
related?
Options


If the attribute isNull in EmptyString is ON, when the value of an
optional XML element is omitted, the corresponding database field value
is set to NULL, otherwise it is considered missing. Similarly, when a
database field value is NULL and the attribute isNULL in EmptyString is
ON, the corresponding value of an optional XML element is omitted,
otherwise it is set to an empty string.
Option DateFormat


Format is a conversion code UniData uses to perform the ICONV()/OCONV()
function when getting the data from the XML document or creating the XML
document. This code can be any conversion code understood by UniData.
You can also use the value of "XMLFormat" which converts the data into a
standard data format for the XML document, or takes the standard XML
data format (-mm-dd).

Nicholas M Gettino | Director of Support & Professional Services |
EnRoute Emergency Systems, an Infor company | office: 813-207-6998 |
fax: 678-393-5389 nick.gett...@infor.com | www.enroute911.com
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Ross Ferris
Sent: Tuesday, April 07, 2009 3:03 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] DATE.FORMAT illegal when a transaction is active

On Apr 7, 3:09 pm, ken.f...@firstmac.com.au wrote:
> I get the error in the subject line when updating a file that has an
> associated file trigger.  The file trigger subroutine does what it
> should still.  There is no reference to 'DATE.FORMAT' in the trigger
> subroutine or anything called by it explicitly.  Any ideas what could
> be causing this?  I am using Universe 10.2 under AIX 5.2.
> 
> Regards,
> Ken Ford.

I picked this up from CDP, and thought Ken may have more luck in this
forum

Ross Ferris
Stamina Software
Visage > Better by Design!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/