Script generating system and method

Abstract

A method includes receiving data from a user indicating a selection of a procedure, automatically selecting at least one template to implement the procedure, and extracting table structure information related to the procedure from a database management system dictionary. The method further includes manipulating the table structure information and automatically incorporating the manipulated table structure information into the at least one template to generate a modified template.

1 . A method comprising: 
 receiving data from a user indicating a selection of a procedure;    automatically selecting at least one template to implement the procedure;    extracting table structure information related to the procedure from a database management system dictionary;    manipulating the table structure information; and    automatically incorporating the manipulated table structure information into the at least one template to generate a modified template.    
   
   
       2 . The method of  claim 1 , further comprising creating the at least one template.  
   
   
       3 . The method of  claim 1 , further comprising selecting a database type that includes the database management system dictionary.  
   
   
       4 . The method of  claim 1 , wherein the table structure information is extracted from the database management system dictionary via at least one macro,  
   
   
       5 . The system of  claim 4 , wherein the at least one macro retrieves the database management system dictionary from a database management system (DBMS).  
   
   
       6 . The system of  claim 5 , wherein the database management system is a relational database management system (RDBMS).  
   
   
       7 . The system of  claim 5 , wherein the database management system is a Teradata database management system.  
   
   
       8 . The method of  claim 1 , further comprising automatically generating a script to implement the procedure, wherein the script calls a first template of the at least one template as a variable into a second template of the at least one template.  
   
   
       9 . The method of  claim 1 , wherein the database management system dictionary is associated with a database management system, and wherein the database management system has a parallel architecture.  
   
   
       10 . The method of  claim 1 , further comprising generating a procedure script to implement the procedure, wherein the procedure script includes the modified template.  
   
   
       11 . The method of  claim 10 , further comprising displaying the procedure script.  
   
   
       12 . The method of  claim 10 , further comprising transmitting the procedure script via a file transfer protocol (FTP) to a destination.  
   
   
       13 . The method of  claim 1 , further comprising converting the table structure information into an alternate programming language file layout prior to incorporating the manipulated table structure information into the at least one template.  
   
   
       14 . The method of  claim 13 , wherein the alternate programming language file layout is compatible with the Common Business Oriented Language (COBOL) programming language.  
   
   
       15 . The method of  claim 1 , wherein the at least one template comprises one of: 
 an auto load feature to auto load a specific file;    a create duplicate copy feature, the create duplicate copy feature to generate a backup copy from a dictionary table layout;    a multi-load delete feature;    a template for collecting statistics on columns and upfront optimizations;    a template with a syntax that purges data from a table or another template;    a template including a secondary index that allows storing of data at a particular table or removing data from the particular table;    a template to replace or update a particular template with a new template; and    a template to filter out data.    
   
   
       16 . A script generating system comprising: 
 a server including logic adapted to receive data indicating a selection of a procedure;    wherein, in response to receiving the data, the logic is adapted to: 
 automatically select at least one template to implement the procedure;  
 extract table structure information related to the procedure from a database management system dictionary;  
 manipulate the table structure information; and  
 automatically incorporate the manipulated table structure information into the at least one template.  
   
   
   
       17 . The system of  claim 16 , wherein the logic is further adapted to automatically generate a script to implement the procedure using the at least one template.  
   
   
       18 . The system of  claim 16 , wherein the table structure information includes a column name, a data type, format data, a default value, a primary index, a secondary index, a column statistic, a view, or any combination thereof.  
   
   
       19 . A computer-readable medium including instructions executable by a processor, which when executed cause the processor to: 
 receive data from a user indicating a selection of a procedure;    automatically select at least one template from a plurality of templates to implement the procedure;    extract table structure information related to the procedure from a database management system dictionary;    convert the table structure information into a file having an alternate language file layout; and    automatically incorporate the converted table structure information in the file into the at least one selected template.    
   
   
       20 . The computer-readable medium of  claim 19 , further comprising instructions executable by the processor to include a pre-defined template into the plurality of templates.