I meant to add what was the original selection criteria...so you could write a SQL SELECT with a join to filter out the records you want to include/exclude...
Barring a non-programming solution you have to write, here's one someone else already has written... :) -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, 15 January 2013 6:27 PM To: U2 Users List Subject: Re: [U2] [UV Retrieve] Selecting file based on partial key This may help you... https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, 15 January 2013 2:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV Retrieve] Selecting file based on partial key Dear U2 List, Is the below at all possible in universe retrieve please? I didn't think it was but there're a lot more clever people out there than I plus it's been too long since I was doing this regularly and cannot remember if it is or not. I cannot see anything obvious in the manuals. We have a file in a production environment with 5477108 records whose @ID/Key are all '9-digit-account-number':'4-digit-sequence-number'. Q. Is it possible to obtain a list of @ID's based on a separate saved list of '9-digit-account-number'? The remaining record fields are all out of scope for the selection apart from an internal date in attribute 4 but that can be interrogated later. Is it possible to construct a kind of reverse select based on my existing saved-list and pass this data into a dict item for the account number? I've tried numerous permutations of this but have yet to find the answer. Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST ACC_LIST'? How is this done on a (live) normal type 18 UV file? Of course I can always whip up some basic code to do this but it is production and getting it there will take a while. (and no I didn't design the file layout ...) Many thanks in advance. Regards, Peter ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users