Using an AutoEdit Variable Database

To assign a value to a variable in an AutoEdit variable database:

1. Specify the variable database as the current global variable pool using the %%$GLOBAL system variable.
2. Specify the appropriate row through the %%$DBROW reserved user-defined variable.
3. Set the variable by a DO SET statement as follows:

   DO SET %%colname = val

   In this statement

   • colname is the name of the column where the variable exists
   • val is the value to be assigned to the variable

   The following sample set of DO statements accomplishes the steps described above.

   DO SET=%%$GLOBAL = MYDB       GLOBAL  N

   DO SET=%%$DBROW = 3       GLOBAL  N

   DO SET=%%COLNAME = NEWVALUE       GLOBAL  Y

   WHILE and ENDWHILE statements can be used to loop through variables in a column of a table. For more information, see DO SET: Automated Console Action Parameter.