com.gpudb.protocol

Class ExecuteProcRequest.Options

java.lang.Object

com.gpudb.protocol.ExecuteProcRequest.Options

Enclosing class:

ExecuteProcRequest

public static final class ExecuteProcRequest.Options
extends Object

A set of string constants for the ExecuteProcRequest parameter options.

Optional parameters.

Field Summary

Fields

Modifier and Type	Field and Description
static String	CACHE_INPUT A comma-delimited list of table names from inputTableNames from which input data will be cached for use in subsequent calls to GPUdb.executeProc with the USE_CACHED_INPUT option.
static String	EXECUTE_AT_STARTUP If TRUE, an instance of the proc will run when the database is started instead of running immediately.
static String	EXECUTE_AT_STARTUP_AS Sets the alternate user name to execute this proc instance as when EXECUTE_AT_STARTUP is TRUE.
static String	FALSE
static String	MAX_OUTPUT_LINES The maximum number of lines of output from stdout and stderr to return via GPUdb.showProcStatus.
static String	RUN_TAG A string that, if not empty, can be used in subsequent calls to GPUdb.showProcStatus or GPUdb.killProc to identify the proc instance.
static String	TRUE
static String	USE_CACHED_INPUT A comma-delimited list of run IDs (as returned from prior calls to GPUdb.executeProc) of running or completed proc instances from which input data cached using the CACHE_INPUT option will be used.

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CACHE_INPUT

public static final String CACHE_INPUT

A comma-delimited list of table names from inputTableNames from which input data will be cached for use in subsequent calls to GPUdb.executeProc with the USE_CACHED_INPUT option. Cached input data will be retained until the proc status is cleared with the clear_complete option of GPUdb.showProcStatus and all proc instances using the cached data have completed. The default value is ''.

See Also:

Constant Field Values

USE_CACHED_INPUT

public static final String USE_CACHED_INPUT

A comma-delimited list of run IDs (as returned from prior calls to GPUdb.executeProc) of running or completed proc instances from which input data cached using the CACHE_INPUT option will be used. Cached input data will not be used for any tables specified in inputTableNames, but data from all other tables cached for the specified run IDs will be passed to the proc. If the same table was cached for multiple specified run IDs, the cached data from the first run ID specified in the list that includes that table will be used. The default value is ''.

See Also:

Constant Field Values

RUN_TAG

public static final String RUN_TAG

A string that, if not empty, can be used in subsequent calls to GPUdb.showProcStatus or GPUdb.killProc to identify the proc instance. The default value is ''.

See Also:

Constant Field Values

MAX_OUTPUT_LINES

public static final String MAX_OUTPUT_LINES

The maximum number of lines of output from stdout and stderr to return via GPUdb.showProcStatus. If the number of lines output exceeds the maximum, earlier lines are discarded. The default value is '100'.

See Also:

Constant Field Values

EXECUTE_AT_STARTUP

public static final String EXECUTE_AT_STARTUP

If TRUE, an instance of the proc will run when the database is started instead of running immediately. The runId can be retrieved using GPUdb.showProc and used in GPUdb.showProcStatus. Supported values:

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

TRUE

public static final String TRUE

See Also:

Constant Field Values

FALSE

public static final String FALSE

See Also:

Constant Field Values

EXECUTE_AT_STARTUP_AS

public static final String EXECUTE_AT_STARTUP_AS

Sets the alternate user name to execute this proc instance as when EXECUTE_AT_STARTUP is TRUE. The default value is ''.

See Also:

Constant Field Values