Hi,

Is there any way we can perform insert/update/delete operations on a database table using maintain?

I tried it using maintain for a table without primary key but i get following error

"(FOC03730) :Non-NEXT access on non-keyed segment: is/are not supported in
Maintain. "

This message has been edited. Last edited by: Kerry,

Maintain does require a key to perform the NEXT, MATCH, Update, Include, Delete and Revise commands. We rely on them so we know where in the database to put / retrieve the record.

The only way to get around this, would be to use a flat file. If you do that then you CAN do a TYPE ON DDNAME to write data to a database / file. You could also use a Master File to retrieve the information from that flat file, but even then, the Master File must have a KEYS statement.

Mark Derwin

I would have thought that you could do this in MODIFY.

Modify will support an INCLUDE for non-keyed tables, but not UPDATE or DELETE.

Logically, how does MODIFY know which instance needs to be UPDATEd or DELETEd without knowing which record to be on. The key defines that.

BY NEXTing throught the records.

I checked with IBI.
They also say that it is not possible now and there is no plan to introduce such feature in the future also