Re: [U2] Need help with MV assoc/I-desc
I haven't tried this on UD but BY-EXP XEM.PERSON = usernumber may work in Pick flavour. This should only return records and data for that user number. On 23/12/2010 03:06, Jeffrey Butera wrote: I need insight from the U2 faithful. This is Unidata 7, if that affects the answer... I have a file which has 2 associated fields, such as: XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 XEM.VALUE = 23:@VM:14:@VM:99 What I'd like is a field which sorts by XEM.VALUE for the associated person querying the records. That is, if person 1737292 is selecting records it would use 23 for purposes of sorting this record. If 1818182 is selecting, it would use 14 for sorting. I've done plenty of i-descriptors both with and without subroutines, but I don't have insight as to any method of allowing the query to know who's running it. I've dreamed about WHEN...ASD but Unidata only allow this in a LIST statement and it doesn't really do what I need, even if it were allowed in a SELECT. I need the data stored as listed above, but I am open to using a database trigger to store this in some alternative form that makes the query easier to deal with - but I can't think of how this might be accomplished. Any insight is appreciated. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Need help with MV assoc/I-desc
I don't know if I completely understand the issue here... I have created dynamic sorts using @USER0 values. By LOCATEing the user in XEM.PERSON, use that position to set the @USER0 value to the correct XEM.VALUE. Then use @USER0 value for the purpose of sorting the file Am I understanding your question? 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' - Original Message From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, December 22, 2010 9:06:54 PM Subject: [U2] Need help with MV assoc/I-desc I need insight from the U2 faithful. This is Unidata 7, if that affects the answer... I have a file which has 2 associated fields, such as: XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 XEM.VALUE = 23:@VM:14:@VM:99 What I'd like is a field which sorts by XEM.VALUE for the associated person querying the records. That is, if person 1737292 is selecting records it would use 23 for purposes of sorting this record. If 1818182 is selecting, it would use 14 for sorting. I've done plenty of i-descriptors both with and without subroutines, but I don't have insight as to any method of allowing the query to know who's running it. I've dreamed about WHEN...ASD but Unidata only allow this in a LIST statement and it doesn't really do what I need, even if it were allowed in a SELECT. I need the data stored as listed above, but I am open to using a database trigger to store this in some alternative form that makes the query easier to deal with - but I can't think of how this might be accomplished. Any insight is appreciated. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, one [dollar bills] are good but tens are way better. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Need help with MV assoc/I-desc
Sorry-I'm not familiar with @USER0 Also this is thru a web interface so the user running the code in unidata isn't the same as the person running the web interface. Jeff Butera Sent from my iPhone On Dec 23, 2010, at 11:48 AM, Shawn Hayes go_mnviki...@yahoo.com wrote: I don't know if I completely understand the issue here... I have created dynamic sorts using @USER0 values. By LOCATEing the user in XEM.PERSON, use that position to set the @USER0 value to the correct XEM.VALUE. Then use @USER0 value for the purpose of sorting the file Am I understanding your question? 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' - Original Message From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, December 22, 2010 9:06:54 PM Subject: [U2] Need help with MV assoc/I-desc I need insight from the U2 faithful. This is Unidata 7, if that affects the answer... I have a file which has 2 associated fields, such as: XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 XEM.VALUE = 23:@VM:14:@VM:99 What I'd like is a field which sorts by XEM.VALUE for the associated person querying the records. That is, if person 1737292 is selecting records it would use 23 for purposes of sorting this record. If 1818182 is selecting, it would use 14 for sorting. I've done plenty of i-descriptors both with and without subroutines, but I don't have insight as to any method of allowing the query to know who's running it. I've dreamed about WHEN...ASD but Unidata only allow this in a LIST statement and it doesn't really do what I need, even if it were allowed in a SELECT. I need the data stored as listed above, but I am open to using a database trigger to store this in some alternative form that makes the query easier to deal with - but I can't think of how this might be accomplished. Any insight is appreciated. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, one [dollar bills] are good but tens are way better. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Need help with MV assoc/I-desc
On 23/12/10 18:38, jbut...@hampshire.edu wrote: Sorry-I'm not familiar with @USER0 @USER0 (and 1, 2, up to 5 I think) are @ variables (like @VM, @SYSTEM.RETURN.CODE etc) that are system wide. However they have no system definition, and can be used by the user as they see fit (hence the name). Set it in one place, retrieve it somewhere else. You could *probably* (and I've never used these variables, so can't say for certain) set @USER0 with a LOCATE in the login paragraph, and then reference it in the i-descriptor, and that value would still be there - unless another user program had trashed it in the interim. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Need help with MV assoc/I-desc
I need insight from the U2 faithful. This is Unidata 7, if that affects the answer... I have a file which has 2 associated fields, such as: XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 XEM.VALUE = 23:@VM:14:@VM:99 What I'd like is a field which sorts by XEM.VALUE for the associated person querying the records. That is, if person 1737292 is selecting records it would use 23 for purposes of sorting this record. If 1818182 is selecting, it would use 14 for sorting. I've done plenty of i-descriptors both with and without subroutines, but I don't have insight as to any method of allowing the query to know who's running it. I've dreamed about WHEN...ASD but Unidata only allow this in a LIST statement and it doesn't really do what I need, even if it were allowed in a SELECT. I need the data stored as listed above, but I am open to using a database trigger to store this in some alternative form that makes the query easier to deal with - but I can't think of how this might be accomplished. Any insight is appreciated. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, one [dollar bills] are good but tens are way better. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users