Hi all,
Does zsecure carla support system symbols in sortlist stmts?
I know you can use system symbols in JCL (and instream data) but when carla queries aren't instream it would be nice to be able to use system symbols.


------------------------------
Luc Martens
------------------------------

Hi Luc,

There is no syntax construct to directly reference the value of a system symbol from a SORTLIST statement in general.

The values of system symbols are available via NEWLIST TYPE=SYSTEM_VARIABLE. (There are sample scripts CKADQMV and CKALQMV in SCKRCARL.)

You might generate system symbol values into a SORTLIST statement by using a query with that newlist type.

Regards,

------------------------------
Jeroen Tiggelman
Software Development and Level 3 Support Manager IBM Security zSecure Suite
IBM
Delft
------------------------------

Original Message:
Sent: Fri January 20, 2023 02:31 AM
From: Luc Martens
Subject: Use of system symbols in sortlist

Hi all,
Does zsecure carla support system symbols in sortlist stmts?
I know you can use system symbols in JCL (and instream data) but when carla queries aren't instream it would be nice to be able to use system symbols.


------------------------------
Luc Martens
------------------------------

thanks for you reply Jeroen.

------------------------------
Luc Martens
------------------------------

Original Message:
Sent: Fri January 20, 2023 07:10 AM
From: Jeroen Tiggelman
Subject: Use of system symbols in sortlist

Hi Luc,

There is no syntax construct to directly reference the value of a system symbol from a SORTLIST statement in general.

The values of system symbols are available via NEWLIST TYPE=SYSTEM_VARIABLE. (There are sample scripts CKADQMV and CKALQMV in SCKRCARL.)

You might generate system symbol values into a SORTLIST statement by using a query with that newlist type.

Regards,

------------------------------
Jeroen Tiggelman
Software Development and Level 3 Support Manager IBM Security zSecure Suite
IBM
Delft

Original Message:
Sent: Fri January 20, 2023 02:31 AM
From: Luc Martens
Subject: Use of system symbols in sortlist

Hi all,
Does zsecure carla support system symbols in sortlist stmts?
I know you can use system symbols in JCL (and instream data) but when carla queries aren't instream it would be nice to be able to use system symbols.


------------------------------
Luc Martens
------------------------------

You might be able to use the ALLOC, DEFINE or SIMULATE SENSITIVE commands in the instream data (with system symbols) to set values that you subsequently reference in your CARLa.

DEFINE TYPE=RACF LOCAL_SMFID(4,STR$BLANK('&SYSTEM')) TRUE
then use LOCAL_SMFID in your SORTLISTs.

You could even write NEWLIST NAME=xxxx OUTLIM=0 in your instream data, with a SELECT command using the resolved system symbol, that subsequent CARLa references using SELECT LIKELIST=xxxx.
Properly using system symbols in CARLa has been a requirement for many years, you could open an RFE for your use case, or find an existing RFE that you latch on to.

------------------------------
Rob van Hoboken
------------------------------

Rob, thanks for your reply.

------------------------------
Luc Martens
------------------------------

Original Message:
Sent: Mon January 23, 2023 03:31 AM
From: Rob van Hoboken
Subject: Use of system symbols in sortlist

You might be able to use the ALLOC, DEFINE or SIMULATE SENSITIVE commands in the instream data (with system symbols) to set values that you subsequently reference in your CARLa.

DEFINE TYPE=RACF LOCAL_SMFID(4,STR$BLANK('&SYSTEM')) TRUE
then use LOCAL_SMFID in your SORTLISTs.

You could even write NEWLIST NAME=xxxx OUTLIM=0 in your instream data, with a SELECT command using the resolved system symbol, that subsequent CARLa references using SELECT LIKELIST=xxxx.
Properly using system symbols in CARLa has been a requirement for many years, you could open an RFE for your use case, or find an existing RFE that you latch on to.

------------------------------
Rob van Hoboken
------------------------------