Tables Action Set: Syntax

Provides actions for accessing and managing data

recordCount Action

Shows the number of rows in a Cloud Analytic Services table.

CASL Syntax

table.recordCount < result = results> < status= rc> /
groupByLimit= 64-bit-integer
* 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

groupByLimit=64-bit-integer

specifies the maximum number of levels in a group-by set. When the server determines this number of levels, the server stops and does not return a result. Specify this parameter if you want to avoid creating large result sets in group-by operations.

* table={castable}

specifies the table name, caslib, and other common parameters.

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.

recordCount Action

Shows the number of rows in a Cloud Analytic Services table.

Lua Syntax

results, info = s: table_recordCount{
groupByLimit= 64-bit-integer,
* 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

groupByLimit=64-bit-integer

specifies the maximum number of levels in a group-by set. When the server determines this number of levels, the server stops and does not return a result. Specify this parameter if you want to avoid creating large result sets in group-by operations.

* table={castable}

specifies the table name, caslib, and other common parameters.

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.

recordCount Action

Shows the number of rows in a Cloud Analytic Services table.

Python Syntax

results= s. table.recordCount(
groupByLimit= 64-bit-integer,
* 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

groupByLimit=64-bit-integer

specifies the maximum number of levels in a group-by set. When the server determines this number of levels, the server stops and does not return a result. Specify this parameter if you want to avoid creating large result sets in group-by operations.

* table={castable}

specifies the table name, caslib, and other common parameters.

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.