Create JDBC template input variables Create the variables to pass into the JDBC activity in the Inputs form of the activity designer. Before you beginYou must name your activity in the General form before you can advance to the Inputs stage.Roles required: activity_creator, admin Note: Variable strings in the Inputs form have a 255 character limit. Procedure Click the + icon to create a new input variable. The designer creates a default variable called Input1. Type your new variable name in the field. To change the name of a variable or any of its attributes, double-click the value and then select or enter a new value in the field that appears. Configure your variable using these fields: Table 1. Variable configuration Field Description Type Data type for this variable. Double-click on the field to display the choice list. In addition to the usual data types, you can create input arrays and encrypt individual variables that contain sensitive data. Encrypted variables are passed to the ECC Queue and then decrypted by the MID Server when they run on the target host. Sensitive data returned from running these variables on the host can then be passed to another activity through encrypted output variables. Mandatory Marks an input variable as mandatory. Variables marked as mandatory are required fields in the properties form for the activity in the workflow. The input testing feature allows you to filter on mandatory variables. Default Default value for this input variable. Default values are prepopulated for variables in the properties form for the activity in the workflow. You can override this value when you test the variables. To reorder the variable list, select a row and then drag the row to its new location. When you select a row to move it, the pointer icon changes to an up/down arrow icon (). To delete a variable, click the delete icon () in the row. Click Continue to advance to the Execution Command stage or click Go to Pre-Processing (Advanced) to create a script that runs before the activity executes.