How can I analyze a strategy and not get the SET CURRENT SQLID statements generated?

Document ID : KB000050028
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

I have blanks in the DEFAULT SQLID analysis option but my strategy still generates the SET CURRENT SQLID statements. I am trying to locate the parameters that control the generation of the SET CURRENT SQLID statements. The parameters that control the SET CURRENT SQLID statements are the NO SET CURRENT SQLID in the User Profile and the NO .AUTHS parameter on the Strategy Analysis Options screen.

Solution:

The SET CURRENT SQLID statements are controlled by two parameters.

The first parameter is in the User Profile.

Field: NO SET CURRENT SQLID

Description: Indicate whether you want a SET CURRENT SQLID statement generated.

Values:

  Y   The analysis output file will not
      contain SET CURRENT SQLID statements.
  
      .AUTH will contain the SQLID of the
      CREATOR ID of the object, rather than
      the CREATEDBY ID.
  
   N   (Default) Generate SET CURRENT SQLID = sqlid
       statements to set the SQLID as the CREATOR.
   
       Use the .AUTH command to preserve the
       CREATEDBY of an object.

The second parameter is in the Analysis Options of the strategy.

The parameter is NO .AUTHS and the valid settings for this parameter are:

Field: NO .AUTHS
Description: Specify whether you want to generate a dataset that has no Batch Processor .AUTH statements.

Values:

  Y          Yes - Generate no .AUTH statements. This is useful if you want
             to execute the migration, alteration, or comparison online. The
             User ID executing the strategy analysis output must have the
             authority to perform all statements. RC/Migrator might not be
             able to recreate objects exactly as they exist if this option is
             specified.
  
  N          No - Do generate .AUTH statements as needed. Note that the
             .AUTH generated for an external stored procedure will not have
             an ID specified. The submitter must have authority to do the
             CREATE, and must also have authority to issue the associated SET
             CURRENT SQLID statement, if it is requested.