Skip to Content

-BIND (Bind)

The -BIND command invokes the Db2 BIND command.

This command is valid under an authorization ID switch. The parameters that are used are those in the Db2 catalog.

Analysis groups BIND statements into a single -BIND command unless one of the following conditions exists:

  • The package includes a comment.
  • The worklist requires an -AUTH command.
  • The worklist requires a -SETS command.
  • The command includes 50 or more BIND statements.

Example of  -BIND command

-AUTH 000910 PAYDB
-BIND 000920 BIND  ACTION(REPLACE)          +
             RETAIN  ISOLATION(CS)          +
             VALIDATE(BIND)                 +
             PLAN(PAYROLL)                  +
             QWNER(ALUD41)                  +
             MEMBER(PAY1,PAY2)
Warning

Important

The TSO continuation character (+) is required for multiple line entries.

Example of  -BIND command with grouped BINDs

-BIND 007550 BIND   PACKAGE ( -                  
  R1BINJ +                                        
  ) -                                             
  OWNER ( -                                       
 RDACRJ +                                        
  ) -                                             
             MEMBER (R1BINJ) -                   
             SQLERROR(NOPACKAGE) -               
  QUALIFIER( -                                    
 R1BINDC +                                       
  ) -                                             
             CURRENTDATA(YES)    -               
             APREUSE(NONE)         -             
             BUSTIMESENSITIVE(YES) -             
             SYSTIMESENSITIVE(YES) -             
             ARCHIVESENSITIVE(YES) -             
             VALIDATE(RUN) ISOLATION(CS) -       
             DEGREE(ANY) -                       
             RELEASE(DEALLOCATE) EXPLAIN(NO)     
                                                
  BIND   PACKAGE ( -                              
  R1BINI +                                        
  ) -                                             
  OWNER ( -                                       
 RDACRJ +                                        
  ) -                                             
             MEMBER (R1BINI) -                   
             SQLERROR(NOPACKAGE) -               
 R1BINDC +                                    
 ) -                                          
             CURRENTDATA(YES)    -            
             APREUSE(NONE)         -          
             BUSTIMESENSITIVE(YES) -          
             SYSTIMESENSITIVE(YES) -          
             ARCHIVESENSITIVE(YES) -          
             VALIDATE(RUN) ISOLATION(CS) -    
             DEGREE(ANY) -                    
             RELEASE(DEALLOCATE) EXPLAIN(NO)  
                                            
 BIND   PACKAGE ( -                           
 R1BINH +                                     
 ) -                                          
 OWNER ( -                                    
RDACRJ +                                     
 ) -                                          
             MEMBER (R1BINH) -                
             SQLERROR(NOPACKAGE) -            
 QUALIFIER( -                                 
 R1BINDC +                                    
 ) -                                          
             CURRENTDATA(YES)    -            
             APREUSE(NONE)         -          
             BUSTIMESENSITIVE(YES) -          
             SYSTIMESENSITIVE(YES) -          
             ARCHIVESENSITIVE(YES) -          
             ROUNDING(HALFUP)    -       
             VALIDATE(RUN) ISOLATION(CS) -      
             DEGREE(ANY) -                      
             RELEASE(DEALLOCATE) EXPLAIN(NO)    


Related topic

Worklist-commands

 

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

ALTER and BMC AMI Change Manager for Db2 13.1