Change Initial Program

15 pts.
Tags:
iSeries SQL
SQL Profiler
V5R1
how do you change the initial program and library for all user profiles preferrably using SQL.

Software/Hardware used:
iseries vr51
ASKED: August 25, 2011  5:17 PM
UPDATED: March 31, 2012  5:33 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can write a program that will read through a list of all USRORFs and do the CHGUSRPRF command
Or, since this is probably a one time deal, I would do these steps:
1. Signon with a USRPRF that has the appropate authority
2. WRKOBJPDM QSYS
3. Use F17 and make Object Type = *USRPRF
4. Put ’2′ on the first Opt line in the SFL
5. do F13
6. go down to the “Parameters or command” line and key-in INLPGM(yourlib/yourpgm)
7. ENTER — using this technique you end up hitting enter once for each USRPRF.
*
Another option is to create your own PDM option
Do steps 1,2 3
4. F16
5. F6
6. Option any calue you want. Command: “CHGUSRPRF &N INLPGM(yourlib/yourpgm)
7. ENTER
8. ENTER
9. Put the value you set for yout PDM option on the fist SLF line
10. F13
11. ENTER

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rhinopop
    Thanks Charlie. Good Stuff.
    15 pointsBadges:
    report
  • TomLiotta
    If you want to do it with SQL, you can use the SQL CALL statement to call the system QCMDEXC API to execute a CHGUSRPRF command for each user. Because QCMDEXC has no output parameters, it can be called as a stored procedure even when it is not registered to the database. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following