Use LIKE "...'4A'..." to prevent pattern matching -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hennessey, Mark F. Sent: 03 February 2009 21:03 To: [email protected] Subject: [U2] RE: UV - Error when using "WHEN" [not-secure]
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/ ----------------------------------------- ********************************************** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ********************************************* ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
