Re: [7.3] undo special *usrprf change

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

*cl:* *crtusrprf* deleteme;

select pase_shell_path from qsys2.user_info
where AUTHORIZATION_NAME = 'DELETEME'
;
*-- returns a dash for null*
CALL QSYS2.SET_PASE_SHELL_INFO('deleteme', '/QOpenSys/usr/bin/sh');
select pase_shell_path from qsys2.user_info
where AUTHORIZATION_NAME = 'DELETEME'
;
*-- /QOpenSys/usr/bin/sh*
CALL QSYS2.SET_PASE_SHELL_INFO('deleteme', '');
select pase_shell_path from qsys2.user_info
where AUTHORIZATION_NAME = 'DELETEME'
;
*-- returns a dash for null*
*cl:* *dltusrprf* deleteme

On Wed, Mar 12, 2025 at 7:46 AM Patrik Schindler <poc@xxxxxxxxxx> wrote:

> Hello,
>
> while slowly becoming accustomed to relatively recent PASE, I've done a
> change to my user profile which I want to undo.
>
> CALL QSYS2.SET_PASE_SHELL_INFO('myusrprf', '/QOpenSys/usr/bin/sh')
>
> I've looked into qsys2.user_info and saw that other users have
> PASE_SHELL_PATH set to NULL.
>
> Directly updating the associated PF qsys2.qsqptabl with SQL yields SQL0607
> = Operation not valid.
>
> How can I set PASE_SHELL_PATH to NULL for 'myusrprf' as it was before?
>
> Thanks!
>
> :wq! PoC
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.