Kishor To answer your 2 questions:
Q1) I would split the select up into two statements. The first to do the select and then the second to do the sort. Is that an option? A1) Yes, I can split the select up into to parts, I can even exclude the sort all together and I still get the same error Q2) If the Key is RECORD_ID:DATE:TIME then can't you just do a SELECT with key like '1537044...' BY Key ? A2) With a FILE that has over 1 million records and growing, this is just not an option, that is why I created the index field in the 1st place. This is a physical field on the file and not a derived one, so I can select on it. Selecting with like @ID.... Will just slow it down tremendously. The problem does not lie in the BP alone, the select etc.. Works, it lies in getting it to run trhough a I-Descriptor. Thanks for the help s far Bjorn -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of kis...@parmars.com Sent: 29 April 2009 10:51 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I-Descriptor Help Bjorn, If the Key is RECORD_ID:DATE:TIME then can't you just do a SELECT with key like '1537044...' BY Key ? Some people do index the key when they have compound keys. Regards, Kishor Quoting Bjorn Behr <be...@frstia.co.za>: > 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: be...@frstia.co.za > > > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of > kis...@parmars.com > Sent: 29 April 2009 09:46 AM > To: u2-users@listserver.u2ug.org > 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 > > Quoting Bjorn Behr <be...@frstia.co.za>: > >> Morning All >> >> I wonder if somebody can please assist me here. >> >> What I need to do is SELECT the 1st Record saved from a file >> (AUDIT.HIST) for a specific RECORD_ID. >> The RECORD_ID Field is an indexed field on AUDIT_HIST. >> >> I am trying to do this via a I-Descriptor calling a BP and it is >> returning an error >> >> Error: >> Non-SQL re-entrant query calls are not allowed. >> >> Select Statement within BP: >> "SELECT AUDIT.HIST WITH RECORD_ID = '1537044' BY RECORD_ID" >> >> Any idea how I go about doing this? >> >> System Info >> Universe 10.1.24 (PICK) >> System Builder 5.3 >> >> Regards >> Bjvrn Behr >> SUMMIT CORE Developer >> Tel No: +27 12 673 3251 >> Fax No: +27 12 673 4681 >> E-Mail: be...@frstia.co.za<mailto:be...@frstia.co.za> >> >> >> ________________________________ >> The information in or attached to this e-mail message is confidential >> and may be subject to legal privilege and client confidentiality. If >> you are not the intended recipient of this e-mail or the authorised >> representative of the recipient then please notify the sender of this >> e-mail immediately by return e-mail and delete this message from your >> system. You may not print, store, forward or copy this message or any >> part thereof or disclose or cause information in this message to be >> disclosed to any other person. >> >> FRSTIA cannot be held liable for any harm or loss resulting from >> malicious software code or viruses in this message or attachments, >> including data corruption resulting there from. >> >> Employees or representatives of FRSTIA are not permitted to send >> unsolicited messages ("spam") and FRSTIA cannot be held liable for >> their sending of such mail. If you regard this message as spam, >> please inform us immediately by sending an email to i...@frstia.co.za. >> >> If this message contains offensive, derogatory or defamatory >> statements or materials, it means the message has been sent outside >> the sender's scope of employment with FRSTIA and only the sender can >> be held liable in his/her personal capacity. >> ------- >> u2-users mailing list >> u2-users@listserver.u2ug.org >> To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > The information in or attached to this e-mail message is > confidential and may be subject to legal privilege and client > confidentiality. If you are not the intended recipient of this > e-mail or the authorised representative of the recipient then please > notify the sender of this e-mail immediately by return e-mail and > delete this message from your system. You may not print, store, > forward or copy this message or any part thereof or disclose or > cause information in this message to be disclosed to any other person. > > FRSTIA cannot be held liable for any harm or loss resulting from > malicious software code or viruses in this message or attachments, > including data corruption resulting there from. > > Employees or representatives of FRSTIA are not permitted to send > unsolicited messages ("spam") and FRSTIA cannot be held liable for > their sending of such mail. If you regard this message as spam, > please inform us immediately by sending an email to i...@frstia.co.za. > > If this message contains offensive, derogatory or defamatory > statements or materials, it means the message has been sent outside > the sender's scope of employment with FRSTIA and only the sender can > be held liable in his/her personal capacity. > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information in or attached to this e-mail message is confidential and may be subject to legal privilege and client confidentiality. If you are not the intended recipient of this e-mail or the authorised representative of the recipient then please notify the sender of this e-mail immediately by return e-mail and delete this message from your system. You may not print, store, forward or copy this message or any part thereof or disclose or cause information in this message to be disclosed to any other person. FRSTIA cannot be held liable for any harm or loss resulting from malicious software code or viruses in this message or attachments, including data corruption resulting there from. Employees or representatives of FRSTIA are not permitted to send unsolicited messages ("spam") and FRSTIA cannot be held liable for their sending of such mail. If you regard this message as spam, please inform us immediately by sending an email to i...@frstia.co.za. If this message contains offensive, derogatory or defamatory statements or materials, it means the message has been sent outside the sender's scope of employment with FRSTIA and only the sender can be held liable in his/her personal capacity. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
