Hi Rich,
I have my CRTSQL* commands changed with the necessary settings but the create sql function that in turns creates a SRVPGM object isn't reflecting those settings. I know I can use the SET option within SQL but I was hoping to set it as a default for the system. The question is where does the create sql function pickup its defaults from?
------------------------------
Michael Cramer
------------------------------
Original Message:
Sent: Fri December 12, 2025 02:16 PM
From: Rich Malloy
Subject: default setting on srvpgm
The DYNUSRPRF setting is available to be set on various CRTSQL* commands like CRTSQLRPG and RUNSQLSTM. For anything else, I believe you have to use the SET OPTION to do what you want. Hope this helps - Rich
------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT
Original Message:
Sent: Fri December 12, 2025 01:52 PM
From: Michael Cramer
Subject: default setting on srvpgm
Hi,
In creating a sql function, I'm trying to identify which qsys cmd is used for doing that as I would like to set certain settings on the command as default. I initially looked at the runsqlstmt cmd but that doesn't seem to be used. neither does the crtsrvpgm command.
I know I can set some of these defaults from within the create sql function sql text but wanted to make it a default thru a chgdftcmd
Parms I was looking at changing are the USRPRF and DYNUSRPRF setting.
------------------------------
Michael Cramer
------------------------------