eld
Sent: 09 February 2008 15:48
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] by.exp when
Again. This is PRIME FLAVOR. I've tried these commands on both 9.5
and 10.2
1) SORT FILE BY.EXP CHARGE.CODE EQ "01" CHARGE.CODE TOTAL
REV.AMT 0 records selected.
2) SORT FIL
ns if you try the equivalent SQL:
SELECT CHARGE.CODE FROM UNNEST FILE ON CHARGE.CODE WHERE CHARGE.CODE = 01;
Brian
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Roger Glenfield
> Sent: 09 February 2008 15:48
> To: u2-users@lists
Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Cell 650-207-3235
Fax 650-556-9204
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, J
@listserver.u2ug.org
Subject: RE: [U2] by.exp when
Try selecting without the BY.EXP.
Jerry Banker
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 30, 2008 8:48 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] by
AM
To: u2-users@listserver.u2ug.org
Subject: [U2] by.exp when
Yes, sorry make that
001 D
002 1
003, 004 blank
005 10R
006 M
And it still doesn't work.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Try selecting without the BY.EXP.
Jerry Banker
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 30, 2008 8:48 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] by.exp when
>
> Yes, sorry make that
> 001 D
] by.exp when
Yes, sorry make that
001 D
002 1
003, 004 blank
005 10R
006 M
And it still doesn't work.
- Original Message -
From: "DAWES, Ray"
Date: Wednesday, January 30, 2008 9:07 am
Subject: RE: [U2] by.exp when
To: u2-users@listserver.u2ug.org
> Surely field 2 of the
Yes, sorry make that
001 D
002 1
003, 004 blank
005 10R
006 M
And it still doesn't work.
- Original Message -
From: "DAWES, Ray"
Date: Wednesday, January 30, 2008 9:07 am
Subject: RE: [U2] by.exp when
To: u2-users@listserver.u2ug.org
> Surely field 2 of the dictiona
Surely field 2 of the dictionary should have the location in the file -
a number.
Ray Dawes
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield
Sent: 30 January 2008 12:29
To: u2
Subject: [U2] by.exp when
Universe version 9.5
Prime Flavor
Universe version 9.5
Prime Flavor
Dictionary
CHARGE.CODE
001 D
002, 003, 004 blank
005 10R
006 M
SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ "01" finds zero records
and there are lots of records where one of the multi-values = 01
I've also tried the old Pick flavor
SORT FILE BY.EXP CHARGE
10 matches
Mail list logo