Bjorn Executing queries via an I-type simply doesn't work or if it does - you'll get strange results.
Your requirements are a little unclear...but I am guessing here that you're wanting to select the first timestamped record by the specified unique RECORD_ID? Do you have I-types for the Date and Time elements of the @ID - if so, you could: SELECT AUDIT_HIST WITH RECORD_ID = '1234' BY DATE BY TIME FIRST 1 Or something similar - any particular reason you need to have an I-type? Regards David -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bjorn Behr Sent: Wednesday, 29 April 2009 6:05 PM To: [email protected] Subject: RE: [U2] I-Descriptor Help Kishor Sorry, should not be BY RECORD_ID, should be BY @ID The key is RECORD_ID:DATE:TIME, RECORD_ID is in Field <1> in the record and refers the the @ID of another file There can be many RECORDS in the AUDIT.HIST File with the same RECORD_ID, but there DATE and/or TIME will differ. Regards Bjvrn Behr SUMMIT CORE Developer Tel No: +27 12 673 3251 Fax No: +27 12 673 4681 E-Mail: [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: 29 April 2009 09:46 AM To: [email protected] Subject: Re: [U2] I-Descriptor Help Hi Bjorn, Why are you using the BY RECORD_ID clause when you are selecting on RECORD_ID = '1537044' ? Should this be @ID for the first record on the AUDIT_HIST file? Regards, Kishor ************** 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/
