Entering queries

You can manually enter a SELECT statement into the Query field. You can use any valid SQL notation of the connected database to build the query.

To open the Query Designer, click Query Designer.

To look up the database schema, click Lookup Schema.

To run the query, click Execute Query.

NoteAfter you change an existing SELECT statement, always initialize the component before executing another step with the component.