Synopsis
Changes the Connection or Schema of a load table.
Description
Changes either the Connection or the Schema of the specified load table. Only the Connection or Schema can be changed so two calls are required to change both.
Input

Input

Description

Common Input

Includes all 5 inputs of the Callable Routines Common Input.

Change Property

Change either the 'SCHEMA' or the 'CONNECTION' of the specified load table. Separate calls must be made if both the schema and connection need to be changed.

Load Table Name

The name of the load table to be changed.

New Property Value

Either the new schema name or the new connection name.

Output

Output

Description

Return Code

Output Return Code:

  • S Success.
  • E Error.
  • F Fatal/Unexpected Error.

Return Message

Output message indicating the action applied or the reason for no action.

Result Number  

Output Result Number:

  • 1 Success.
  • -2 Error.
  • -3 Fatal/Unexpected Error.
  • No labels