Re: [U2] I-type Subvalue question

2011-09-15 Thread Charles Stevenson
Likewise, late in the day, but on UniVerse, to extract the (lowered) 2nd value, instead of: TRANS('ORDERS', ORDKEY, LINES, 'X')*_; @_*1,1,2 do: TRANS('ORDERS', ORDKEY, LINES, 'X')1,1,2 Reason: Allows you to reference this I-descriptor from another I-descriptor in the future.

Re: [U2] I-type Subvalue question

2011-09-15 Thread John Thompson
Thanks for the info. Good to know. On Thu, Sep 15, 2011 at 9:38 AM, Charles Stevenson stevenson.c...@gmail.com wrote: Likewise, late in the day, but on UniVerse, to extract the (lowered) 2nd value, instead of: TRANS('ORDERS', ORDKEY, LINES, 'X')*_; @_*1,1,2 do: TRANS('ORDERS',

Re: [U2] I-type Subvalue question

2011-09-15 Thread Wols Lists
On 15/09/11 14:38, Charles Stevenson wrote: Allows you to reference this I-descriptor from another I-descriptor in the future. UV doesn't let you do that if there are multiple expressions separated by semi-colons. There is no good reason for that restriction other than internal,

Re: [U2] I-type Subvalue question

2011-09-15 Thread Woodward, Bob
Wait a minute... How do you point to the previous expression? @-1 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, September 15, 2011 9:05 AM To: U2 Users List Subject: Re: [U2] I-type

Re: [U2] I-type Subvalue question

2011-09-15 Thread Wjhonson
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, September 15, 2011 9:05 AM To: U2 Users List Subject: Re: [U2] I-type Subvalue question On 15/09/11 14:38, Charles Stevenson wrote

Re: [U2] I-type Subvalue question

2011-09-15 Thread Charles Stevenson
to the previous expression? @-1 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, September 15, 2011 9:05 AM To: U2 Users List Subject: Re: [U2] I-type Subvalue question On 15/09/11 14:38

Re: [U2] I-type Subvalue question

2011-09-14 Thread Kebbon Irwin
To: u2-users@listserver.u2ug.org Date: Tue, 13 Sep 2011 19:00:19 -0700 Subject: Re: [U2] I-type Subvalue question I use the documentation search features regularly. The main document (bkshelf.pdf) and index rely on relative structure. So, if you were to scatter the documents about your system

Re: [U2] I-type Subvalue question

2011-09-13 Thread Mecki Foerthmann
Thompson Sent: Tuesday, 13 September 2011 11:01 To: U2 Users List Subject: Re: [U2] I-type Subvalue question Therein lies my beef with the U2 docs. A million pdf's with bad search features. You guys are way faster :) On 9/12/11, Boydell, Stuartstuart.boyd...@spotless.com.au wrote: It's documented

Re: [U2] I-type Subvalue question

2011-09-13 Thread Wols Lists
On 13/09/11 02:13, Boydell, Stuart wrote: For future reference, the doc set comes with a full-text index (the .pdx file) that allows you to search (words, phrases, etc) across all the docs in the set.

Re: [U2] I-type Subvalue question

2011-09-13 Thread Boydell, Stuart
I use the documentation search features regularly. The main document (bkshelf.pdf) and index rely on relative structure. So, if you were to scatter the documents about your system at random, then it probably wouldn't work. Keep the basic structure intact and you can move them anywhere you like.

[U2] I-type Subvalue question

2011-09-12 Thread John Thompson
Lets say I need to translate over to a file and get the cost of a product. However, the cost of the product is multivalued. How can I do this with an I-type and NOT grab all of the multi values? I TRANS('PRODUCT', PRD.ID.90, '12', 'V') MR2 Cost 10R S So in attribute 12 of the PRODUCT file, I

Re: [U2] I-type Subvalue question

2011-09-12 Thread George Gallen
: [U2] I-type Subvalue question Lets say I need to translate over to a file and get the cost of a product. However, the cost of the product is multivalued. How can I do this with an I-type and NOT grab all of the multi values? I TRANS('PRODUCT', PRD.ID.90, '12', 'V') MR2 Cost 10R S So

Re: [U2] I-type Subvalue question

2011-09-12 Thread John Thompson
Subject: [U2] I-type Subvalue question Lets say I need to translate over to a file and get the cost of a product. However, the cost of the product is multivalued. How can I do this with an I-type and NOT grab all of the multi values? I TRANS('PRODUCT', PRD.ID.90, '12', 'V') MR2 Cost

Re: [U2] I-type Subvalue question

2011-09-12 Thread Caryl Lange
you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, September 12, 2011 1:23 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question I get this still... DOR 610-434

Re: [U2] I-type Subvalue question

2011-09-12 Thread John Thompson
...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, September 12, 2011 1:23 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question I get this still... DOR 610-434 0.78 0.00 0.00 0.00

Re: [U2] I-type Subvalue question

2011-09-12 Thread Garry Smith
with an old cost. Garry L. Smith Dir Info Systems -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, September 12, 2011 1:11 PM To: U2 Users List Subject: [U2] I-type Subvalue question Lets

Re: [U2] I-type Subvalue question

2011-09-12 Thread George Gallen
4:23 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question I get this still... DOR 610-434 0.78 0.00 0.00 0.00 0.53 That is a number 1 in the @1 right? On Mon

Re: [U2] I-type Subvalue question

2011-09-12 Thread George Gallen
, 2011 4:23 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question I get this still... DOR 610-434 0.78 0.00 0.00 0.00 0.53 That is a number 1 in the @1 right? On Mon

Re: [U2] I-type Subvalue question

2011-09-12 Thread Wjhonson
, Sep 12, 2011 1:26 pm Subject: Re: [U2] I-type Subvalue question No... I think you mean this? TRANS('PRODUCT', PRD.ID.90, '12', 'V'); @11.1 I also tried with 1,1 and no cigar... On Mon, Sep 12, 2011 at 4:24 PM, Caryl Lange cla...@hme.com wrote: 1.1 instead? Avante 9.1.7a/SB+ on Windows, tasty GUI

Re: [U2] I-type Subvalue question

2011-09-12 Thread John Thompson
mark, you should next RAISE the entire output-so-far. -Original Message- From: John Thompson jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Sep 12, 2011 1:26 pm Subject: Re: [U2] I-type Subvalue question No... I think you mean this? TRANS

Re: [U2] I-type Subvalue question

2011-09-12 Thread John Thompson
...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, September 12, 2011 1:23 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question I get this still... DOR 610-434 0.78 0.00

Re: [U2] I-type Subvalue question

2011-09-12 Thread George Gallen
() ; @11,1,1,1 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, September 12, 2011 4:39 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question The @11,1,1 worked. Weird... So

Re: [U2] I-type Subvalue question

2011-09-12 Thread George Gallen
Meant to say you can't do @11,1,1,1 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, September 12, 2011 4:43 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question That's right

Re: [U2] I-type Subvalue question

2011-09-12 Thread John Thompson
[mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, September 12, 2011 4:43 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question That's right...I forgot the raise() You can either use 1,1,1 and no raise() - TRANS() ; @11,1,1 Or raise

Re: [U2] I-type Subvalue question

2011-09-12 Thread Wjhonson
and then specify this locational directive. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Sep 12, 2011 1:44 pm Subject: Re: [U2] I-type Subvalue question Meant to say you can't do @11,1,1,1 -Original Message

Re: [U2] I-type Subvalue question

2011-09-12 Thread George Gallen
Subject: Re: [U2] I-type Subvalue question Yeesh. Its funny how the manual states, I-types are very similar to BASIC Hmmm Thanks for the info. On Mon, Sep 12, 2011 at 4:44 PM, George Gallen ggal...@wyanokegroup.comwrote: Meant to say you can't do @11,1,1,1 -Original Message- From

Re: [U2] I-type Subvalue question

2011-09-12 Thread Wols Lists
On 12/09/11 21:33, George Gallen wrote: Just curioustry changing the @1,1 to @1,1,1 If so, then the values are separated by @VM's but rather @SVM's I think UV *ALWAYS* does a LOWER when you trans. So it should work - if the source file has values then the transfer will have subvalues.

Re: [U2] I-type Subvalue question

2011-09-12 Thread Wols Lists
On 12/09/11 21:39, John Thompson wrote: The @11,1,1 worked. Weird... So the output is not the same as whats in the data? There's a good reason for that ... You can pass a multi-value list of id's to look up (or something like that). If it then returned several multi-valued results,

Re: [U2] I-type Subvalue question

2011-09-12 Thread Boydell, Stuart
It's documented in the basic reference manual. Look under TRANS() :) -Original Message- On Behalf Of John Thompson Sent: Tuesday, 13 September 2011 06:39 To: U2 Users List Subject: Re: [U2] I-type Subvalue question The @11,1,1 worked. Weird... So the output is not the same as whats

Re: [U2] I-type Subvalue question

2011-09-12 Thread John Thompson
Thompson Sent: Tuesday, 13 September 2011 06:39 To: U2 Users List Subject: Re: [U2] I-type Subvalue question The @11,1,1 worked. Weird... So the output is not the same as whats in the data? Be nice of them to document that :) ___ U2-Users

Re: [U2] I-type Subvalue question

2011-09-12 Thread Boydell, Stuart
- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Tuesday, 13 September 2011 11:01 To: U2 Users List Subject: Re: [U2] I-type Subvalue question Therein lies my beef with the U2 docs. A million pdf's with bad search