IBM Support

Include option not available for all Database items in a schema

Question & Answer


Question

Where is the include option available for Access Client Solutions (ACS) - Database feature Schema?

Answer

"Include" option is not available (grayed out) for the following features under 
ACS -> Schemas -> Expand <database name> -> Expand Schemas -> Expand any of the listed libraries.                                                 
                                                                         
All Database Objects                                                     
Column Masks                                                             
Global Variables                                                         
Journals                                                                 
Journal Receivers                                                        
Row Permissions                                                          
Sequences                                                                
SQL Packages                                                             
Types                                                                    
XML Schema Repository (XSR)                                              
                                                                         
The other listed features Aliases, Constraints, Functions, Indexes, Procedures, Tables, Triggers and Views are able to select Include.      
The icon at the upper right corner indicates if "include" option is available or not. When the icon show blueish the "Include" option is available.
image-20190513091824-1   - "Include" option not available
image-20190513091900-2   - "Include" option is available
You can check using right click on one of the items in the schema, "Include" option is grayed out or not.
The current behavior matches the previous GUI, System i Navigator (IBM i Access for Windows)
Note: IBM i Access for Windows is end of support, this is documented at https://www-01.ibm.com/support/docview.wss?uid=isg3T1026807

[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SSRQKY","label":"IBM i Access Client Solutions"},"Component":"Database","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB66","label":"Technology Lifecycle Services"}}]

Document Information

Modified date:
29 August 2022

UID

ibm10884234