IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
#Operatingsystems
#Servers
 View Only

  • 1.  default setting on srvpgm

    Posted 12/12/25 01:53 PM

    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
    ------------------------------


  • 2.  RE: default setting on srvpgm

    Posted 12/12/25 02:16 PM

    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
    ------------------------------



  • 3.  RE: default setting on srvpgm

    Posted 12/12/25 06:05 PM

    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


  • 4.  RE: default setting on srvpgm

    Posted 12/15/25 08:20 AM

    I'd be surprised if any *CMD object had any bearing on this.

    IDK if there's anything in QAQQINI or any other related area.



    ------------------------------
    Robert Berendt IBMChampion
    Business Systems Analyst, Lead
    Dekko
    Fort Wayne
    ------------------------------



  • 5.  RE: default setting on srvpgm

    Posted 12/15/25 10:21 AM

    When creating a SQL function, the naming convention used when creating the SQL function controls if the the *SVRPGM gets USRPRF(*USER) or USRPRF(*OWNER).
    If using *SYS, the *SRVPGM is created with USRPRF(*USER)
    If using *SQL, the *SRVPGM is created with USRPRF(*OWNER)     



    ------------------------------
    Krister Karlsson
    IBM i System Administrator
    Crosskey
    Stockholm
    ------------------------------

    Original Message


  • 6.  RE: default setting on srvpgm

    Posted 12/16/25 06:17 PM

    that's good find but I have to think there's a global setting somewhere. 



    ------------------------------
    Michael Cramer
    ------------------------------

    Original Message


Related Content