R300 – The ESQL format is not formatted correctly (ABN) (WMB)

The ESQL format is not formatted correctly (ABN) (WMB)

The formatting requirements are

use spaces rather then TABS’s to format code.

a “space” after each “comma” in the line

For example CAST(COALESCE(SQLCODE,’N/A’) AS CHAR)
Preferred CAST(COALESCE(SQLCODE, ‘N/A’) AS CHAR)

a blank line between a DECLARE statement and the next statement

For example DECLARE newEnvRef REFERENCE TO Environment.Variables;
SET newEnvRef.var1 = ”;
Preferred DECLARE newEnvRef REFERENCE TO Environment.Variables;

SET newEnvRef.var1 = ”;

a line between functions or procedures

For example END;
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
Preferred END;

CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN

two (2) lines between modules

For example END MODULE;
CREATE FUNCTION localFunction() RETURNS CHAR
BEGIN
Preferred END MODULE;




CREATE FUNCTION localFunction() RETURNS CHAR
BEGIN