DesignBais does all that too. They've built a framework that is used
by the developer to ensure variables are available between connections
for each session. Very handy! :-)
Bill
DavidJMurray (mvdbs.com) said the
FFT2001 wrote:
Has anyone done a timing test to compare a SUBR which uses a common
section
to store an opened file variable
vs a TRANS ?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
Sent: Tuesday, 19 October 2010 1:01 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Stumped with TRANS...
FFT2001 wrote:
Has
phil walker-2 wrote:
Universe does some caching around TRANS from memory. So if you want to
only do lookups your results may indicate a good solution. However, for
update it will not work, and depending on the number of files being
accessed, you may find there are issues with the cache
(mvdbs.com)
Sent: Tuesday, 19 October 2010 2:45 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Stumped with TRANS...
phil walker-2 wrote:
Universe does some caching around TRANS from memory. So if you want
to
only do lookups your results may indicate a good solution
phil walker-2 wrote:
The trouble with using common for things is when you get into
client/server development. You cannot guarantee the common will be
available to you.
Yes, it can get rather messy keeping track of individual user sessions when
a common background process(s) does
).
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
Sent: Friday, October 08, 2010 6:25 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Stumped with TRANS...
Would using the 'X
a DCOUNT to
ensure that if 1 is emplty, there are other attributes in the record
Last post, I promise.
Cheers,
Kebbon
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Mon, 11 Oct 2010 08:56:49 -0500
Subject: Re: [U2] Stumped with TRANS...
no. I needed to know
.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
Sent: Monday, October 11, 2010 1:58 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Stumped with TRANS...
I don't mean to belabor
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, October 11, 2010 11:42 AM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
yes, there are times, when the entire record is empty
not that I'm duplicating the @ID
into 1.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
Sent: Monday, October 11, 2010 1:58 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Stumped with TRANS
...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
Sent: Monday, October 11, 2010 4:00 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
I have not been following this thread, so I might be off base...
But if your trying to determine if a record exists
-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Monday, October 11, 2010 4:06 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
I do not think that there is a way to test the result of a TRANS to
discover
...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Monday, October 11, 2010 4:06 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
I do not think that there is a way to test the result of a TRANS to
discover if the read succeeded
It's already a subroutine...not being used by an I-desc
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Monday, October 11, 2010 4:42 PM
To: U2 Users List
Subject: Re: [U2] Stumped
List
Subject: Re: [U2] Stumped with TRANS...
I do not think that there is a way to test the result of a TRANS to
discover if the read succeeded or was not found. So, that would leave
the slightly flawed options of a) calling a subroutine or b) using the
itype below (though it does have a problem
Yes, with OPEN/READ setup, there is no issue.
With the TRANS setup, I'm forced to do a double TRANS (since I need
more than just the @ID and 1), One TRANS for the data, and
another to verify existance if the data is
I preferred to use the TRANS over OPEN/READ because it was easier to code
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
Sent: Thursday, October 07, 2010 6:01 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
George:
Here's something that might work for you
-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Bob Woodward
Sent: Thursday, October 07, 2010 7:22 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
Can you chain two TRANS functions and compare the results? If you use
C the first time and X
, 2010 8:31 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
How about:
TRANS(filename,recID,@RECORD,'x'); IF @ = THEN 'not there' ELSE
@1,fieldno
On Fri, Oct 8, 2010 at 12:21 PM, Bob Woodward
bob_woodw...@k2sports.comwrote:
Can you chain two TRANS functions and compare
...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Friday, October 08, 2010 9:15 AM
To: 'U2 Users List'
Subject: Re: [U2] Stumped with TRANS...
Instead of a TRANS with various conditions, call a subroutine that has
all the tests you need
Has anyone done a timing test to compare a SUBR which uses a common section
to store an opened file variable
vs a TRANS ?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Of Kebbon Irwin
Sent: Friday, October 08, 2010 11:31 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Stumped with TRANS...
Why not read the whole record in with the TRANS and then check 1
using EXTRACT?
___
U2-Users mailing list
U2-Users
, October 08, 2010 8:34 AM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
When you use the 'C' parameter, Trans will return the record ID if the
record does not exist,
and the full record if it does exist (in my case it did, since I used
-1 as the field).
Problem is that occaisionally
Subject: Re: [U2] Stumped with TRANS...
When you use the 'C' parameter, Trans will return the record ID if the record
does not exist,
and the full record if it does exist (in my case it did, since I used -1 as
the field).
Problem is that occaisionally, the full record was only 1
, Harold
Sent: Thursday, October 07, 2010 3:01 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
George:
Here's something that might work for you, PROVIDED that you always know
that if the target record exists, there is always something in field 1.
It seems like this is the situation
26 matches
Mail list logo
