Re: [U2] Need help with SELECT limiting MV
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 associated with each other. In the real world, we don't use A, B and C. When a record is created, a list of desired status codes are written into the record, with some other associated valued. They might be something like Open, Reviewed, Closed, Filed with another 5 fields associated with each status code. Examples (dates, names, resolution, etc). It is important to track the details of what happened and when, so we keep the details in these associated fields. So the question really might be stated in English Give me a list of all cases that have been opened, but not yet reviewed I apologize for the confusion caused by my not giving enough information before. Noah Hart -- View this message in context: http://www.nabble.com/Need-help-with-SELECT-limiting-MV-tp22063800p22106540.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Need help with SELECT limiting MV
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 Heading Format Assoc.. Number @ID D0 U2 10L S STATUSD1 Status1L M LAYER STAT.DATE D2 D4/ Status Date 10R M LAYER LAYER PH STATUS STAT.DATE 4 records listed. And it contains:- LIST U2 LAYER 11:29:30am 20 Feb 2009 PAGE1 U2 Status Status Date R1 A 19/02/2009 B C 19/02/2009 R2 B 19/02/2009 C R3 B C 19/02/2009 3 records listed. (Sorry about wiggly columns) I tried: SELECT U2 WHEN (STATUS=B AND STAT.DATE=) but it selects ALL 3 records which is not what I expected unless the associated MVs are not associated in the SELECT process. So I cleared the selected list. I tried: LIST U2 WHEN (STATUS=B AND STAT.DATE=) LAYER and that listed the first and last records as I expected. So, my conclusion is that the LIST command uses the association but the SELECT does not. Is there a way to get the SELECT to respect the association? Or is this only resolved through programming a UniBasic executable? Jef. -- View this message in context: http://www.nabble.com/Need-help-with-SELECT-limiting-MV-tp22063800p22113739.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Need help with SELECT limiting MV
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 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 blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 Application Development Software Applications Developer/Analyst Lobel Financial -Original Message- From: 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 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 blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help with SELECT limiting MV
Ummm ... you can when Status is a multivalued field, which was described in the original post. Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Armstrong 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- U2 Family Application Development Software Applications Developer/Analyst Lobel Financial -Original Message- From: 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 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 blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help with SELECT limiting MV
Even if its multivalued, how can STATUS equal A and B at the same time? Eric Armstrong IT Dept Lobel Financial -Original Message- From: Larry Hiscock [mailto:lar...@wcs-corp.com] Sent: Wednesday, February 18, 2009 9:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with SELECT limiting MV Ummm ... you can when Status is a multivalued field, which was described in the original post. Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Armstrong 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- U2 Family Application Development Software Applications Developer/Analyst Lobel Financial -Original Message- From: 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 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 blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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) that only status of A OR B when the ST_date = were to be pulled, and not to mix vm lines, that is status and ST_Date of ,x and only ,x were to be compared. George -Original Message- 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 A and B at the same time? Eric Armstrong IT Dept Lobel Financial -Original Message- From: Larry Hiscock [mailto:lar...@wcs-corp.com] Sent: Wednesday, February 18, 2009 9:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with SELECT limiting MV Ummm ... you can when Status is a multivalued field, which was described in the original post. Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Armstrong 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- U2 Family Application Development Software Applications Developer/Analyst Lobel Financial -Original Message- From: 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 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 blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Need help with SELECT limiting MV
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 its multivalued, how can STATUS equal A and B at the same time? Eric Armstrong IT Dept Lobel Financial --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 ASSOCIATED with the B STATUS was blank. Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [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) that only status of A OR B when the ST_date = were to be pulled, and not to mix vm lines, that is status and ST_Date of ,x and only ,x were to be compared. George -Original Message- 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 A and B at the same time? Eric Armstrong IT Dept Lobel Financial -Original Message- From: Larry Hiscock [mailto:lar...@wcs-corp.com] Sent: Wednesday, February 18, 2009 9:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with SELECT limiting MV Ummm ... you can when Status is a multivalued field, which was described in the original post. Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Armstrong 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- U2 Family Application Development Software Applications Developer/Analyst Lobel Financial -Original Message- From: 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 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 blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help with SELECT limiting MV
Oh Yea...so it does. HMM (maybe...) SELECT TAB WITH WHEN STATUS = A AND STATUS=B TO 1 SELECT TAB WITH WHEN STATUS = B AND ST_DATE = TO 2 MERGE.LIST 1 UNION 2 George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] 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 ASSOCIATED with the B STATUS was blank. Larry Hiscock Western Computer Services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help with SELECT limiting MV
I haven't actually tried this...but you could create a new dictionary; e.g. 1 S 2 0 3 Status*Date 8 A;2:*:3 9 L 10 10 Then select where new dict = A*] and B* Mark -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf 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 with code B is blank --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Need help with SELECT limiting MV
How about something like: SELECT TAB WITH STATUS = A AND WITH EVAL 'IF STATUS = B THEN IF ST_DATE = THEN 1 ELSE 0 ELSE 0 ' = 1 ' HTH, Bill __ From: Noah Hart n...@lipmantpa.com Sent: 2/17/2009 10:26 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 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 blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/