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.
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.
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.
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.