LIST FILE.NAME STATUS DATE
001A 02/18/2009
B
C 02/18/2009
STATUS equals A, B, and C.
There are DATEs for A and C, but not B.
-- Louie In Seattle
Yes, Louie understands the issue, I should have given an example before.
The status and dates are
It seems to me that what you want to do may be in the too hard basket.
I created a table called U2 that looks like:
DICT U211:27:33am 20 Feb 2009 Page1
Field. Type Field... Conversion.. Column. Output
Depth
Name.. Field. Definition... Code
BTW this is a 30+ year old issue and combining the fields has always been
the answer.
- Original Message -
From: Noah Hart n...@lipmantpa.com
To: u2-users@listserver.u2ug.org
Sent: Tuesday, February 17, 2009 1:26 PM
Subject: [U2] Need help with SELECT limiting MV
I have a table
: Noah Hart [mailto:n...@lipmantpa.com]
Sent: Tuesday, February 17, 2009 10:27 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Need help with SELECT limiting MV
I have a table with a MV status code and date field.
I am trying to select just those records that have both status code A
and B
, February 18, 2009 8:10 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with SELECT limiting MV
Noah,
Try SELECT TAB WITH (STATUS = A OR STATUS = B) AND ST_DATE =
You can' have status equaling A and B at the same time!
Eric Armstrong
IBM Certified Solutions Expert- U2 Family
Sent: Wednesday, February 18, 2009 8:10 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with SELECT limiting MV
Noah,
Try SELECT TAB WITH (STATUS = A OR STATUS = B) AND ST_DATE =
You can' have status equaling A and B at the same time!
Eric Armstrong
IBM Certified Solutions Expert
-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of Eric Armstrong
Sent: Wednesday, February 18, 2009 1:41 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with SELECT limiting MV
Even if its multivalued, how can STATUS equal
LIST FILE.NAME STATUS DATE
001A 02/18/2009
B
C 02/18/2009
STATUS equals A, B, and C.
There are DATEs for A and C, but not B.
-- Louie In Seattle
On Wed, Feb 18, 2009 at 10:41 AM, Eric Armstrong
earmstr...@lobelfinancial.com wrote:
Even if
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, February 18, 2009 11:40 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with SELECT limiting MV
It canit could be A @ x,1 and B @ x,2 but...
I read from the original post (between the lines
] On Behalf Of Larry Hiscock
Sent: Wednesday, February 18, 2009 3:37 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Need help with SELECT limiting MV
Nope. The original post requested a method to get a list of IDs when
both A
and B appear in the multivalued STATUS field, AND the ST_DATE value
I have a table with a MV status code and date field.
I am trying to select just those records that have both status code A
and B and when the date associated with code B is blank
I tried
SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE =
But this will select records which might have a
Of Noah Hart
Sent: Tuesday, February 17, 2009 11:27 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Need help with SELECT limiting MV
I have a table with a MV status code and date field.
I am trying to select just those records that have both status code A
and B and when the date associated
To: u2-users@listserver.u2ug.org
Subject: [U2] Need help with SELECT limiting MV
I have a table with a MV status code and date field.
I am trying to select just those records that have both status code A
and B and when the date associated with code B is blank
I tried
SELECT TAB WITH STATUS
13 matches
Mail list logo