The result of every EVAL is (deemed to be) a string.
Try using both FMT and CONV field qualifiers. FMT for the right justification and
CONV to try to convince the query engine that it's dealing with numbers - either the
MD or the MR conversion should do it.
LIST file EVAL expression CONV MD0
9:58 PM
To: U2 Users Discussion List
Subject: RE: EVAL
The result of every EVAL is (deemed to be) a string.
Try using both FMT and CONV field qualifiers. FMT for the right
justification and CONV to try to convince the query engine that it's dealing
with numbers - either the MD or the MR conversion
LIST FILE WHEN EVAL F16 * 0.9 LT F16
-Original Message-
From: Schalk van Zyl [mailto:[EMAIL PROTECTED]
Sent: 11 March 2004 19:21
To: U2 Users Discussion List
Subject: EVAL
U2-ers,
UNIVERSE.
Can somebody help me with the syntax of EVAL. I want to execute a SELECT
on a file to get all
Hi Schalk,
Can somebody help me with the syntax of EVAL. I want to execute a SELECT
on a file to get all records where (field 16)*0.9 field(17).
Various ways to do this. Try...
SELECT file WITH EVAL F16 * 0.9 F17 = 1
where F16 and F17 are field names from the dictionary.
The most
I think you mean
LIST FILE WHEN EVAL F16 * 0.9 LT F17
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: 11 March 2004 12:40
To: 'U2 Users Discussion List'
Subject: RE: EVAL
LIST FILE WHEN EVAL F16 * 0.9 LT F16
-Original
So I do :-)
-Original Message-
From: Anthony Youngman [mailto:[EMAIL PROTECTED]
Sent: 11 March 2004 12:59
To: U2 Users Discussion List
Subject: RE: EVAL
I think you mean
LIST FILE WHEN EVAL F16 * 0.9 LT F17
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Can somebody help me with the syntax of EVAL. I want to execute a
SELECT on a file to get all records where (field 16)*0.9
field(17).
Various ways to do this. Try...
SELECT file WITH EVAL F16 * 0.9 F17 = 1
where F16 and F17 are field names from the dictionary.
The most common
Yes, single valued and Pick.
This works for me.
Thanks all.
Schalk
On Thu, 11 Mar 2004 08:30:02 -0500, Stevenson, Charles
[EMAIL PROTECTED] wrote:
Can somebody help me with the syntax of EVAL. I want to execute a
SELECT on a file to get all records where (field 16)*0.9
field(17).
Various
Is there a way to assign a justification to an EVAL item
other than having it use the justification of a field used in
the formula? I know you can assign different formatting and
conversion.
Yes, use the FMT keyword.
Brian.
Is there a way to assign a justification to an EVAL item
other than having it use the justification of a field used in
the formula? I know you can assign different formatting and
conversion.
The justification is assigned in the FMT, not independently as you do in
pick-style dictionary A-
[EMAIL PROTECTED] 03/11/2004 8:50:56 AM
Is there a way to assign a justification to an EVAL item other than having it use the
justification of a field used in the formula? I know you can assign different
formatting and conversion.
EVAL seems to use the formatting and conversion of the first
On the use of FMT to affect the justification of an EVAL field, can this be used to
affect a sort by an EVAL field? It doesn't seem to affect it when I do it in unidata.
Our company accepts no liability for the content of this email, or for the
consequences of any actions taken on the basis
LIST FILE EVAL @ID * 0.10 '9R3'
-Original Message-
From: Karjala Koponen [mailto:[EMAIL PROTECTED]
Sent: 11 March 2004 15:03
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: EVAL
[EMAIL PROTECTED] 03/11/2004 8:50:56 AM
Is there a way to assign a justification to an EVAL item
On UniVerse, the system seems to assume left-justified comparison unless
you specify something different using FMT. Try this:
SELECT ... WITH EVALF16 * 0.9 FMT10R F17
You can also specify a conversion much the same way:
SELECT ... WITH EVALF16 * 0.9 CONVMD2 FMT10R F17
Is there a way to assign
-character names would be sorted before those
with 10+ character names! The FMT clause causes it to sort as one would
expect.
Hope this helps.
Randy
-Original Message-
From: Dave Davis [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 9:23 AM
To: U2 Users Discussion List
Subject: RE
] on behalf of Randy Gill
Sent: Thu 3/11/2004 3:27 PM
To: U2 Users Discussion List
Subject: RE: EVAL
Yes, I use this feature often in UniVerse (running in PI/OPEN flavor).
Suppose I wanted to list the customers with the longest names, I would
use:
LIST CUSTOMER NAME BY.DSND EVAL LEN(NAME
Subject: RE: EVAL
Okay.
Alternately, perhaps something like this would work (again, works on
UniVerse...):
LIST CUSTOMER NAME BY.DSND EVAL FMT(LEN(NAME),'2R')
Randy
-Original Message-
From: Dave Davis [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 2:53 PM
To: U2 Users Discussion
I tried it. It didn't seem to work but maybe I didn't do it right. I did
include the [1] in there. I'm a newbie, was I not suppose to. I'm also
running this in a UNIQUERY statement at the colon prompt. Would that have
anything to do with it not running properly. Thanks for whatever light
you can
y, February 05, 2004
10:16 AMTo: U2 Users Discussion ListSubject: RE: EVAL
and LIKEI tried it. It didn't seem to work but maybe I
didn't do it right. I did include the [1] in there. I'm a newbie, was I not
suppose to. I'm also running this in a UNIQUERY statement at the colon prompt
[mailto:[EMAIL PROTECTED] On Behalf
Of Kevin MichaelsenSent: Thursday, February 05, 2004 9:16
AMTo: U2 Users Discussion ListSubject: RE: EVAL and
LIKEI tried it. It didn't seem to work but maybe I didn't
do it right. I did include the [1] in there. I'm a newbie, was I not suppos
20 matches
Mail list logo