HI Makesh,
may I ask you to view this artile in the online documentation under Home > Operations > PQL
Here an extract:
################
PQL or Prognosis Query Language, is a subset of the ANSI Structured Query Language (SQL), with a number of minor semantic and syntax changes to fit the Prognosis data request model. PQL remains fairly understandable to people with basic SQL knowledge.
Prognosis provides a number of ways to retrieve data. These include the Prognosis Web application, Windows Client and IRCLVIEW. While exporting a rich set of features, these data retrieval mechanisms represent a custom interface, requiring specific knowledge of the product to extract required data. The custom nature of these interfaces presents a usability issue when users try to customize and/or extend Prognosis.
Prognosis data is organized into records, each comprising a number of fields. In ANSI SQL terms, a Prognosis record can be seen as a table and each field in a Prognosis record can be seen as a column. In SQL, tables are made up of columns. A column contains a particular piece of information within a table. Each column in a table has an associated data type. A data type defines what type of data the column can contain.
##############
