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 ------------------------------------------------------------------------------- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) ------------------------------------------------------------------------------- _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ************** 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