Return Code (Magic xpa 4.x)

Some SQL statements, such as UPDATE and DELETE, do not return a result table. These are defined as Batch Exec commands. The only return of such commands is a Return Code reporting the status of success or failure of the command.

From the Return Code field, you can zoom the Argument list, where the variable that will receive the command’s return code is specified.

Use a logical variable to receive the success or failure result of the SQL Command. The variable may belong to the current or the parent task. All types of SQL Commands return a value to the Return Code. However, use of the Return Code is optional.

The Return Code will contain 1 by default when a Return Code is defined, or will be blank if no Return Code is defined.