GET_CONSOLE, GET_EVENT_INFO

Script Function: Reads values of occurred CONS, FILE and DB events.

Syntax

GET_CONSOLE (Keyword[, Index])
GET_EVENT_INFO (Keyword[, Index])

Syntax

Description/Format

Keyword

Specifies the message part which should be read
Format: AE name, script literal or script variable

The table shown below explains the keywords for the individual platforms

 Index

Can only be used in combination with one of the following keywords:

  • INSERT
  • RESULT1
  • RESULT2
  • MSG_DESCRIPTOR
  • MSG_LEVEL
  • MSG_MISC

Format: script literal, number or script variable.

Default value: 1

For INSERT:

Access to the 16-bit fields of an z/OS console message and access to the message text's variable part (insert) of an OS/400 message.

For RESULT1 and RESULT2:

Column number of the SQL query (database event)

Keywords

Keyword

CONS
BS2000

CONS
z/OS

CONS
OS/400

CONS
SAP
(ABAP)

CONS
SAP
(XI)

CONS SAP (Java)

CONS
Windows

FILE

FILE
automatically
z/OS

DB

ACCESS

 

 

 

 

 

 

 

 

 

ACTIVATIONSTATE

 

 

 

 

 

 

 

 

 

ALERT_OPTION

 

 

 

 

 

 

 

 

 

CATEGORY

 

 

 

 

 

 

 

 

 

CHANNEL

 

 

 

 

 

 

 

 

 

DDNAME

 

 

 

 

 

 

 

 

 
EVENT_ADDITIONAL_PARM                  

EVENT_COUNTOFJOBS

 

 

 

 

 

 

 

 

 

EVENT_GUID

 

 

 

 

 

 

 

 

 

EVENT_ID

 

 

 

 

 

 

 

EVENT_PARM

 

 

 

 

 

 

 

 

EVENT_PROCESSSTATE

 

 

 

 

 

 

 

 

 

EVENT_SERVER

 

 

 

 

 

 

 

 

 

EVENT_STATE

 

 

 

 

 

 

 

 

 
EVENT_TYPE                  

FILENAME

 

 

 

 

 

 

 

 
FILESIZE                  

ID

 

 

 

 

 

 

 

 

 

INFO_ACTION

 

 

 

 

 

 

 

 

 

INFO_TEXT

 

 

 

 

 

 

 

 

 

INSERT

 

 

 

 

 

 

 

 

INSERT_COUNT

 

 

 

 

 

 

 

 

JOB_ABENDED

 

 

 

 

 

 

 

 

 

JOB_ENDED

 

 

 

 

 

 

 

 

 

JOB_ID

 

 

 

 

 

 

 

 

JOB_NAME

 

 

 

 

 

 

 

 

LPAR_NAME

 

 

 

 

 

 

 

 

MEMGEN

 

 

 

 

 

 

 

 

 

MSG_DESCRIPTOR

 

 

 

 

 

 

 

 

 

MSG_FILE_LIBRARY

 

 

 

 

 

 

 

 

 

MSG_FILENAME

 

 

 

 

 

 

 

 

 

MSG_ID

 

 

 

 

 

 

 

 

 

MSG_KEY

 

 

 

 

 

 

 

 

 

MSG_LEVEL

 

 

 

 

 

 

 

 

 

MSG_LIBRARY_USED

 

 

 

 

 

 

 

 

 

MSG_MISC

 

 

 

 

 

 

 

 

 

MSG_SEVERITY

 

 

 

 

 

 

 

 

 

MSG_TEXT

 

 

 

 

 

 

 

MSGNR

 

 

 

 

 

 

 

 

 

MSGTYPE, MSGTYP

 

 

 

 

 

 

 

 

OS_NAME

 

 

 

 

 

 

 

 

 

PARTY

 

 

 

 

 

 

 

 

 

PROCESSID

 

 

 

 

 

 

 

 

 

PROGRAM_NAME

 

 

 

 

 

 

 

 

 

REPLY_ID

 

 

 

 

 

 

 

 

 
RESULT                  
RESULT1                  
RESULT2                  

RETCODE

 

 

 

 

 

 

 

 

 

RETCODE_STATE

 

 

 

 

 

 

 

 

 

SEND_JOB

 

 

 

 

 

 

 

 

 

SEND_JOB_NUMBER

 

 

 

 

 

 

 

 

 

SEND_USER_PROFILE

 

 

 

 

 

 

 

 

 

SERVICE

 

 

 

 

 

 

 

 

 

SMS_MANAGEMENT_CLASS
SMS_DATA_CLASS
SMS_STORAGE_CLASS

 

 

 

 

 

 

 

 

 

