RE: API to retrieve data field contents

["mlazarus@xxxxxxxx" <mlazarus@xxxxxxxx>]

Jonathan,

 You can use the SQL DESCRIBE keyword to obtain the list of fields.  Then
you can build the SELECT statement on the fly.  Just another direction to
investigate.

 -mark

Original Message:
-----------------
From: Jonathan Mason jonathan.mason@xxxxxxxxxxxxxxxx
Date: Fri, 12 Nov 2004 14:36:31 -0000
To: rpg400-l@xxxxxxxxxxxx
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.


--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .