Getting the value of an Identity field after record creation

I have a file that is using an auto Generated identity field set as the
primary key.  ( file was created using sql create table not DDS) I do not
have a problem writing to the record.  I do however need to find a way to
get the value from the identity field so that I can then place this value
in other files to reference instead of a business key.
Here is what I have tried
I write the record and see if RPG if the identity field will be
automagically updated inside the RPG program.  This does not work (no
suprise)

create an index (logical file)  with the timestamp and a business key then
get the value of the Identity field.  This works but would like to find a
way that does not require creating an index (logical) and then chaining.


Scott Carter
214-583-0348
RSR Corporation
2777 Stemmons Frwy.
Suite 1900
Dallas, TX. 75207
www.rsrcorporation.com


************************
CONFIDENTIALITY NOTICE:

This e-mail message, including any attachments, may contain legally
privileged and/or
confidential information.  If you are not the intended recipient(s), or the
employee
or agent responsible for delivery of this message to the intended
recipient(s), any
distribution, copying, or retention of this e-mail message or any
attachments,
is strictly prohibited.  If you have received this message in error, please
immediately
notify the sender and delete this e-mail message from your system.
This e-mail does not constitute a consent to the use of sender's contact
information
for direct marketing purposes or for transfers of personal data to third
parties.