Invokes the specified procedure.
DO procedure_name[(arg1[, argi]...)]
Name of the procedure to execute.
Arguments to pass to the procedure. Arguments can be any type of variable or constant value.
When the procedure ends, processing continues with the command following DO. You can use arguments to send values to or receive values from a procedure.
Arguments passed by DO to a procedure must match in number:
Database text columns, string variables, and literals can be passed to procedure string or date arguments.
Database numeric columns, numeric variables, and numeric literals can be passed to procedure numeric arguments.
Numeric variables (DECIMAL, INTEGER, FLOAT) can be passed to procedure numeric arguments without regard to the argument type of the procedure. Production Reporting automatically converts the numeric values upon entering and leaving the procedure as required.
Date variables can be passed to procedure date or string arguments.
When a field in DO receives a value back from a procedure (a colon indicates it is a back value—that is, a value that’s being returned), it must be a string, numeric, or date variable, depending on the procedure argument; however, a date can be returned to a string variable and vice versa.
When a date is passed to a string, the date is converted to a string according to the following rules:
For DATETIME columns and Production Reporting DATE variables, Production Reporting uses the format specified by SQR_DB_DATE_FORMAT. If not set, Production Reporting uses the first database-dependent format in Table 61, Default Formats by Database.
For DATE columns, Production Reporting uses the format specified by SQR_DB_DATE_ONLY_FORMAT. If not set, Production Reporting uses the format in Table 62, DATE Column Formats.
For TIME columns, Production Reporting uses the format specified by SQR_DB_TIME_ONLY_FORMAT. If not set, Production Reporting uses the format in Table 63, TIME Column Formats.
BEGIN-PROCEDURE for information on passing arguments