cscpiselect (Finding process instances)

Format

cscpiselect [-h]
-user login-user-ID
-pass login-password
-csc HCSC-server-name
-table
{process|activity|link|set|string|numeric|boolean
|message|relation|process_set}
[-detail]
[-separator {comma|tab}]
[{-count|-orderby sort-condition}]
[{-where where-clause
|-wherefile name-of-file-containing-where-clause
|[-processname business-process-definition-name]
[-date [inquiry-start-date-and-time],inquiry-end-date-and-time]
[-status {executing|completed|faulted|error
|executingwait|completedwait|all}]
[-targetcsc HCSC-server-name-to-be-searched]}]
[-encoding encoding-name]
[-canceltimer cancellation-time]

Function

Searches the business process information for the set up HCSC server according to specified conditions, and outputs the information in the CSV or TSV format.

By setting up default values for mandatory options, such as the login user ID, in the HCSC-Manager command definition file, you can omit the specification of these values in this command.

For details on how to use this command, see the following locations in the uCosminexus Service Platform System Setup and Operation Guide according to the purpose of use:

Arguments

-h

Displays the usage of commands. When you specify this option, all other options are ignored even if specified.

-user login-user-ID ~ <one-byte alphanumeric characters and underscores (_)> ((1 to 16 characters))

Specifies the user ID that is used to log in to HCSC-Manager.

-pass login-password ~ <one-byte alphanumeric characters and underscores (_)> ((1 to 16 characters))

Specifies the password that is used to log in to HCSC-Manager.

-csc HCSC-server-name ~ <one-byte alphanumeric characters and underscores (_)> ((1 to 8 characters))

Specifies the name of the HCSC server executing SQL statements.

-table {process|activity|link|set|string|numeric|boolean|message|relation|process_set}

Specifies the table to be searched.

When process_set is specified in this option, the process summary information and correlation set information are linked internally to perform the search. Therefore, to specify a process information column or a correlation set information column in the search condition, add P or C in the where clause respectively.

If a value other than process_set is specified in this option, the table name need not be specified in the where clause. For the information that can be specified in the where clause, see the SQL reference documentation for the database in use.

-detail

Specify this option to output all the table information.

-separator {comma|tab} ~<<comma>>

Specifies the separator for demarcating the information.

-count

Specifies that only the number of search result rows is output. Use this option to obtain only the number of searched items when the search result contains large amount of data (this corresponds to count(*) in SQL statements).

-orderby sort-condition ~ ((at least 1 character))

Specifies the data sorting condition. This corresponds to the order by clause in SQL statements. The options -orderby and -count cannot be simultaneously specified. For the information that can be specified in the order by clause, see the SQL reference documentation for the database in use. If the -orderby option is not specified, the command assumes that the order by clause is not specified.

-where where-clause ~ ((at least 1 character))

Specifies the where clause. For the information that can be specified in the where clause, see the SQL reference documentation for the database in use.

If the SplitKey string is used for search, the information about the SplitKey string is not output. Also, depending on the value specified in the -table option, you must add the SplitKey string in the view table described in the following table. For details about the view table configuration, see the explanation of the view table information in C.1 Tables for managing the process instance execution log in the uCosminexus Service Platform System Setup and Operation Guide.

Table 5-4 View table that requires the addition of the SplitKey string

Value set in the -table optionView table that requires the addition of the SplitKey string in advance
processNone
activityCSCBP_cluster-name_V_ACTIVITY
linkCSCBP_cluster-name_V_LINK
setNone
stringCSCBP_cluster-name_V_STR_VARIABLE
numericCSCBP_cluster-name_V_NUM_VARIABLE
booleanCSCBP_cluster-name_V_BOOL_VARIABLE
messageCSCBP_cluster-name_V_MSG_VARIABLE
relationNone
process_setNone

-wherefile name-of-file-containing-where-clause ~ ((1 to 200 bytes))

Specifies the name of the file containing the where clause using an absolute or relative path. The linefeed code in the specified file is replaced with spaces, and then the SQL statement is executed. For the information that can be specified, see the SQL reference documentation for the database in use.

Note that the precautions for using the SplitKey string for a search are the same as those for the -where option.

-processname business-process-definition-name ~ ((at least 1 character))

Specify this option to perform a search using the business process definition name. You can specify this option only when a value other than relation or process_set is specified in the -table option.

-date [inquiry-start-date-and-time],inquiry-end-date-and-time ~ <one-byte numeric characters>

Specify this option to search by the start date and time of a process instance. This option searches the process instances that started from the specified inquiry start date and time to the inquiry end date and time. You can specify this option only when process or activity is specified in the -table option. If the inquiry start date and time is omitted, the search is performed from the process instances that started before the inquiry end date and time. Do not place a space before or after the comma (,) separating the inquiry start date and time from the inquiry end date and time. Specify the inquiry start date and time and the inquiry end date and time in the format shown below. Make sure that you use the default time zone to specify the dates and times.

-status {executing|completed|faulted|error|executingwait|completedwait|all} ~ <<all>>

Specify this option to perform a search using the status of the process instance and activity instance.

You can only specify the arguments executing, completed, faulted, and error when process or activity is specified in the -table option. Also, you can only specify the arguments executingwait and completedwait when activity is specified in the -table option.

The following are examples of incorrect and correct settings for the -table option with an example of specifying the executingwait argument in the -status option:

Examples of settings

Example of incorrect settings: activity is not specified in the -table option
-table process -status executingwait
Example of correct settings: activity is specified in the -table option
-table activity -status executingwait

-targetcsc HCSC-server-name-to-be-searched ~ ((1 to 8 characters))

Specifies the name of the HCSC server to be searched. The process instances executed on the specified HCSC server will be searched. Note that the process instances executed in 08-70 or earlier will not be searched.

If this option is omitted, the process instances executed on all the HCSC servers will be searched.

-encoding encoding-name ~ <<Default JavaVM encoding>> ((at least 1 character))

Specifies the name of the encoding used in the input file specified in the -wherefile option. You can specify the following encoding names:

-canceltimer cancellation-time ~ ((0 to 86400)) <<0>>

This option enables you to cancel the processing if the processing does not end even after the specified time has lapsed. Specify the time until the cancellation of processing in seconds. If the -count option is specified, this option is ignored even if specified.

Examples of input

(1) To display the entire process summary information

cscpiselect -user admin -pass admin -csc HCSC -table process

(2) To display the entire summary information for the process whose correlation set definition name is rentalNumber and whose correlation set value is 100

cscpiselect -user admin -pass admin -wherefile sql_where.txt -csc HCSC -table process_set

Contents of sql_where.txt

C.CorrelationSetName = 'rentalNumber' AND C.CorrelationSetValue = '100'

(3) To display the number of rows of character strings whose business process definition name begins with BP, from the activity information

cscpiselect -user admin -pass admin -count -wherefile sql_where.txt -csc HCSC -table activity

Contents of sql_where.txt

ProcessDefinitionName like 'BP%'

(4) To search all the link information items

cscpiselect -user admin -pass admin -csc HCSC -table link

(5) To search all the correlation set information items

cscpiselect -user admin -pass admin -csc HCSC -table set

(6) To search the string variable information with the condition ProcessID = '11111'

cscpiselect -user admin -pass admin -wherefile sql_where.txt -csc HCSC -table string

Contents of sql_where.txt

ProcessID = '11111'

(7) To search the numeric variable information with the conditions ProcessID = '11111', and a business process definition name beginning with BP

cscpiselect -user admin -pass admin -wherefile sql_where.txt -csc HCSC -table numeric

Contents of sql_where.txt

ProcessID = '11111' AND ProcessDefinitionName like 'BP%'

(8) To search the boolean variable information with the conditions ProcessID = '11111', and a definition value of 0

cscpiselect -user admin -pass admin -where "ProcessID = '11111' AND VariableValue = 0" -csc HCSC -table boolean

(9) To search the message variable information with the conditions ProcessID = '11111' and the variable definition name containing ABC, and sorting the search results in the descending order of ProcessID

cscpiselect -user admin -pass admin -wherefile sql_where.txt -orderby "ProcessID DESC"-csc HCSC -table message

Contents of sql_where.txt

ProcessID = '11111' AND VariableName like '%ABC%'

(10) To search the process summary information by specifying the last executed HCSC server , and then displaying the information

cscpiselect -user admin -pass admin -csc CSCSrv1 -table process -targetcsc CSCsrv2

(11) To search the execution log generated until March 31, 2012 (however, the processing stops and the resources are released if the search takes 300 seconds or more)

cscpiselect -user admin -pass admin -csc CSCSrv1 -table process -date ,20120331235959 -canceltimer 300

Display format

(1) Process summary information (when process or process_set is specified)
  • If -detail is omitted

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,State,StartTime,EndTime,CSCServerName
    PI-identifier,business-process-definition-name,business-process-definition-version,PI-status,PI-start-time,PI-end-time,HCSC-server-name
    PI-identifier,business-process-definition-name,business-process-definition-version,PI-status,PI-start-time,PI-end-time,HCSC-server-name
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to EndTime (PI-end-time).

  • If -detail is specified

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,State,StartTime,EndTime,ChangeCount,CSCServerName
    PI-identifier,business-process-definition-name,business-process-definition-version,PI-status,PI-start-time,PI-end-time,update-count,HCSC-server-name
    PI-identifier,business-process-definition-name,business-process-definition-version,PI-status,PI-start-time,PI-end-time,update-count,HCSC-server-name
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to ChangeCount (update-count).

Description
The following table describes the information for one record in the CSCBP_cluster-name_PROCESS table. For details, see Appendix C. Information on Database Tables in the uCosminexus Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
StatePI statusIndicates the status of the process instance.
StartTimePI start timeIndicates the process instance start time (GMT).
The start time is output in the format YYYY/MM/DD hh:mm:ss that is defined as java.text.SimpleDateFormat:
  • YYYY: Year
  • MM: Month
  • DD: Date
  • hh: Hour
  • mm: Minutes
  • ss: Seconds
EndTimePI end timeIndicates the process instance end time (GMT).
The end time is output in the format YYYY/MM/DD hh:mm:ss that is defined as java.text.SimpleDateFormat:
  • YYYY: Year
  • MM: Month
  • DD: Date
  • hh: Hour
  • mm: Minutes
  • ss: Seconds
ChangeCountUpdate countIndicates the data update count.
CSCServerName#HCSC server nameIndicates the name of the last executed HCSC server.
#
If no values exist in the process instance log, nothing is displayed.

(2) Activity information (when activity is specified)
  • If -detail is omitted

    ProcessID,ActivityNumber,ActivityDefinitionName,ActivityKind,State,StartTime,EndTime,WaitTime
    PI-identifier,ACI-identifier,AC-definition-name,AC-type,ACI-status,AC-start-time,AC-end-time,AC-wait-time
    PI-identifier,ACI-identifier,AC-definition-name,AC-type,ACI-status,AC-start-time,AC-end-time,AC-wait-time
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to WaitTime (AC-wait-time).

  • If -detail is specified

    ProcessID,ActivityNumber,ProcessDefinitionName,
    ProcessDefinitionVersion,ActivityDefinitionName,ActivityKind,
    ParentNumber,ScopeNumber,RepeatNumber,State,
    FirstChildNumber,LastChildNumber,StartTime,EndTime,WaitTime,CSCServerName
    PI-identifier,ACI-identifier,business-process-definition-name,
    business-process-definition-version,AC-definition-name,AC-type
    Parent-ACI-identification-number,Subordinate-SCI-identification-number,Subordinate-RP-identification-number,ACI-status,
    First-child-ACI-identification-number,Last-child-ACI-identification-number,AC-start-time,AC-end-time,AC-wait-time,HCSC-server-name
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to CSCServerName (HCSC-server-name).

Description
The following table describes the information for one record in the CSCBP_cluster-name_ACTIVITY table. For details, see Appendix C. Information on Database Tables in the uCosminexus Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ActivityNumberACI identifierIndicates the activity instance identification number.
This is a unique value in process instances.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
ActivityDefinitionNameAC definition nameIndicates the activity definition name.
ActivityKindAC typeIndicates the activity type.
ParentNumberParent ACI identification numberIndicates the identification number of the parent activity instance.
ScopeNumberSubordinate SCI identification numberIndicates the identification number of the subordinate scope instance.
RepeatNumberSubordinate RP identification numberIndicates the identification number of the subordinate iteration processing.
StateACI statusIndicates the status of the activity instance.
FirstChildNumberFirst child ACI identification numberIndicates the identification number of the first child activity instance.
LastChildNumberLast child ACI identification numberIndicates the identification number of the last child activity instance.
StartTime#AC start timeIndicates the activity start time (GMT). The start time is output in the format YYYY/MM/DD hh:mm:ss that is defined as java.text.SimpleDateFormat:
  • YYYY: Year
  • MM: Month
  • DD: Date
  • hh: Hour
  • mm: Minutes
  • ss: Seconds
EndTime#AC end timeIndicates the activity end time (GMT). The end time is output in the format YYYY/MM/DD hh:mm:ss that is defined as java.text.SimpleDateFormat:
  • YYYY: Year
  • MM: Month
  • DD: Date
  • hh: Hour
  • mm: Minutes
  • ss: Seconds
WaitTime#AC wait timeIndicates the activity wait time (GMT). The wait time is output in the format YYYY/MM/DD hh:mm:ss that is defined as java.text.SimpleDateFormat:
  • YYYY: Year
  • MM: Month
  • DD: Date
  • hh: Hour
  • mm: Minutes
  • ss: Seconds
CSCServerName#HCSC server nameIndicates the name of the last executed HCSC server.
#
If no values exist in the process instance log, nothing is displayed.

(3) Link information (when link is specified)
  • If -detail is omitted

    ProcessID,LinkDefinitionName,State
    PI-identifier,link-definition-name,link-status
    PI-identifier,link-definition-name,link-status
    ...

  • If -detail is specified

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,
    LinkDefinitionName,RepeatNumber,State
    PI-identifier,business-process-definition-name,business-process-definition-version,
    link-definition-name,Subordinate-RP-identification-number,link-status
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to State (link-status).

Description
The following table describes the information for one record in the CSCBP_cluster-name_LINK table. For details, see Appendix C. Information on Database Tables in the uCosminexus Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
LinkDefinitionNameLink definition nameIndicates the link definition name.
RepeatNumberSubordinate RP identification numberIndicates the identification number of a subordinate iteration processing.
StateLink statusIndicates the status of the link (true value).
(4) Correlation set information (when set is specified)
  • If -detail is omitted

    ProcessID,CorrelationSetName,CorrelationSetValue
    PI-identifier,correlation-set-definition-name,correlation-set-value
    PI-identifier,correlation-set-definition-name,correlation-set-value
    ...

  • If -detail is specified

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,ScopeDefinitionName,
    ScopeNumber,CorrelationSetName,CorrelationSetValue,State
    PI-identifier,business-process-definition-name,business-process-definition-version,SC-definition-name,
    SCI-identification-number,correlation-set-definition-name,correlation-set-value,validity-of-correlation-set
    PI-identifier,business-process-definition-name,business-process-definition-version, SC-definition-name,
    SCI-identification-number,correlation-set-definition-name,correlation-set-value, validity-of-correlation-set
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to State (validity-of-correlation-set).

Description
The following table describes the information for one record in the CSCBP_cluster-name_CORRELATIONSET table. For details, see Appendix C. Information on Database Tables in the uCosminexus Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
ScopeDefinitionNameSC definition nameIndicates the scope definition name.
ScopeNumberSCI identification numberIndicates the identification number of the scope instance.
CorrelationSetNameCorrelation set definition nameIndicates the correlation set definition name.
CorrelationSetValueCorrelation set valueIndicates the correlation set value. This value is converted to a character string, linked, and then stored.
StateValidity of correlation setIndicates the validity of a correlation set (true value).
(5) String variable information (when string is specified)
  • If -detail is omitted

    ProcessID,VariableName,VariableValue
    PI-identifier,variable-definition-name,variable-value
    PI-identifier,variable-definition-name,variable-value
    ...

  • If -detail is specified

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,
    ScopeDefinitionName,ScopeNumber,VariableName,VariableValue
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name,SCI-identification-number,variable-definition-name,variable-value
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name, SCI-identification-number,variable-definition-name,variable-value
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to VariableValue (variable-value).

Description
The following table describes the information for one record in the CSCBP_cluster-name_STR_VARIABLE table. For details, see Appendix C. Information on Database Tables in the Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
ScopeDefinitionNameSC definition nameIndicates the scope definition name.
ScopeNumberSCI identification numberIndicates the identification number of the scope instance.
VariableNameVariable definition nameIndicates the variable definition name.
VariableValueVariable valueIndicates the variable value.
(6) Numeric variable information (when numeric is specified)
  • If -detail is omitted

    ProcessID,VariableName,VariableValue
    PI-identifier,variable-definition-name,variable-value
    PI-identifier,variable-definition-name,variable-value
    ...

  • If -detail is specified

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,
    ScopeDefinitionName,ScopeNumber,VariableName,VariableValue
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name,SCI-identification-number,variable-definition-name,variable-value
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name, SCI-identification-number,variable-definition-name,variable-value
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to VariableValue (variable-value).

