Bjorn,
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?
Kishor
Quoting Bjorn Behr <[email protected]>:
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
Quoting Bjorn Behr <[email protected]>:
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: [email protected]<mailto:[email protected]>
________________________________
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 [email protected].
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
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
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 [email protected].
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
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