SOURCE

 

 

 

 

 

 

 

 

 

STATE

 

 

 

 

 

 

 

 

 

STEP_NAME

 

 

 

 

 

 

 

 

 

SYS_NAME

 

 

 

 

 

 

 

 

SYSPLEX_NAME

 

 

 

 

 

 

 

 

TIMESTAMP

 

 

TYPE

 

 

 

 

 

 

 

 

 

USER

 

 

 

 

 

 

 

 

 

Warning! Note that the keys listed in the FILE column can only be used in File Events where the Check setting equals "FILE_SIZE" or "empty" (with or without a combination of "FILE_STABLE" or "FILE_CHANGED") and "PATH_FILE_COUNT" (only in combination with "FILE_STABLE" or "FILE_CHANGED"). For more information, see FILE Events.

Description

Keyword

Description

ACCESS

File access
Allowed value:
"CLOSE" - closes the file

ACTIVATIONSTATE

Adapter status

Allowed values: "STARTED" and "STOPPED"

ALERT_OPTION

Returns if and when an SNA alert is created and sent to the message

Allowed values:
"*DEFER" - An alert is sent after local problem analysis
"*IMMED" - An alert is sent immediately when the message is sent. For the message queue, the attribute permitting alerts must be set to "*YES"
"*NO" - No alert is sent
"*UNATTEND" - An alert is only sent if the system runs in non-monitored mode. The alarm status network attribute (ALRSTS) is "*UNATTEND".

CATEGORY

Event category

CHANNEL

Communication channel

DDNAME

DD description

EVENT_ADDITIONAL_PARM Additional parameters of SAP Java Scheduler events

EVENT_COUNTOFJOBS

Number of triggered SAP jobs (ABAP)

EVENT_GUID

SAP event's instance number (ABAP)

EVENT_ID

Event ID (ABAP/Java Events)

EVENT_PARM

SAP event parameter (ABAP/Java events)

EVENT_PROCESSSTATE

SAP processing status (ABAP)

EVENT_SERVER

SAP-event server (ABAP)

EVENT_STATE

SAP event status (ABAP)

EVENT_TYPE SAP Java Scheduler event type

FILENAME

Name of the file

In File-System events with wildcards, the following value is returned as a file name: 

  • *ALL - If the option "Consider all files" has been activated.
  • *ONE - If the option "Consider all files" has been deactivated.
FILESIZE Size of the file

ID

Message ID

INFO_ACTION

Action

Allowed values: "Y" and "N"
"Y" - An object has been activated
"N" - No object has been activated

INFO_TEXT

Name of the activated object

INSERT

Accesses a certain variable part of a message together with Index

INSERT_COUNT

Determines the number of the message's variable part

JOB_ABENDED

End status of the job which closed the file

Allowed values: "Y" and "N"
"Y" - The job ended abnormally
"N" - The job ended normally

JOB_ENDED

Status of the job which closed the file

Allowed values: "Y" and "N"
"Y" - The job has already ended
"N" - The job is still running

JOB_ID

Identification name of the job

LPAR_NAME

Returns the LPAR name

JOB_NAME

Name of the job

MEMGEN

Member name or generation number

MSG_DESCRIPTOR

Description of the message as a 16-bit field

Bit 01(corresponds to  X'80')  = SYSTEM_FAILURE - system failure
Bit 02 (corresponds to X'40')  = IMMEDIATE_ACTION - immediate action required
Bit 03 (corresponds to X'20') = EVENTUAL_ACTION - eventual action required
Bit 04 (corresponds to X'10') = SYSTEM_STATUS - system status
Bit 05 (corresponds to X'08') = IMMEDIATE_COMMAND - immediate command response
Bit 06 (corresponds to X'04') = JOB_STATUS - job status
Bit 07 (corresponds to X'02') = APPLICATION - application program or processor
Bit 08 (corresponds to  X'01') = OUT_OF_LINE - out of line
Bit 09 (corresponds to  X'80') = OPERATOR_REQUEST - operator's request
Bit 10 (corresponds to  X'40') = TRACK_COMMAND_R - track command response
Bit 11 (corresponds to  X'20') = CRITICAL_ACTION - critical eventual action
Bit 12 (corresponds to  X'10') = IMPORTANT_INFO - important information
Bit 13 (corresponds to  X'08') = PREVIOUSLY_AUTO - previously automated
Bit 14 (corresponds to  X'04') - reserved
Bit 15 (corresponds to  X'02') - reserved
Bit 16 (corresponds to  X'01') -
reserved

