Tables Action Set: Syntax

Provides actions for accessing and managing data

partition Action

Partitions a table.

CASL Syntax

table.partition < result = results> < status= rc> /

casout={

caslib=" string",

compress=TRUE | FALSE,

label=" string",

maxMemSize= 64-bit-integer,

name=" table-name",

onDemand=TRUE | FALSE,

promote=TRUE | FALSE,

replace=TRUE | FALSE,

replication= integer,

timeStamp=" string"

}

* table={

caslib=" string",

computedOnDemand=TRUE | FALSE,

computedVars={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

computedVarsProgram=" string",

groupBy={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

groupByMode="NOSORT" | "REDISTRIBUTE",

importOptions={ fileType="AUTO" | "BASESAS" | "CSV" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "JMP" | "LASR" | "MVA" | "SPSS" | "XLS", fileType-specific-parameters},

* name=" table-name",

onDemand=TRUE | FALSE,

orderBy={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

singlePass=TRUE | FALSE,

vars={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

where=" where-expression"

}

;

Parameter Descriptions

casout={casouttable}

specifies the settings for an output table.

To simplify, you can specify only a value for the name parameter. In this case, the other parameters in the list use default values.

For more information about this common parameter, see casouttable.

Alias

outTable

* table={castable}

specifies the name of the table to use.

To simplify, you can specify only a value for the name parameter. In this case, the other parameters in the list use default values.

For more information about this common parameter, see castable.

Result Descriptions

averageShuffleWaitTime

The result is a double. You can access the value from results.averageShuffleWaitTime.

caslib

The result is a string. You can access the value from results.caslib.

maxShuffleWaitTime

The result is a double. You can access the value from results.maxShuffleWaitTime.

minShuffleWaitTime

The result is a double. You can access the value from results.minShuffleWaitTime.

rowsTransferred

The result is a 64-bit integer. You can access the value from results.rowsTransferred.

shuffleWaitTime

The result is a double. You can access the value from results.shuffleWaitTime.

tableName

The result is a string. You can access the value from results.tableName.

partition Action

Partitions a table.

Lua Syntax

results, info = s: table_partition{

casout={

caslib=" string",

compress=true | false,

label=" string",

maxMemSize= 64-bit-integer,

name=" table-name",

onDemand=true | false,

promote=true | false,

replace=true | false,

replication= integer,

timeStamp=" string"

* table={

caslib=" string",

computedOnDemand=true | false,

computedVars={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

computedVarsProgram=" string",

groupBy={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

groupByMode="NOSORT" | "REDISTRIBUTE",

importOptions={ fileType="AUTO" | "BASESAS" | "CSV" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "JMP" | "LASR" | "MVA" | "SPSS" | "XLS", fileType-specific-parameters},

* name=" table-name",

onDemand=true | false,

orderBy={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

singlePass=true | false,

vars={{

format=" string",

formattedLength= integer,

label=" string",

* name=" variable-name",

nfd= integer,

nfl= integer

}, {...}},

where=" where-expression"

}

Parameter Descriptions

casout={casouttable}

specifies the settings for an output table.

To simplify, you can specify only a value for the name parameter. In this case, the other parameters in the list use default values.

For more information about this common parameter, see casouttable.

Alias

outTable

* table={castable}

specifies the name of the table to use.

To simplify, you can specify only a value for the name parameter. In this case, the other parameters in the list use default values.

For more information about this common parameter, see castable.

Result Descriptions

averageShuffleWaitTime

The result is a double. You can access the value from results.averageShuffleWaitTime.

caslib

The result is a string. You can access the value from results.caslib.

maxShuffleWaitTime

The result is a double. You can access the value from results.maxShuffleWaitTime.

minShuffleWaitTime

The result is a double. You can access the value from results.minShuffleWaitTime.

rowsTransferred

The result is a 64-bit integer. You can access the value from results.rowsTransferred.

shuffleWaitTime

The result is a double. You can access the value from results.shuffleWaitTime.

tableName

The result is a string. You can access the value from results.tableName.

partition Action

Partitions a table.

Python Syntax

results= s. table.partition(

casout={

" caslib":" string",

" compress":True | False,

" label":" string",

" maxMemSize": 64-bit-integer,

" name":" table-name",

" onDemand":True | False,

" promote":True | False,

" replace":True | False,

" replication": integer,

" timeStamp":" string"

* table={

" caslib":" string",

" computedOnDemand":True | False,

" computedVars":[{

" format":" string",

" formattedLength": integer,

" label":" string",

* " name":" variable-name",

" nfd": integer,

" nfl": integer

}<, {...}>],

" computedVarsProgram":" string",

" groupBy":[{

" format":" string",

" formattedLength": integer,

" label":" string",

* " name":" variable-name",

" nfd": integer,

" nfl": integer

}<, {...}>],

" groupByMode":"NOSORT" | "REDISTRIBUTE",

" importOptions":{ fileType="AUTO" | "BASESAS" | "CSV" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "JMP" | "LASR" | "MVA" | "SPSS" | "XLS", fileType-specific-parameters},

* " name":" table-name",

" onDemand":True | False,

" orderBy":[{

" format":" string",

" formattedLength": integer,

" label":" string",

* " name":" variable-name",

" nfd": integer,

" nfl": integer

}<, {...}>],

" singlePass":True | False,

" vars":[{

" format":" string",

" formattedLength": integer,

" label":" string",

* " name":" variable-name",

" nfd": integer,

" nfl": integer

}<, {...}>],

" where":" where-expression"

}

)

Parameter Descriptions

casout={casouttable}

specifies the settings for an output table.

To simplify, you can specify only a value for the name parameter. In this case, the other parameters in the list use default values.

For more information about this common parameter, see casouttable.

Alias

outTable

* table={castable}

specifies the name of the table to use.

To simplify, you can specify only a value for the name parameter. In this case, the other parameters in the list use default values.

For more information about this common parameter, see castable.

Result Descriptions

averageShuffleWaitTime

The result is a double. You can access the value from results.averageShuffleWaitTime.

caslib

The result is a string. You can access the value from results.caslib.

maxShuffleWaitTime

The result is a double. You can access the value from results.maxShuffleWaitTime.

minShuffleWaitTime

The result is a double. You can access the value from results.minShuffleWaitTime.

rowsTransferred

The result is a 64-bit integer. You can access the value from results.rowsTransferred.

shuffleWaitTime

The result is a double. You can access the value from results.shuffleWaitTime.

tableName

The result is a string. You can access the value from results.tableName.