Re: [U2] Testing for TRANSACTION block

2008-03-04 Thread Timothy Snyder
> If there a way for a subroutine to know that it has been called fromwithin a > > BEGIN TRANSACTION > END TRANSACTION @TRANSACTION is zero if no transaction is active. It works in both UniData and UniVerse. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Sof

RE: [U2] Testing for TRANSACTION block

2008-03-04 Thread Perry Taylor
If you are running on UniVerse try @TRANSACTION. Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Tuesday, March 04, 2008 12:09 PM To: u2-users@listserver.u2ug.org Subject: [U2] Testing for TRANSACTION block If there a way for a

RE: [U2] Testing for TRANSACTION block

2008-03-04 Thread phil walker
ry. Sorry to be vague but I don't have access to a system at the moment. Cheers, Phil. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Wednesday, 5 March 2008 7:16 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] Testing for TR

RE: [U2] Testing for TRANSACTION block

2008-03-04 Thread David A. Green
In UniData there is @TRANSACTION. Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Tuesday, March 04, 2008 10:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] Testing for

RE: [U2] Testing for TRANSACTION block

2008-03-04 Thread Colin Alfke
UniData uses SYSTEM(49) for the call stack. hth Colin Alfke Calgary, Canada -Original Message- From: Jacques G. If there a way for a subroutine to know that it has been called from within a BEGIN TRANSACTION END TRANSACTION I've got a subroutine somewhere that is calling an illegal co

Re: [U2] Testing for TRANSACTION block

2008-03-04 Thread Louie Bergsagel
If your subroutines don't return their name in the error message when they fail, the only other things I've done is to use RAID, or to put debug statements in the programs: IF UPCASE(@SENTENCE) MATCHES "0X'DEBUG'0X" THEN DEBUG = @TRUE ELSE DEBUG = @FALSE IF DEBUG THEN DISPLAY "Begin subroutine DO

RE: [U2] Testing for TRANSACTION block {Unclassified}

2008-03-04 Thread HENDERSON MIKE, MR
L PROTECTED] On Behalf Of Jacques G. Sent: Wednesday, 5 March 2008 6:09 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] Testing for TRANSACTION block If there a way for a subroutine to know that it has been called from within a BEGIN TRANSACTION END TRANSACTION I've got a subroutine somew

[U2] Testing for TRANSACTION block

2008-03-04 Thread Jacques G.
If there a way for a subroutine to know that it has been called from within a BEGIN TRANSACTION END TRANSACTION I've got a subroutine somewhere that is calling an illegal command for a transaction block and having hard time finding where the call is coming from. ___