Select this to include statements that use or reference certain objects. Click Browse to select objects to include.
This field supports SQL and system names. Delimited SQL or system names can be specified with or without the enclosing SQL escape characters (double quote character). If you specify a value with enclosing SQL escape characters, you must also add escape characters to any internal double quote characters that are part of the the name. If you specify a value without the SQL escape characters, System i Navigator adds the SQL escape characters where necessary. If you specify any value that is not enclosed in SQL escape characters, and is a valid SQL ordinary identifer, the name is converted to upper case. These changes to the name are displayed.
For example:
User input | Redisplayed value |
---|---|
"The boy who cried ""wolf""" | "The boy who cried ""wolf""" |
The boy who cried "wolf" | "The boy who cried ""wolf""" |
my_table | MY_TABLE |
This field also supports wild card characters. The supported wild card characters are * and %, both of which match zero or more characters.