SQL Statements

You need to specify a SQL string for Data Retrieval and Key Retrieval. This string is a part of a SQL statement. The contents of the string should obey the Oracle SQL language rules.

Note

There is one deviation from the standard. You should omit the SELECT part. ITP will generate the SELECT part based on the ITP Field and parameter definitions in the Entry.

ITP does not check the syntax of the SQL statement. When ITP executes a Model, it sends the SQL statement to Oracle. Oracle will check the syntax of the SQL statement.

Generation of the SELECT part for data retrieval

ITP generates a list of columns consisting of all the Fields of the Entry. If you specified the DATABASE_FIELD attribute for an ITP Field then ITP will use this. Otherwise, ITP will use the ITP Field name.

Generation of the SELECT part for key retrieval

Conform the Key Retrieval methodology, a list of columns is generated consisting of the formal parameters, again the formal parameters and -optionally- Screen Fields. If you specified the DATABASE_FIELD attribute for a formal parameter or a Screen Field then ITP will used this. Otherwise, ITP will use the formal parameter name (for parameters) or the ITP Field name (for Screen Fields).