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/
