Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

-SQLP (Native SQL stored procedures)

The -SQLP command creates and alters native SQL stored procedures.

-SQLP 000700                                  
       CREATE PROCEDURE MG017D.SPSQN017       
     (INOUT MEDSAL FLOAT                     
    )                                         
      VERSION V1                              
      DYNAMIC RESULT SETS 8                   
      LANGUAGE SQL                            
      PARAMETER CCSID ASCII                   
      NOT DETERMINISTIC                       
      CALLED ON NULL INPUT                    
      MODIFIES SQL DATA                       
      WLM ENVIRONMENT FOR DEBUG MODE AAA      
      ASUTIME LIMIT 50                        
      DISALLOW DEBUG MODE                     
      COMMIT ON RETURN NO                     
      QUALIFIER ABC                           
      PACKAGE OWNER RDAMCG                    
      SQL PATH 'RDAMCG','RDAMCG2'             
      OPTHINT 'XXX'                           
      DEFER PREPARE                           
      CURRENT DATA NO                     
      DYNAMICRULES RUN                    
      APPLICATION ENCODING SCHEME ASCII   
      WITH EXPLAIN                        
      WITH IMMEDIATE WRITE                
      WITH KEEP DYNAMIC                   
      ISOLATION LEVEL CS                  
      RELEASE AT DEALLOCATE               
      REOPT ONCE                          
      VALIDATE RUN
      APPLCOMPAT V12R1M500
      ARCHIVE SENSITIVE YES
      BUSINESS_TIME SENSITIVE YES
      SYSTEM_TIME SENSITIVE YES                        
      ROUNDING DEC_ROUND_CEILING          
      DECIMAL(15)

The following example shows an -SQLP command that adds a version to an existing native SQL stored procedure.

-SQLP 000550                                                
       ALTER PROCEDURE MG017D.SPSQN017
      ADD VERSION V1                                        
     (IN    P_PACKAGE CHAR (6) FOR SBCS DATA CCSID EBCDIC  
     , INOUT P_TS CHAR (26) FOR SBCS DATA CCSID EBCDIC    
    )                                                       
      DYNAMIC RESULT SET 1                                  
      LANGUAGE SQL

The following example shows an -SQLP command that specifies the active version of the procedure.

-SQLP 000800                                 
       ALTER PROCEDURE MG017R.SPSQN047       
      ACTIVATE VERSION V3


Related topic

Worklist-commands




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*