Show Table of Contents
16.3. Search Transformation SQL
The Teiid Designer provides a search capability to string values present in transformation SQL text.
To search for string values in your transformations SQL:
- Click Search > Teiid Designer > Transformations... action on the main toolbar which which opens the Search Transformations dialog.
- Specify a string segment in the Find: field and specify/change your case sensitive preference.
- Select Perform Search button. Any transformation object containing SQL text which contains occurrences of your string will be displayed in the results section.
You can select individual objects and view the SQL. If a table or view supports updates and there is insert, update or delete SQL present, you can expand the object and select the individual SQL type as shown below.
If you wish to view the selected object and its SQL in a Model Editor, you can click the Edit button. An editor will be opened if not already open. If an editor is open its tab will be selected. In addition, the Transformation Editor will be opened and you can perform Find/Replace (Ctrl-F) actions to highlight your original searched text string and edit your SQL if you wish.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.