Physical File Triggers

[Daniel Wilson]

Hello ALL,

I have a question about physical file triggers. Does anyone know if there is a way to retain the trigger on a file after a recompile of the DDS has been done say to add a field to the file. I noticed that when I add a field to the DDS, and do a recompile, the file trigger(s) go bye bye and I have to go back out and add them again, a big pain!
HELP!

-Dan

[FaStOnE]

Re: Physical File Triggers

I'm not an expert by no means.. but, can't you disable the trigger before recompiling? Then enable it when the recompile is completed?

[GLS400]

Re: Physical File Triggers

Hi Dan:

I don't use triggers myself but I would think the chgpf instead of create pf would retain all atributes.

Thanks
GLS

[arrow483]

Re: Physical File Triggers

GLS400 is right! Don't recompile the file. Use CHGPF. It keeps all your LF's, triggers, etc. It will cause a new level id if you add a field.

[shahaan]

Re: Physical File Triggers

if u recompile a PF u lose all records and if u have any LF dependent it will not recreated the only option you have is chgpf, and trigger is a program u can reattach it after recompile

[DeadManWalks]

Re: Physical File Triggers

Hi, In our situation we can not use ChgPf because of change management issues. But on a good note, we can place a command on the creation of the PF that will issue the creation of the tirggers. That way when ever the file has to change the change management software knows what to do.