Common AddColumns Tool Usage Scenarios
The following are the most common scenarios for running the AddColumns tool:
• Run the tool in plain mode (with no additional action parameters). This performs the -a, -u, and -syncFromDB commands in sequence to add the specified columns to the specified modeled type, and to update the database schema, class and introspection files, and the local attribute column schema file in one sequence.
AddColumns type_name datatype=number {datatype=number}
Multiple datatype=number pairs can be specified.
• Run the tool with the -a parameter. This adds the specified columns to the specified modeled type, but does not update the database schema or local attribute column schema file. Typically the tool would be run with the -a parameter multiple times, before running the tool with the -u parameter.
AddColumns -a type_name1 datatype=number {datatype=number}
AddColumns -a type_name2 datatype=number {datatype=number}
AddColumns -a type_name3 datatype=number {datatype=number}
AddColumns -u
• Run the tool with the -r parameter. This runs the report for the specified type.
AddColumns -r type_name
• Run the tool with the -syncFromDB parameter to update the local attribute column schema file to match the database schema, and update the introspection and class files to match the database schema for all types.
AddColumns -syncFromDB