Remember 4A is a valid match qualifier, to look for 4 alphabetic characters. I experience this sort of behavior and had a real challenge to force it to find the values for which I was looking.
> Subject: [U2] RE: UV - Error when using "WHEN" [not-secure] > Date: Tue, 3 Feb 2009 16:03:00 -0500 > From: [email protected] > To: [email protected] > > Apologies - no one has gotten a package from me... important or > otherwise! > > > > Apparently something in my e-mail triggered our security appliance to > lock the message. Sorry! > > > > ________________________________ > > From: Hennessey, Mark F. > Sent: Tuesday, February 03, 2009 3:59 PM > To: [email protected] > Subject: UV - Error when using "WHEN" > > > > Solaris 10, UV 10.2.2, Information flavor. > > > > We are seeing some very odd behavior when trying to use SORT / WHEN on a > multi-subvalued field. And by "odd behavior" I mean totally incorrect > output... > > > > File Type: Dynamic > > File Makeup: The file contains associated multivalues and subvalues. > > Issue: When using the "when" clause with subvalued Field 7 like > '...4a..." (DISB LINE column), the only records displayed have "PDSB" in > field 7 & no records with "4A" are displayed. > > > > > > Here's part of what an unconditional SORT looks like... Notice that > OC34.UD.07 (DISB LINE) has values like 'PDSB', "4A". etc. > > > > SORT OC34UD.WORK.SP16504 OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 > OC34UD.06 OC34 > > UD.07 09:27:25 02-03-09 PAGE 1 > > LINE. > > PYE AMT ADD. RPTD. AMT SUB. > DISB > > OC34UD.KEY........ CDS TO 2a-2h 2a-2h LN 2a-2h AMT DISB > LINE > > > > 14464*19030799*2 7 10.81 REP 10.81 10.81 > PDSB > > 14683*20382253*1 3 509.00 VRC 509.00 509.00 > PDSB > > 14811*21191410*1 1 5.00 VRC 5.00 5.00 > PDSB > > 14840*21417980*1 22 21.00 REP 21.00 21.00 > PDSB > > 14859*21512820*1 1 142.04 VRC 142.04 142.04 > PDSB > > 14863*21553328*1 1 20.00 VRC 20.00 20.00 > PDSB > > 14865*700369*1 1 900.00 VRC 900.00 900.00 > PDSB > > 14869*21548157*1 7 76.14 VRC 76.14 76.14 > PDSB > > 14871*21578431*1 7 3.89 VRC 3.89 3.89 > PDSB > > 14877*21601594*1 7 76.14 VRC 76.14 76.14 > PDSB > > 14879*21653295*2 1 61.00 2E 61.00 > 4A > > 14879*21654502*1 1 78.00 2E 26.00 > 7dF > > 52.00 > 4A > > 14879*21654965*1 1 232.00 2E 232.00 > 4A > > 14884*21649378*1 1 379.17 2E 379.17 > 4A > > 14886*21700617*1 1 432.00 2E 432.00 > 4A > > > > Now when we try to limit output to just "4A": > > > > SORT OC34UD.WORK.SP16504 WHEN OC34UD.07 LIKE "...4A..." OC34UD.01 > OC34UD.02 OC3 > > 4UD.03 OC34UD.04 OC34UD.05 OC34UD.06 OC34UD.07 09:58:32 02-03-09 PAGE > 1 > > LINE. LINE. > > PYE AMT ADD. RPTD. AMT SUB. SUBTD > DISB > > OC34UD.KEY........ CDS TO 2a-2h 2a-2h LN 2a-2h 2a-2h AMT DISB > LINE > > > > 14464*19030799*2 7 10.81 REP 10.81 2F 10.81 > PDSB > > 14683*20382253*1 3 509.00 VRC 509.00 2B 509.00 > PDSB > > 14811*21191410*1 1 5.00 VRC 5.00 2H 5.00 > PDSB > > 14840*21417980*1 22 21.00 REP 21.00 2C 21.00 > PDSB > > 14859*21512820*1 1 142.04 VRC 142.04 2F 142.04 > PDSB > > > > Any ideas/thoughts are welcome... > > > > Thanks! > > > > Mark > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ _________________________________________________________________ Windows Live Hotmail.:more than just e-mail. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_explore_ 012009 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
