: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 FILE BY.EXP CHARGE.CODE = 01 CHARGE.CODE TOTAL
REV.AMT 0
:
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@listserver.u2ug.org
Subject: Re: [U2] by.exp when
Again
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 dictionary should have the location in the file
- a number.
Ray Dawes
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.exp when
Yes, sorry make that
001 D
002 1
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
] 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 dictionary should have
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 dictionary should have the location in the
file -
a number.
Ray Dawes
Does it work with LIST instead of sort?
Also, is there a VOC item, or DICT.DICT item that is also named
CHARGE.CODE?
Mark Hennessey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2008 9:48 AM
To: