6.7.33SHOW EXECUTE STATUS

#Syntax

#Description

Show (i.e. get) the status of the last executed operation.

#Parameter(s)

post_processing_option – optional option that transforms the result set according to the programmer’s needs, such as ordering or truncating (please refer to the section PROCESSING for additional information).

output_redirecting_option – optional option that specifies the cursor in use, an HDF5 object (i.e. dataset or attribute), a (text, binary, or Excel) file, or memory (i.e. user-defined variable) to write the result set into (please refer to the subsection INTO for additional information). If not specified, the cursor in use is populated with the result set instead (please refer to the chapter CURSOR for additional information).

#Return

If the keyword BY NAME is not specified, it returns the status of the last executed operation as an HDFQL_INT, which can be HDFQL_SUCCESS, HDFQL_ERROR_PARSE, HDFQL_ERROR_NOT_SPECIFIED, HDFQL_ERROR_NOT_FOUND, HDFQL_ERROR_NO_ACCESS, HDFQL_ERROR_NOT_OPEN, HDFQL_ERROR_TEMPORARILY_UNAVAILABLE, HDFQL_ERROR_INVALID_NAME, HDFQL_ERROR_INVALID_FILE, HDFQL_ERROR_NOT_SUPPORTED, HDFQL_ERROR_NOT_ENOUGH_SPACE, HDFQL_ERROR_NOT_ENOUGH_MEMORY, HDFQL_ERROR_ALREADY_EXISTS, HDFQL_ERROR_EMPTY, HDFQL_ERROR_FULL, HDFQL_ERROR_BEFORE_FIRST, HDFQL_ERROR_AFTER_LAST, HDFQL_ERROR_OUTSIDE_LIMIT, HDFQL_ERROR_NO_ADDRESS, HDFQL_ERROR_UNEXPECTED_TYPE, HDFQL_ERROR_UNEXPECTED_DATA_TYPE, HDFQL_ERROR_UNEXPECTED_STORAGE_TYPE, HDFQL_ERROR_DANGLING_LINK, HDFQL_ERROR_NOT_REGISTERED, HDFQL_ERROR_INVALID_OPERATION, HDFQL_ERROR_INVALID_REGULAR_EXPRESSION, HDFQL_ERROR_INVALID_SELECTION, or HDFQL_ERROR_UNKNOWN. Otherwise, if the keyword BY NAME is specified, it returns the status of the last executed operation as an HDFQL_VARCHAR, which can be “SUCCESS”, “ERROR_PARSE”, “ERROR_NOT_SPECIFIED”, “ERROR_NOT_FOUND”, “ERROR_NO_ACCESS”, “ERROR_NOT_OPEN”, “ERROR_TEMPORARILY_UNAVAILABLE”, “ERROR_INVALID_NAME”, “ERROR_INVALID_FILE”, “ERROR_NOT_SUPPORTED”, “ERROR_NOT_ENOUGH_SPACE”, “ERROR_NOT_ENOUGH_MEMORY”, “ERROR_ALREADY_EXISTS”, “ERROR_EMPTY”, “ERROR_FULL”, “ERROR_BEFORE_FIRST”, “ERROR_AFTER_LAST”, “ERROR_OUTSIDE_LIMIT”, “ERROR_NO_ADDRESS”, “ERROR_UNEXPECTED_TYPE”, “ERROR_UNEXPECTED_DATA_TYPE”, “ERROR_UNEXPECTED_STORAGE_TYPE”, “ERROR_DANGLING_LINK”, “ERROR_NOT_REGISTERED”, “ERROR_INVALID_OPERATION”, “ERROR_INVALID_REGULAR_EXPRESSION”, “ERROR_INVALID_SELECTION”, or “ERROR_UNKNOWN”.

#Example(s)

# show (i.e. get) working directory currently in use (this operation will succeed since it is syntactically correct)
SHOW USE DIRECTORY

# show (i.e. get) status of the last executed operation (should return 0 (i.e. HDFQL_SUCCESS))
SHOW EXECUTE STATUS

# show (i.e. get) working directory currently in use (this operation will fail since it is syntactically incorrect due to a typo in "SHOWX")
SHOWX USE DIRECTORY

# show (i.e. get) status of the last executed operation (should return -1 (i.e. HDFQL_ERROR_PARSE))
SHOW EXECUTE STATUS