Since you're already in a subroutine and an OPEN/READV has to happen each time a TRANS is used, do a real OPEN/READV which will give you the END ELSE option. This will cut down on the additional testing you need to do so your net processing time should be slightly lower. Just because you HAVE a function available doesn't mean you have to USE that function. Unless you have other motivations for using TRANS, that is.
Good luck! -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: 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 that occaisionally, the full record was only 1 attribute, and that attribute just happened to have the value that was the same as the @ID, making it impossible to tell the difference between a valid attribute data vs the TRANS's "error" reporting method. George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Kebbon Irwin > Sent: Friday, October 08, 2010 11:31 AM > To: [email protected] > 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
