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

  • 1.  default setting on srvpgm

    Posted 3 days ago

    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 3 days ago

    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


  • 3.  RE: default setting on srvpgm

    Posted 2 days ago

    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 6 hours ago

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

    Original Message


  • 5.  RE: default setting on srvpgm

    Posted 4 hours ago

    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


Related Content