Description
The following table describes the information for one record in the CSCBP_cluster-name_NUM_VARIABLE table. For details, see Appendix C. Information on Database Tables in the uCosminexus Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
ScopeDefinitionNameSC definition nameIndicates the scope definition name.
ScopeNumberSCI identification numberIndicates the identification number of the scope instance.
VariableNameVariable definition nameIndicates the variable definition name.
VariableValueVariable valueIndicates the variable value.
(7) Boolean variable information (when boolean is specified)
  • If -detail is omitted

    ProcessID,VariableName,VariableValue
    PI-identifier,variable-definition-name,variable-value
    PI-identifier,variable-definition-name,variable-value
    ...

  • If -detail is specified

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,
    ScopeDefinitionName,ScopeNumber,VariableName,VariableValue
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name,SCI-identification-number,variable-definition-name,variable-value
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name,SCI-identification-number,variable-definition-name,variable-value
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to VariableValue (variable-value).

Description
The following table describes the information for one record in the CSCBP_cluster-name_BOOL_VARIABLE table. For details, see Appendix C. Information on Database Tables in the Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
ScopeDefinitionNameSC definition nameIndicates the scope definition name.
ScopeNumberSCI identification numberIndicates the identification number of the scope instance.
VariableNameVariable definition nameIndicates the variable definition name.
VariableValueVariable valueIndicates the variable value.
(8) Message variable information (when message is specified)
  • If -detail is omitted

    ProcessID,VariableName,
    VariableValue
    PI-identifier,variable-definition-name,
    variable-value
    PI-identifier,variable-definition-name,
    variable-value
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to VariableName (variable-definition-name), and VariableValue (variable-value) is displayed on the next line.

  • If -detail is specified

    ProcessID,ProcessDefinitionName,ProcessDefinitionVersion,
    ScopeDefinitionName,ScopeNumber,VariableName,
    VariableValue
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name,SCI-identification-number,variable-definition-name,
    variable-value
    PI-identifier,business-process-definition-name,business-process-definition-version,
    SC-definition-name,SCI-identification-number,variable-definition-name,
    variable-value
    ...

    Note
    There is no linefeed from ProcessID (PI-identifier) to VariableName (variable-definition-name), and VariableValue (variable-value) is displayed on the next line.

Description
The following table describes the information for one record in the CSCBP_cluster-name_MSG_VARIABLE table. For details, see Appendix C. Information on Database Tables in the Service Platform System Setup and Operation Guide.
Display itemContentDescription
ProcessIDPI identifierIndicates the process instance identifier.
ProcessDefinitionNameBusiness process definition nameIndicates the business process definition name.
ProcessDefinitionVersionBusiness process definition versionIndicates the business process definition version.
ScopeDefinitionNameSC definition nameIndicates the scope definition name.
ScopeNumberSCI identification numberIndicates the identification number of the scope instance.
VariableNameVariable definition nameIndicates the variable definition name.
VariableValueVariable valueIndicates the variable value.
(9) Message-related information (when relation is specified)
  • If -detail is omitted

    MessageID,ProcessID,ActivityNumber,SendOrReceive
    MSG-identifier,PI-identifier,ACI-identification-number,send-and-receive-flag
    MSG-identifier,PI-identifier,ACI-identification-number,send-and-receive-flag
    ...

  • If -detail is specified

    MessageID,ProcessID,ActivityNumber,SendOrReceive,AsynchronousMessagingID
    MSG-identifier,PI-identifier,ACI-identification-number,send-and-receive-flag,ID
    MSG-identifier,PI-identifier,ACI-identification-number,send-and-receive-flag,ID
    ...

    Note
    There is no linefeed from MessageID (MSG-identifier) to AsynchronousMessagingID (ID).

Description
The following table describes the information for one record in the CSCBP_cluster-name_MSG_RELATION table. For details, see Appendix C. Information on Database Tables in the Service Platform System Setup and Operation Guide.
Display itemContentDescription
MessageIDMSG identifierIndicates the message identifier.
ProcessIDPI identifierIndicates the process instance identifier.
ActivityNumberACI identification numberIndicates the identification number of the activity instance.
SendOrReceiveSend and receive flagIndicates the send and receive flag for the message.
AsynchronousMessagingIDIDIndicates the ID of an asynchronous message that uses Reliable Messaging.

(10) Count display

KEOS52029-I: row count is number-of-rows

Return values

Return valueMeaning
0The command terminated normally.
1The command terminated abnormally.
2A communication timeout occurred.
3An exclusion error occurred.
9An error occurred when checking the execution permission.
10Processing will be cancelled because the specified cancellation time elapsed.

Notes