Getting Error 293 When Deleting Records Of Code_mstr

[DBA_learner]

Hello All,

I am trying to delete records of code_mstr table (QAD) but getting below error message.

FOR EACH code_mstr EXCLUSIVE-LOCK:
DELETE code_mstr.
END.

Error:

** "coderd.t" was not found. (293)

I wanted to do that for loading new .d file of code_mstr table. Kindly help asap.

Regards.

 

[TomBascom]

You might want to check the QAD forum -- this probably has something to do with how they set things up.

Having said that my guess is that there is a trigger associated with that table and that as a result there is an attempt to run "coderd.t" (the ".t" strongly suggests a trigger to me) . The usual reason that that sort of thing fails s that your PROPATH does not include a path to that fragment of code.

Thus if you can find the code on disk you /could/ add the missing path to your PROPATH and it would probably work.

You could also DISABLE TRIGGERS before running your purge.

Keep in mind that I personally know very little about QAD's internals and that while the techniques above might "work" they might also have application dependent side effects.

 

[DBA_learner]

@TomBascom, thanks it works...