PROTECTED]
Sent: Friday, September 03, 2004 6:33 PM
Subject: RE: [U2] Correlative referencing multi-value field
Allen:
For an F correlative:
First value (a number of ways but this will work):
002 9
008 F;9R
Last value:
002 9
008 F;9;P;S;_
Hope this helps.
Bill
Allen:
I specialize in working with Legacy Pick systems without SUBR's. Many are
R83-level either as Wintel native systems or Adds/Mentor/Ult/Altos. Some
have a weaker 008 CALL dict references but not as useful as SUBR's.
I even have a few Microdata clients remaining. It's funny, MCD jumped
In a message dated 9/4/2004 10:49:27 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
Not to start a deviated thread, but the value of '9' on 002 begs some
opinions. Technically, the '9' on 002 contributes nothing to 008 as 008 gets
all of its info by itself. Therefore what's on 002 is
In U2 you would again use an I-desc, with attr 2 being TRANS(FILE.NAME,
ID.TO.USE, ATTR.DESIRED, X) quotes around everything but the ID that you
would use to translate to the file. UV must have something similiar?
In answer to the question yes I would use an I-Type to TRANSlate the
, September 01, 2004 12:05 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Correlative referencing multi-value field in another
file
Hi Rod,
I too have had the 'pleasure' of F and A correlatives.
Once upon a time, a nice man named Dick Pick, who created Pick
basic, issued
a challenge. He said
The problem is not with multivalues in F correlatives.
The problem is with Translates TO multivalues in F correlatives.
In an F-correlative it replaces the multivalues with spaces.
In an I descriptor, in Universe, when you do a translate, it internally
LOWERS all system delimiter's prior to
Yes, this is the way it works, unfortunately. What we ended up doing
was to change att 8 in WO.COMP.QTY to
F;0(TWIP;X;;8);(G0 1);0(TWIP;X;;8);(G1 1);0(TWIP;X;;8);(G2
1);.;+;+;+;+ etc
-Dianne
Rod Hills wrote:
We are trying to do a very basic PICK technique of summing a multi-value
The translate returns MV data with spaces.
Dick Kryka
Director of Applications
CCCS of Greater Denver, Inc.
Paragon Financial Services
303-632-2226
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills
Sent: Wednesday, September
Hi Rod,
I assist my customers who run both UniVerse and UniData in the Pick
flavor and created the following dict item to SUM the values from another
record:
0001: I (SQL)}}NUMERIC}Y}}}
0002: SUM(TRANS('WO-BOM',F0,3,'X'))
0003: MD4
0004: Test SUM
0005: 8R
0006: S
0007:
WO List
(WO.COMP.QTY) in attr 2 of the dict. Guess UV doesn't have I desc's?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dianne Ackerman
Sent: Wednesday, September 01, 2004 08:37
To: [EMAIL PROTECTED]
Subject: Re: [U2] Correlative referencing multi-value field in another
]
Subject: RE: [U2] Correlative referencing multi-value field in another
file
Wow, in Unidata this would be an I descriptor that would just be
SUM(WO.COMP.QTY) in attr 2 of the dict. Guess UV doesn't have I desc's?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf
with a..Legacy Pick
system without SUBR's. gaa...
Allen
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rod Hills
Sent: Wednesday, September 01, 2004 11:01
To: [EMAIL PROTECTED]
Subject: RE: [U2] Correlative referencing multi-value field in another
file
12 matches
Mail list logo