Setting Catalog Manager switches

To set switches

1. From the Primary Menu panel, an object list panel, or a utility panel, on the Command line, type OPTIONS (OPT).
2. Press Enter.The Options panel is displayed.

3. In the Switches field, type Y.The Switches panel is displayed below:

                                    Switches                          1 to 14 of 14
   Command ===>                                                  Scroll ===> PAGE
                                                                                  
   Show Server. .  N   DBCS . . . . .  N   HDDL Auths . .  Y   _ Wild . . . .  Y  
   DEBUG. . . . .  N   Label. . . . .  N   Shared data. .  N   Caps . . . . .  Y  
   Cmp > 32k. . .  N   Drop . . . . .  Y   SQL flow . . .  Y   Define No. . .  N  
   Last used prof  N   Revoke BY. . .  Y   Server SSID. .  N   SQL Debug. . .  N  
                                                                                  
   SQL Ownerid. . . . . . . . . . . SQL       SQL/TSO                             
   Build SQLID before GRANT . . . . N         Y/N                                 
   Run DSN using CLIST. . . . . . . Y         Y/N                                 
   Format text for SP and FN. . . . D         Y/N/D                               
                                                                                  
   Dev debug. . . . . . . . . . . .                                               
                                                                                  
   Build unqualified DDL. . . . . . N         Y/N - TB/VW/IX DDL built unqualified

4. To change the value of a switch, type Y or N over the existing value.

   Switch	SET command	Description
   Show Server	NA	Display the current server in the upper right corner of a panel
   DEBUG (BMC.DB2.SPE2401)	DEBUG	Displays application debugging and tracing messages
   Cmp > 32k	COMPRESS	Compress HDDL SQL statements that are longer than 32 KB
   Last used prof	NA	Use the last used utility profile as the default profile
   DBCS	DBCS	Delimit DBCS data
   Label	LABEL	Use labels as the column headings when browsing SQL
   Drop	DROP	Execute SQL DROP statements
   Revoke BY	NA	Generate the BY clause of a REVOKE statement If Y, the BY clause will always be generated. If N, the BY clause will be generated only if the current SQLID has SYSADM or SYSCTRL authority. If the current SQLID does not have SYSADM or SYSCTRL authority and is not the grantor, the product issues an error message.
   HDDL Auths	NA	Include GRANT statements in HDDL output
   Shared data	NA	For a data sharing environment, send the group attachment name (SSID) to the JCL Generation component to generate utility jobs
   SQL flow	NA	Maintain original column alignment that existed in the SQL statements before substituting host variables
   Server SSID	NA	Display the first four characters of the server (instead of the SSID) in the upper left corner
   _ Wild	NA	For table lists, consider an underscore as a wildcard character if no other wildcard characters (such as % or *) are included in the qualifier
   Caps	CAPS	Translate characters in panel fields that are used to enter object names to uppercase characters
   SQL Debug (BMC.DB2.SPE2401)	SQLDEBUG	Displays SQL debugging panels
   Build SQLID before GRANT	NA	Generate a SET CURRENT SQLID = grantor statement before each GRANT statement Catalog Managergenerates these GRANT statements with the HGRANT and HDDL commands, and the REVOKE command with the Reassign Grants option.
   Use new SQL executor	NA	Consult with BMC Customer Support before changing this switch value
   Run DSN using CLIST	NA	Specifies the processing used for DSN commands BIND, REBIND, and FREE Y - Use CLIST processing for DSN commands. N - Process DSN commands using the SYSPROC.ADMIN_COMMAND_DSN stored procedure. This option is required for executing DSN commands on a remote Db2 subsystem.

5. (BMC.DB2.SPE2304)In the Define No field, type one of the following values to indicate how to include the DEFINE parameter in DDL or HDDL for a table space or index. 

   Value	Description
   Y	Never include the DEFINE NO parameter
   N	Always include the DEFINE YES parameter
   C	Generate objects based on their status in the Db2 catalog: If the SPACE attribute in the SYSIBM.SYSTABLEPART table equals -1, include the DEFINE NO parameter. If the SPACE attribute in the SYSIBM.SYSTABLEPART table is greater than or is equal to 0, do not include the DEFINE parameter.
   DY	Always include the DEFINE YES parameter
   DC	Generate objects based on their status in the Db2 catalog: If the SPACE attribute in the SYSIBM.SYSTABLEPART table equals -1, include the DEFINE NO parameter. If the SPACE attribute in the SYSIBM.SYSTABLEPART table is greater than or is equal to 0, include the DEFINE YES parameter.

6. In the SQL Ownerid field, type TSO or SQL to indicate whether the owner of the default SQL_Table member is the user’s TSO ID or SQLID.

7. In the Format text for SP and FN field, type one of the following values to specify how to format the SQL body of both procedures and functions when building DDL.

   Value	Description
   D	(Default) If Catalog Manager finds the new line (hex 15) or line feed (hex 25) character in the text, Catalog Manager assumes that the text is formatted and displays it as stored in the Db2 catalog. If neither of these characters is found, Catalog Manager formats the text before displaying it.
   Y	Catalog Managerformats the text before displaying it, regardless of whether it was already formatted.
   N	Catalog Managerdisplays the text as it is stored in the Db2 catalog, regardless of whether the text is formatted.

8. (BMC.DB2.SPE2210)In the Build DDL unqualified field, type one of the following values to override the UNQUL installation option:

   Value	Description
   N	Creates tables, indexes, or views with a qualified name. The override lasts for the current Catalog Manager session.
   Y	Creates tables, indexes, or views with the following details: Object with an unqualified name CURRENT SQLID as the owner CURRENT SCHEMA as the creator The override lasts for the current Catalog Manager session.

   Warning

   Important

   Do not enter a value in the Dev debug field. This field is for use by BMC Support only.

9. Press END to return to the Options panel.