Thanks Andy I will look @ the SELECTINDEX then and see what I can work out.
Bjorn -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Andy Baum Sent: 29 April 2009 10:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I-Descriptor Help Bjorn, This is the error you get when the I-Descriptor calls a subroutine that does a SELECT. See this reply from Glenn Herbert to the same problem in March 2004. "Yeah. It's actually a bug in the program/itype unloading code that won't allow you to do this. I ran upon this in May 2003 and, subsequently, put in a fix within the DataStage engine so that it works. Should be an easy fix once its understood." Guess they've not got around to fixing it yet. Dependant on the select in the subroutine it can usually be worked around by using UniBasic commands like SELECTINDEX. Cheers, Andy -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bjorn Behr Sent: 29 April 2009 08:05 To: u2-users@listserver.u2ug.org Subject: [U2] I-Descriptor Help 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/ ----------------------------------------- ********************************************** The contents of this e-mail and any attachments transmitted with it are intended to be confidential to the intended recipient; and may be privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. This e-mail is sent by a William Hill PLC group company. The William Hill group companies include, among others, William Hill PLC (registered number 4212563), William Hill Organization Limited (registered number 278208), William Hill Credit Limited (registered number 413846), WHG (International) Limited (registered number 99191) and WHG Trading Limited (registered number 101439). Each of William Hill PLC, William Hill Organization Limited and William Hill Credit Limited is registered in England and Wales and has its registered office at Greenside House, 50 Station Road, Wood Green, London N22 7TP. Each of WHG (International) Limited and WHG Trading Limited is registered in Gibraltar and has its registered office at 57/63 Line Wall Road, Gibraltar. Unless specifically indicated otherwise, the contents of this e-mail are subject to contract; and are not an official statement, and do not necessarily represent the views, of William Hill PLC, its subsidiaries or affiliated companies. Please note that neither William Hill PLC, nor its subsidiaries and affiliated companies can accept any responsibility for any viruses contained within this e-mail and it is your responsibility to scan any emails and their attachments. William Hill PLC, its subsidiaries and affiliated companies may monitor e-mail traffic data and also the content of e-mails for effective operation of the e-mail system, or for security, purposes. ********************************************* ------- 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/