MSG_FILE_LIBRARY

Name of the library containing the message file or the values "*CURLIB" or "*LIBL" used by the send program

MSG_FILENAME

Name of the message file which contains the obtained message

MSG_ID

Message key of the of the obtained message
This field is left blank if an improvised message is obtained

MSG_KEY

Message key of the obtained message
Four-figure value in hexadecimal format X'xxxxxxxx'

MSG_LEVEL

Urgency level of the message (16-bit field).

Bit 01(corresponds to  X'80')  = WTOR - WTOR
Bit 02 (corresponds to X'40')  = IMMEDIATE_ACTION - immediate action
Bit 03 (corresponds to X'20') = CRITICAL_ACTION - critical eventual action
Bit 04 (corresponds to X'10') = EVENTUAL_ACTION - eventual action required
Bit 05 (corresponds to X'08') = INFO - informational
Bit 06 (corresponds to X'04') = BROADCAST
Bit 07 (corresponds to X'02') - reserved
Bit 08 (corresponds to  X'01') - reserved
Bit 09 (corresponds to  X'80') - reserved
Bit 10 (corresponds to  X'40') - reserved
Bit 11 (corresponds to  X'20') - reserved
Bit 12 (corresponds to  X'10') - reserved
Bit 13 (corresponds to  X'08') - reserved
Bit 14 (corresponds to  X'04') - reserved
Bit 15 (corresponds to  X'02') - reserved
Bit 16 (corresponds to  X'01') - reserved

MSG_LIBRARY_USED

Real name of the library which is used to send the message
The library can contain overriding instructions. Thus, this is not necessarily the library in which the message is actually stored

MSG_MISC

Miscellaneous message information (16-bit field).

Bit 01(corresponds to  X'80')  = DISPLAY_UD_MSG - display UD messages
Bit 02 (corresponds to X'40')  = DISPLAY_ONLY_UD_MSG - display only UD messages
Bit 03 (corresponds to X'20') = QUEUE_BY_ID_ONLY - queue by id only
Bit 04 (corresponds to X'10') = QUEUE_BY_AUTO - queue by automation
Bit 05 (corresponds to X'08') = QUEUE_BY_HARDCOPY - queue by hard copy
Bit 06 (corresponds to X'04') - reserved
Bit 07 (corresponds to X'02') - reserved
Bit 08 (corresponds to  X'01') - reserved
Bit 09 (corresponds to  X'80') = ECHO_OPERATOR_CMD - echo operator command
Bit 10 (corresponds to  X'40') = ECHO_INTERNAL_CMD - echo internal command
Bit 11 (corresponds to  X'20') = RESULT_OF_WTL_MACRO - result of wtl macro
Bit 12 (corresponds to  X'10') - reserved
Bit 13 (corresponds to  X'08') - reserved
Bit 14 (corresponds to  X'04') - reserved
Bit 15 (corresponds to  X'02') - reserved
Bit 16 (corresponds to  X'01') - reserved

MSG_SEVERITY

Severity of the obtained message

Allowed values: "0" to "99"

MSG_TEXT

Message text (default value)

MSGNR

Message number

MSGTYPE, MSGTYP

Message type

Allowed values especially for OS/400:

"01" - Completion
"02" - Diagnostic
"04" - Informational
"05" - Inquiry
"06" - Sender's copy
"08" - Request
"10" - Request with prompting
"14" - Notify (handled exception)
"15" - Escape (handled exception)
"16" - Notify (unhandled exception)
"17" - Escape (unhandled exception)
"21" - Reply, not validity checked
"22" - Reply, validity checked
"23" - Reply, message default used
"24" - Reply, system default used
"25" - Reply, from system reply list

OS_NAME

Name of the operating system in the console message defined by IBM. Currently always "MVS"

PARTY

Partner

PROCESSID

Task number (TSN) in the console message

PROGRAM_NAME

Program description

REPLY_ID

Reply ID of the console message.

RESULT

Indicates whether the conditions of file system events with the checks FILESIZE or PATH_FILE_COUNT were fulfilled.

Allowed values: "Y" and "N"
"Y" - The condition was fulfilled
"N" -The condition was not fulfilled

RESULT1
RESULT2

RESULT1 allows access to the SQL query result for "Value 1", RESULT2 to the result for "Value 2".

In index specify the column number whose value should be read.

Warning! Note that a database event only reads the first 10 columns. Columns contents exceeding 255 characters are truncated.

The script function supplies the value " " if an attempt is made to access a non-existing column.

RETCODE

Return code of the job in converted format. For more information, see Return Codes of z/OS Jobs.

