I don't mean to belabor this point, but unless your *entire* record is empty,
doing the the trans with a full record requrest - TRANS('FNAME',@ID ,-1,'X') -
you should only have a null returned if the record does not exist. I use
Unidata; is Universe any different? 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: [email protected]
> To: [email protected]
> Date: Mon, 11 Oct 2010 08:56:49 -0500
> Subject: Re: [U2] Stumped with TRANS...
>
> no. I needed to know when the "" returned data was because the record didn't
> exist or because it was an empty string, which is what the 'C' option give
> you, which isn't a problem, unless by chance your returned data just happed
> to be the same as the @ID (Which in our case was about a 1:100 chance).
>
> George
>
> > -----Original Message-----
> > From: [email protected] [mailto:u2-users-
> > [email protected]] On Behalf Of Kebbon Irwin
> > Sent: Friday, October 08, 2010 6:25 PM
> > To: [email protected]
> > Subject: Re: [U2] Stumped with TRANS...
> >
> >
> > Would using the 'X' option in conjunction with the -1 field not do what
> > you want. No record so @1 is null, else read successful. Unless, of
> > course you have empty records with just @ID....
> >
> > > From: [email protected]
> > > To: [email protected]
> > > Date: Fri, 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).
> > >
> > > 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
> _______________________________________________
> 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
