HANA CLI

Appearance

procedures ​

Command: procedures
Category: Object Inspection
Status: Production Ready

Description ​

Get a list of stored procedures for a schema and procedure name pattern.

Syntax ​

bash
hana-cli procedures [schema] [procedure] [options]

Aliases ​

  • p
  • listProcs
  • ListProc
  • listprocs
  • Listproc
  • listProcedures
  • listprocedures
  • sp

Command Diagram ​

Parameters ​

Positional Arguments ​

ParameterTypeDescription
schemastringSchema name filter (optional positional input).
procedurestringProcedure name filter (optional positional input).

Options ​

OptionAliasTypeDefaultDescription
--procedure-pstring*Procedure name pattern to match.
--schema-sstring**CURRENT_SCHEMA**Schema name or pattern to match.
--limit-lnumber200Maximum number of rows returned.
--profile-pstring-Connection profile override.

For additional shared options from the common command builder, use hana-cli procedures --help.

Examples ​

Basic Usage ​

bash
hana-cli procedures --procedure myProcedure --schema MYSCHEMA

List procedures matching the provided schema and procedure pattern.

bash
hana-cli procedures --procedure "LOAD_*" --schema MYSCHEMA

List procedures whose names start with LOAD_.

Limit Results ​

bash
hana-cli procedures --schema MYSCHEMA --limit 50

Return only the first 50 matching rows.

See Also ​