RETCODE_STATE

Filter specification for the return code

Allowed values: "Y" and "N"
"Y" - A filter has been set for the return code
"N" - The return code is not relevant for event triggering

SEND_JOB

Name of the job in which the received message was sent

SEND_JOB_NUMBER

Job number of the job which the received message was sent

SEND_USER_PROFILE

Name of the user profile which sent the received message

SERVICE

Service

SMS_MANAGEMENT_CLASS
SMS_DATA_CLASS
SMS_STORAGE_CLASS

Name of the class

SOURCE

Source of the event

STATE

Status

Allowed values:
"*"
"ERROR"
"OK"
"INACTIVE"
"UNKNOWN"
"UNREGISTERED"

STEP_NAME

Name of the job step

SYS_NAME

User-defined system name

SYSPLEX_NAME

SYSPLEX name

TIMESTAMP

Date and time of the console message

TYPE

Type of the event

Allowed values:

"I" - information
"W" - warning
"E" - error
"S" - success audit
"F" - failure audit

USER

User

The script elements GET_CONSOLE and GET_EVENT_INFO can be used to retrieve information about an occurred event. They have the same syntax.

With the script function GET_CONSOLE, message data can be retrieved when console events occur. This data consists of defined components of the console message, which can be specified with keyword. By default, this function returns the message text.

This script function can be used in the Console Event type. The console message can be read with this in BS2000 and in z/OS. In OS/400, this script function is used to receive information from a message queue. The message queue to be monitored can be specified in the INI file of the OS/400 agent. For more information, see CONS Events.

GET_EVENT_INFO can be used to read information in the scripts of File System events. Especially z/OS provides several keywords.

Platform-specific Features

  • z/OS
    The keywords MSG_DESCRIPTOR, MSG_LEVEL and MSG_MISC represent special features. They are 16-bit fields of which each individual bit has a specific meaning. Each individual bit can be queried with this script function. This can be done by giving the bit a value or a constant with Index. The value returned by this script function is "1" (bit is set) or "0" (bit is not set).

  • OS/400
    With INSERT_COUNT as the keyword, you can establish the number of variable parts of a message in a OS/400 message. With INSERT as the keyword and by specifying the Index, a specific variable part of a message can be accessed. Without Index ,the function returns the first variable part of the message.

Examples

The function GET_CONSOLE is used to retrieve the TSN of the process which triggered the event.

:SET &PROCESS_ID# = GET_CONSOLE(PROCESSID)

In the second example, first the number of the variable part of the message of a OS/400 message is determined. Then, a process loop runs in which all inserts are written in the activation report.

:SET &COUNT# = GET_CONSOLE("INSERT_COUNT")
:
SET &IDX# = 1
:
WHILE &COUNT# > 0
:   
SET &INSERT# = GET_CONSOLE("INSERT", &IDX#)
:   
SET &HELP# = FORMAT(&IDX#, "000")
:   
PRINT "INSERT[&HELP#] = '&INSERT#'"
:   
SET &IDX# = ADD(&IDX#, 1)
:   
SET &COUNT# = SUB(&COUNT#, 1)
:
ENDWHILE

The following lines are logged in the activation report:

20010110/235011.000 - U0020408 INSERT[001] = 'QPFRMON'
20010110/235011.000 - U0020408 INSERT[002] = 'QPGMR'
20010110/235011.000 - U0020408 INSERT[003] = '007982'
20010110/235011.000 - U0020408 INSERT[004] = '23:48:43'
20010110/235011.000 - U0020408 INSERT[005] = '10/01/01'
20010110/235011.000 - U0020408 INSERT[006] = '0'

In the third example, a component of the console message in z/OS is requested. Bit 03 of the keyword MSG_DESCRIPTOR is accessed. Bit 03 is given either as a value or a constant.

:SET &RET# = GET_CONSOLE("MSG_DESCRIPTOR", 3)

:SET &RET# = GET_CONSOLE("MSG_DESCRIPTOR", "EVENTUAL_ACTION")

The following example shows a script excerpt which retrieves the file name and reads the file content line by line.

:SET &FILE NAME# = GET_EVENT_INFO (FILENAME)
:
SET &HND# = PREP_PROCESS_FILE ("MVSHOST", &FILE_NAME#)

The fifth example reads the values of an SQL query (for "Value 1") in a database event.

SQL results:

Last name First name Location
Smith John Seattle

The first name is retrieved as shown below:

:SET &First name# = GET_EVENT_INFO (RESULT1, 2)

The following line supplies the location:

:SET &Location# = GET_EVENT_INFO (RESULT1, 3)

See also: