.logon ampd/sysdba,madcow;


                                                                  
.set defaults                                                     
.set format off                                                   
.set foldline off all                                             
.set sidetitles off                                               
.set width 800                                                    
                                                                  
.export report file=C:\Vindoc\UTILITY\GenDDL\Scripts\GenScript.Bat           
                                                                  
SELECT                                                            
'CALL C:\Vindoc\UTILITY\GenDDL\scripts\GenShowDDL.Bat' (TITLE '')            
,TRIM(DatabaseName) (TITLE '')                                    
,TRIM(TableName) (TITLE '')                                       
,TRIM(TableKind) (TITLE '')                                       
FROM DBC.Tables                                                   
WHERE TableKind IN ( 'V','M','p','t')                             
AND DatabaseName IN 'admintools_t'                                          
ORDER BY 2,3;                                                     
                                                                  
.export reset                                                     
.LOGOFF;                                                          
.QUIT;