Common Parameter: outputTables

CASL Syntax

outputTables={
groupByVarsRaw=TRUE | FALSE,
names={"string-1" <, "string-2", ...>} | {key-1={casouttable-1} <, key-2={casouttable-2}, ...>},
repeated=TRUE | FALSE,
replace=TRUE | FALSE
}

Parameter Descriptions

groupByVarsRaw=TRUE | FALSE

when set to True, uses raw instead of formatted group-by values in the CAS table.

DefaultTRUE
names={"string-1" <, "string-2", ...>} | {key-1={casouttable-1} <, key-2={casouttable-2}, ...>}

specifies the result tables to save as CAS tables on the server. By default, each created CAS table uses the same name as the result table. To use a different name, specify a casouttable value for the corresponding result table name.

caslib="string"

specifies the name of the caslib to use.

compress=TRUE | FALSE

when set to True, data compression is applied to the table.

DefaultFALSE
label="string"

specifies the descriptive label to associate with the table.

maxMemSize=64-bit-integer

specifies the maximum amount of physical memory, in bytes, to allocate for the table. After this threshold is reached, the server uses temporary files and operating system facilities for memory management.

TIPYou can enclose the value in quotation marks and specify B, K, M, G, or T as a suffix to indicate the units. For example, "8M" specifies eight megabytes.
name="table-name"

specifies the name to associate with the table.

onDemand=TRUE | FALSE

when set to True, table access is less aggressive with virtual memory use.

DefaultTRUE
promote=TRUE | FALSE

when set to True, the output table is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.

DefaultFALSE
replace=TRUE | FALSE

specifies whether to overwrite an existing table with the same name.

DefaultFALSE
replication=integer

specifies the number of copies of the table to make for fault tolerance. Larger values result in slower performance and use more memory, but provide high availability for data in the event of a node failure.

Default1
Minimum value0
timeStamp="string"

specifies the timestamp to apply to the table. Specify the value in the form that is appropriate for your session locale.

repeated=TRUE | FALSE

when set to True, replicates CAS tables on all nodes. This parameter applies to all tables.

DefaultFALSE
replace=TRUE | FALSE

when set to True, overwrites an existing CAS table of the same name. This parameter applies to all tables specified in the names parameter unless overridden by the replace parameter in individual casouttable specifications.

DefaultTRUE

Lua Syntax

outputTables={
groupByVarsRaw=true | false,
names={"string-1" <, "string-2", ...>} | {key-1={casouttable-1} <, key-2={casouttable-2}, ...>},
repeated=true | false,
replace=true | false
}

Parameter Descriptions

groupByVarsRaw=true | false

when set to True, uses raw instead of formatted group-by values in the CAS table.

Defaulttrue
names={"string-1" <, "string-2", ...>} | {key-1={casouttable-1} <, key-2={casouttable-2}, ...>}

specifies the result tables to save as CAS tables on the server. By default, each created CAS table uses the same name as the result table. To use a different name, specify a casouttable value for the corresponding result table name.

caslib="string"

specifies the name of the caslib to use.

compress=true | false

when set to True, data compression is applied to the table.

Defaultfalse
label="string"

specifies the descriptive label to associate with the table.

maxMemSize=64-bit-integer

specifies the maximum amount of physical memory, in bytes, to allocate for the table. After this threshold is reached, the server uses temporary files and operating system facilities for memory management.

TIPYou can enclose the value in quotation marks and specify B, K, M, G, or T as a suffix to indicate the units. For example, "8M" specifies eight megabytes.
name="table-name"

specifies the name to associate with the table.

onDemand=true | false

when set to True, table access is less aggressive with virtual memory use.

Defaulttrue
promote=true | false

when set to True, the output table is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.

Defaultfalse
replace=true | false

specifies whether to overwrite an existing table with the same name.

Defaultfalse
replication=integer

specifies the number of copies of the table to make for fault tolerance. Larger values result in slower performance and use more memory, but provide high availability for data in the event of a node failure.

Default1
Minimum value0
timeStamp="string"

specifies the timestamp to apply to the table. Specify the value in the form that is appropriate for your session locale.

repeated=true | false

when set to True, replicates CAS tables on all nodes. This parameter applies to all tables.

Defaultfalse
replace=true | false

when set to True, overwrites an existing CAS table of the same name. This parameter applies to all tables specified in the names parameter unless overridden by the replace parameter in individual casouttable specifications.

Defaulttrue

Python Syntax

outputTables={
"groupByVarsRaw":True | False,
"names":{"string-1" <, "string-2", ...>} | {"key-1":{casouttable-1} <, "key-2":{casouttable-2}, ...>},
"repeated":True | False,
"replace":True | False
}

Parameter Descriptions

"groupByVarsRaw":True | False

when set to True, uses raw instead of formatted group-by values in the CAS table.

DefaultTrue
"names":{"string-1" <, "string-2", ...>} | {"key-1":{casouttable-1} <, "key-2":{casouttable-2}, ...>}

specifies the result tables to save as CAS tables on the server. By default, each created CAS table uses the same name as the result table. To use a different name, specify a casouttable value for the corresponding result table name.

"caslib":"string"

specifies the name of the caslib to use.

"compress":True | False

when set to True, data compression is applied to the table.

DefaultFalse
"label":"string"

specifies the descriptive label to associate with the table.

"maxMemSize":64-bit-integer

specifies the maximum amount of physical memory, in bytes, to allocate for the table. After this threshold is reached, the server uses temporary files and operating system facilities for memory management.

TIPYou can enclose the value in quotation marks and specify B, K, M, G, or T as a suffix to indicate the units. For example, "8M" specifies eight megabytes.
"name":"table-name"

specifies the name to associate with the table.

"onDemand":True | False

when set to True, table access is less aggressive with virtual memory use.

DefaultTrue
"promote":True | False

when set to True, the output table is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.

DefaultFalse
"replace":True | False

specifies whether to overwrite an existing table with the same name.

DefaultFalse
"replication":integer

specifies the number of copies of the table to make for fault tolerance. Larger values result in slower performance and use more memory, but provide high availability for data in the event of a node failure.

Default1
Minimum value0
"timeStamp":"string"

specifies the timestamp to apply to the table. Specify the value in the form that is appropriate for your session locale.

"repeated":True | False

when set to True, replicates CAS tables on all nodes. This parameter applies to all tables.

DefaultFalse
"replace":True | False

when set to True, overwrites an existing CAS table of the same name. This parameter applies to all tables specified in the names parameter unless overridden by the replace parameter in individual casouttable specifications.

DefaultTrue