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.
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',
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,
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
-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
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
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
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
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.
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.
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
: [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
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
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
...@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
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
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
, 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
, 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
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
...@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
() ; @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
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
[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
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
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
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.
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,
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
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
-
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
31 matches
Mail list logo