Re: [7.3] undo special *usrprf change

[Patrik Schindler <poc@xxxxxxxxxx>]

Hello Rob,

thanks a lot!

I wasn't aware that CALL for a procedure is valid in interactive SQL as well.


> Am 12.03.2025 um 17:42 schrieb 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

:wq! PoC