RE: API to retrieve data field contents -- RPG400-L

Johnathan,
This API doesn't really do what you want. In order to use it, you have to
already know the relative record numbers of the records you want to bring
into main storage. This only allows faster access to the reads. I would
suggest using "C" and the C Api's to access the records from either the
physical or logical or DDM file on the fly. You can write your own field
data converter using the record format and field API's for field
definitions, types and keys. You can also use RPG to read/chain to any file
based on the relative record numbers and hash the data manually using RPG
routines and the same API's. 

You could probably also use SQL, but I would think it would be phenomenally
complex and wouldn't perform well. You would be basically writing your own
SQL interpreter. 

John Brandt 
iStudio400.com 
(903) 523-0708 
Home of iS/ODBC - MSSQL access from iSeries and RPG. 




-----Original Message-----
From: Jonathan Mason [mailto:jonathan.mason@xxxxxxxxxxxxxxxx]
Sent: Friday, November 12, 2004 8:37 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: API to retrieve data field contents


Hi John

My understanding of the documentation is that I pass the API a list of
Relative Record Numbers that I want to retrieve from the physical file.
What it doesn't tell me is where the retrieved records are put, other than
"main storage".  If they came back into a user space, I could work with
that.  If the API returned an address pointer I could work with that too.  I
don't have a problem with parsing the data, I can do that, but first I have
to "find" the data.

All the best

Jonathan
www.astradyne-uk.com

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of John Brandt Sr.
Sent: 12 November 2004 14:21
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: API to retrieve data field contents


The Relative record number array that you pass to this API is the reference
to the records. This API no longer works with LF's or DDMF's, so it's a
pure reference to the relative record number. It would be up to you to
parse the data and perform any update/delete by relative record number.

John Brandt
iStudio400.com
(903) 523-0708
Home of iS/ODBC - MSSQL access from iSeries and RPG.





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.794 / Virus Database: 538 - Release Date: 11/10/04

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.792 / Virus Database: 536 - Release Date: 11/9/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.794 / Virus Database: 538 - Release Date: 11/10/04