An overview of NSQL's and its use in Clarity

Document ID : KB000050806
Last Modified Date : 30/08/2018
Show Technical Document Details
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.

Instructions:
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