S0C7 error in IMS DB

raviprasath_kp · New User Joined: 20 Feb 2005 Posts: 65 Location: chennai

hi i got soc7 error when i tried to update the record from one ims/db table to another one that time i am getting ims/db record,i fix the record
but i dont have fileaid facility

with out writing any program there is any way to delete the record
please help me

Devzee · Posted: Fri Aug 17, 2007 12:03 am

Since there is invalid numeric field in IMS DB - I would prefer not to delete the record, instead correct the invalid numeric field.

If there is invalid numeric data in IMS DB, then you can put check in your program to check for numeric. If not numeric make it zeros.

This should prevent S0c7 and correct the data while updating to another database.

raviprasath_kp · New User Joined: 20 Feb 2005 Posts: 65 Location: chennai

thanks for u r advice

actualy what i need is how to view OR update the ims/db program without writing any programs

i dont have access for ims/db fileaid

Devzee · Posted: Fri Aug 17, 2007 7:17 pm

If you dont have File Aid for IMS, then there should be some other options in your site to browse data in IMS database.

If there is no option then why not put display in the S0c7 program?