Re: [U2] Stumped with TRANS...

2010-10-19 Thread Bill Haskett
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 foll

Re: [U2] Stumped with TRANS...

2010-10-18 Thread DavidJMurray (mvdbs.com)
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)

Re: [U2] Stumped with TRANS...

2010-10-18 Thread phil walker
Behalf Of DavidJMurray (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

Re: [U2] Stumped with TRANS...

2010-10-18 Thread DavidJMurray (mvdbs.com)
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 cach

Re: [U2] Stumped with TRANS...

2010-10-18 Thread phil walker
. > -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... > >

Re: [U2] Stumped with TRANS...

2010-10-18 Thread DavidJMurray (mvdbs.com)
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 > http://listserver.u2ug.org/mailman/li

Re: [U2] Stumped with TRANS...

2010-10-11 Thread George Gallen
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 c

Re: [U2] Stumped with TRANS...

2010-10-11 Thread Bill Haskett
S to clarify. George -Original Message----- 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

Re: [U2] Stumped with TRANS...

2010-10-11 Thread George Gallen
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 > Su

Re: [U2] Stumped with TRANS...

2010-10-11 Thread Jeff Schasny
rge -Original Message- 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

Re: [U2] Stumped with TRANS...

2010-10-11 Thread George Gallen
ble TRANS to clarify. George > -Original Message- > 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...

Re: [U2] Stumped with TRANS...

2010-10-11 Thread George Gallen
-users-boun...@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

Re: [U2] Stumped with TRANS...

2010-10-11 Thread Rick Nuckolls
licating 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 >

Re: [U2] Stumped with TRANS...

2010-10-11 Thread Mark Eastwood
ile. Mark -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

Re: [U2] Stumped with TRANS...

2010-10-11 Thread George Gallen
ld, so it's 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@li

Re: [U2] Stumped with TRANS...

2010-10-11 Thread Kebbon Irwin
You can do something like 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]

Re: [U2] Stumped with TRANS...

2010-10-11 Thread George Gallen
in our case was about a 1:100 chance). 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

Re: [U2] Stumped with TRANS...

2010-10-08 Thread Kebbon Irwin
8 Oct 2010 10:34:07 -0500 > 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). > &g

Re: [U2] Stumped with TRANS...

2010-10-08 Thread Bob Woodward
nt: Friday, 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 tha

Re: [U2] Stumped with TRANS...

2010-10-08 Thread George Gallen
t; boun...@listserver.u2ug.org] On Behalf 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? >

Re: [U2] Stumped with TRANS...

2010-10-08 Thread Kebbon Irwin
Why not read the whole record in with the TRANS and then check <1> using EXTRACT? > From: ggal...@wyanokegroup.com > To: u2-users@listserver.u2ug.org > Date: Thu, 7 Oct 2010 16:20:17 -0500 > Subject: [U2] Stumped with TRANS... > > ok. I'm using TRANS to read som

Re: [U2] Stumped with TRANS...

2010-10-08 Thread FFT2001
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

Re: [U2] Stumped with TRANS...

2010-10-08 Thread George Gallen
nal Message- > From: u2-users-boun...@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 wit

Re: [U2] Stumped with TRANS...

2010-10-08 Thread George Gallen
g] On Behalf Of Kate Stanton > Sent: Thursday, October 07, 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> > &

Re: [U2] Stumped with TRANS...

2010-10-08 Thread Israel, John R.
...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, October 08, 2010 9:14 AM To: U2 Users List Subject: Re: [U2] Stumped with TRANS... hmmm. might work. I'll have to try it just to see, but I'll most likely go with switching field orders, since I'd rather not do a double

Re: [U2] Stumped with TRANS...

2010-10-08 Thread George Gallen
e- > From: u2-users-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 comp

Re: [U2] Stumped with TRANS...

2010-10-08 Thread George Gallen
# @ID Thanks George > -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... > &

Re: [U2] Stumped with TRANS...

2010-10-07 Thread Kate Stanton
re getting is the key value, then the first AND second > results would be equal, both containing @ID. > > BobW > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold > Sent: Thur

Re: [U2] Stumped with TRANS...

2010-10-07 Thread Bob Woodward
er.u2ug.org] On Behalf Of Oaks, 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 se

Re: [U2] Stumped with TRANS...

2010-10-07 Thread Oaks, Harold
nal Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, October 07, 2010 2:20 PM To: U2 Users List Subject: [U2] Stumped with TRANS... ok. I'm using TRANS to read some data, but I need to be able

[U2] Stumped with TRANS...

2010-10-07 Thread George Gallen
ok. I'm using TRANS to read some data, but I need to be able to tell if the record exists, WITHOUT producing an error message. ok. So, I use the 'C' command, where it's supposed to return the @ID if it doesn't exist BUTI have records where the only data in <1> is the record ID (by coinced