You can use an SQL editor to help you define the Select statement or a Where clause for an object. The SQL Editor is a graphical editor that lists tables, columns, objects, operators, and functions in tree views. You can double click any listed structure to insert it into the Select or Where boxes.
- number, character, and date functions.
- @Functions specific to Business Objects products.
Available functions are listed under the Functions entry in the parameters BOBJ - PRM File for the target database.
Show object SQL
When selected, the SQL syntax is displayed for the objects that appear in the Select, or Where boxes.
When clicked, parses the syntax. If the syntax is not valid, a message box appears describing the problem.