To generate a declaration file in interactive mode (through a dialog box), start the Declaration Generator as described below.
               To specify the procedure from the command line, see 
               		Running From the Command Line. 
               	 
            
 
            	 
            To use the Declaration Generator utility: 
               	 
            
 
            	 
             
               		
               - From the main menu, click 
                  		  Tools > SQL Option for DB2 > Client > Declaration Generator. 
                  		
               
  
               		
               -  Provide your AUTHID and desired LOCATION if the Connect dialog box is displayed. 
                  		  
                  
You must have SELECT privileges on the table for which you are generating a declaration and on the following system tables:
                     
                     		  
                  
 
                  		  
                   
                     			 
                     - SysIBM.SYSLOCATIONS 
                        			 
                     
  
                     			 
                     -  SysIBM.SYSTABLES 
                        			 
                     
  
                     			 
                     -  SysXDB.SYSACFUsers 
                        			 
                     
  
                     		  
                  
 
                  		
                 
               		
               -  In the Declaration Generator dialog box, select the language in which you want the declaration file written, and complete
                  the remainder of the dialog box, then click 
                  		  GENERATE.