Store the same record in the adabas file after modification

beruoist · New User Joined: 14 Nov 2007 Posts: 70 Location: mumbai

Hi,

Below is the requirement.

I need to store the same record which i am reading in the adabas file after modification of few fields.

So i am using below logical flow.

1 ) database view defined in the define data
2 ) Read the database with the key.
3 ) now update the selected fields with the required values.
4 ) Do a Store view name and end transaction.

Now the problem is the data is not getting stored in the file.

Am i missing something or bypassing anything in here ?

Please tell me if you require the code.

Thanks
Beruoist

ofer71 · Posted: Mon May 18, 2009 8:25 pm

Yes, you are missing. If you are updating an existing record, you need to use the UPDATE statement. The STORE statement is for newly added records (like INSERT in DB2).

O.

beruoist · New User Joined: 14 Nov 2007 Posts: 70 Location: mumbai

Ofer,

Actually i am updating the record,and i need to store the updated record as a new record in DB.

However i have done it.

Thanks for your reply