In DB2 dialogs, a DB2 object is specified by the following:
In most controls where a DB2 resource can be entered, there will be a value-saving combo field with a small light bulb icon visible in the top left while the field is in focus and a valid subsystem has been entered. There will also be a Lookup button to the right.
Sample DB2 resource entry fields |
---|
![]() |
The light bulb icon indicates you can press Ctrl+Space to trigger the DB2 resource content assist, or resource content proposals. When the content assist is triggered, a list of DB2 table matching the text that was already entered will be displayed.
The DB2 resources retrieved will vary depending on what has been entered in both the owner and the name fields. For example, if KEEPER is entered as the owner, E is entered as the name, and Ctrl+Space is pressed while the focus is in the name field, all tables whose owners start with KEEPER and name starts with E will be shown. You can see the filters used to fetch the results by looking at the information popup displayed next to the list of results, which shows the system, subsystem, owner name filter, and table name filter used to fetch the list of results. Typing extra characters without pressing Ctrl+Space again will filter the existing list of tables.
Duplicate entries will not be displayed, and selecting one of the options will only change the text in the field which currently has focus. Continuing our previous example, if the first option is selected, then the Name field will be changed to the text of the selected option (i.e. the Owner field will not be modified in this example).
Content Assist Results |
---|
![]() |
The Lookup button shows the Lookup DB2 Object dialog. This dialog allows quick retrieval of DB2 tables from the host based on owner, name, and database patterns. The same patterns as when creating DB2 table queries apply.
To use it, click the Lookup button to the right of a table owner or name field. The Lookup DB2 Object dialog will open. The entered table owner and name will be displayed in each filter field at the top of the dialog, and the matching results will be loaded. You can modify the patterns or add a database pattern. When you select an item from the Lookup DB2 Object dialog and click OK, the selected table will be used to populate the owner and name fields on the original dialog.
Resource Lookup Dialog |
---|
![]() |