An overview of NSQL's and its use in Clarity

book

Article ID: 50806

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Description:

NSQL queries are read-only operations; they do not change data, they only retrieve it.

Only SELECT statements that specify which rows and columns to fetch from one or more tables are permitted. NSQL statements will fail with an error message if a statement does not start with SELECT. This means that UPDATE, INSERT, and DELETE operations cannot be performed in NSQL. NSQL should not used for reporting or for stored procedures.

Anything in the database can be used to call stored procedures.

Solution:

When you define an NSQL query, you will identify the query segments and then designate them as metric values, dimensions, dimension properties, or parameters.

With NSQL, you can access data in the Clarity database and create queries in Studio and use them to create new portlets. Since queries are not directly associated with a single portlet, the same query can be used to produce multiple portlets.



Environment

Release:
Component: STUDIO

Resolution

Please Update This Required Field

Additional Information

Please also look at:
https://communities.ca.com/thread/241811660-nsql
And the manual for NSQL
https://docops.ca.com/ca-ppm/15-4-1/en/reference/ca-ppm-studio-development/ca-ppm-studio-nsql-queries