Where To Use the MessageLanguage Method

Previous Next

See Also

In constraints, you can call the MessageLanguage method from an INVOKE statement.

· If the message type is set to WARNING or INFORMATION, this results in a warning or information message, and NO violation.

 

· If the message type is set to ERROR, this results in an error message and a violation.

 

· If the message type is set to QUESTION, the MessageLanguage method returns the value 1 (Yes) or 2 (No), and the result depends on the constraint text.

Within Batch, you can invoke the MessageLanguage method within a SQL task or within an import task. If the message type is set to ERROR, the batch job stops, otherwise the message is displayed or added to the log file, and the batch job continues.

In decisions, you can invoke the MessageLanguage method within the SqlScript() method in the Yes and No actions. In this case, a message is displayed, and the decision continues (even with the ERROR message type).