Change Defaults For CRTSQLRPGI?

[rckass]

We just installed V7R1M0 and I want to permanently change the default for COMMIT from *CHG to *NONE for the command. Is there a simple way to do this? I apologize if this is the wrong thread for this question. TIA

[B.Hauser]

Re: Change Defaults For CRTSQLRPGI?

It can be changed like any other command with the CL command CHGCMDDFT.
To avoid any problems in future, I'd suggest to add a SET OPTION statement at the beginning of your Source-Code (C-Specs), that overrides the compile options.

C/EXEC SQL    
C+ SET OPTION  Commit=*NONE, DatFmt=*ISO, Naming=*SYS, CLOSQLCSR=*ENDACTGRP
C/END-Exec

Birgitta

[rckass]

Re: Change Defaults For CRTSQLRPGI?

Thanks Birgitta, you're a STAR!

[tomholden]

Re: Change Defaults For CRTSQLRPGI?

another point is that if you change the command default upgrading the OS will set the defaults back to the original IBM default and you'll have to keep track of every command default you change so that you can reset them after the upgrade. using SET OPTION for SQL is the best way and for other compiles using PDM options (or user options in RSE) will be much better since you don't have to worry about the compiler defaults, you just set it and forget it

[kitvb1]

Re: Change Defaults For CRTSQLRPGI?

If you really need to change system defaults, not only for this but also for other commands e.g. message reply defaults, you could create one CL program and add all changes to this CL program. Not only do you have a log of what is changed, but when you next upgrade, you need only run this one program.