Skip to content

/AWS1/CL_ATH=>CREATENAMEDQUERY()

About CreateNamedQuery

Creates a named query in the specified workgroup. Requires that you have access to the workgroup.

Method Signature

IMPORTING

Required arguments:

IV_NAME TYPE /AWS1/ATHNAMESTRING /AWS1/ATHNAMESTRING

The query name.

IV_DATABASE TYPE /AWS1/ATHDATABASESTRING /AWS1/ATHDATABASESTRING

The database to which the query belongs.

IV_QUERYSTRING TYPE /AWS1/ATHQUERYSTRING /AWS1/ATHQUERYSTRING

The contents of the query with all query statements.

Optional arguments:

IV_DESCRIPTION TYPE /AWS1/ATHDESCRIPTIONSTRING /AWS1/ATHDESCRIPTIONSTRING

The query description.

IV_CLIENTREQUESTTOKEN TYPE /AWS1/ATHIDEMPOTENCYTOKEN /AWS1/ATHIDEMPOTENCYTOKEN

A unique case-sensitive string used to ensure the request to create the query is idempotent (executes only once). If another CreateNamedQuery request is received, the same response is returned and another query is not created. If a parameter has changed, for example, the QueryString, an error is returned.

This token is listed as not required because Amazon Web Services SDKs (for example the Amazon Web Services SDK for Java) auto-generate the token for users. If you are not using the Amazon Web Services SDK or the Amazon Web Services CLI, you must provide this token or the action will fail.

IV_WORKGROUP TYPE /AWS1/ATHWORKGROUPNAME /AWS1/ATHWORKGROUPNAME

The name of the workgroup in which the named query is being created.

RETURNING

OO_OUTPUT TYPE REF TO /AWS1/CL_ATHCRENAMEDQUERYOUT /AWS1/CL_ATHCRENAMEDQUERYOUT