IFX Format

Español · English

Formats Informix SPL and Informix 4GL in Cursor and VS Code without overriding generic SQL formatters (Postgres, etc.).

ID: emanuelmanga.ifx-format

Features

Informix SPL (.ifs / .ifx / .spl)

• Formats DEFINE, LET, IF / ELSE / END IF, FOR / FOREACH / WHILE, queries and subqueries
• ON EXCEPTION / END EXCEPTION / RAISE EXCEPTION (indent, blanks, highlight)
• Blank line after queries, including FOREACH cursor SELECT (no trailing ;)
• Uppercase keywords, adjustable indentation and blank lines
• TextMate syntax + semantic highlight: procedure params, DEFINE / ON EXCEPTION SET locals, control blocks matching their END
• Snippets: file header (header / encabezado), CREATE PROCEDURE skeleton (procedure / proc)

Informix 4GL (.4gl) — separate stack

• Own language ID (informix-4gl), grammar, formatter and highlight (does not reuse the SPL formatter)
• Formats DATABASE, MAIN / END MAIN, FUNCTION / END FUNCTION, IF, WHENEVER, DISPLAY, EXECUTE PROCEDURE, etc.
• Semantic highlight: DEFINE locals, FUNCTION params, local function names (declaration + CALL), and builtins (num_args, ARG_VAL, …)
• Snippets: file header, MAIN skeleton, FUNCTION skeleton
• Settings under ifxFormat.4gl.* (independent from SPL)

Shared

• Does not interfere with Postgres / other .sql formatters
• Custom icon for Informix file extensions (toggle with ifxFormat.customFileIcons)
• Format on save enabled by default for both languages

Preview

Format Document

Another format example

Parameter and variable highlighting

Procedure parameters and DEFINE variables with distinct colors:

.spl file icon

Supported files

For Informix-only projects, associate .sql in the workspace:

{
    "files.associations": {
        "*.sql": "informix-spl"
    }
}

Usage

1. Open a .ifs, .ifx, .spl, or .4gl file
2. Format Document (Shift+Alt+F) or enable format on save
3. Or run IFX Format: Format Document

Snippets

In an Informix file, type the prefix and accept the suggestion (Enter / Tab):

Example (SPL)

Before

create procedure sp_demo(p_id int)
returning int;
define l_total int;
if p_id > 0 then
let l_total = p_id * 2;
else
let l_total = 0;
end if;
return l_total;
end procedure;

After

CREATE PROCEDURE sp_demo(p_id INT)
RETURNING INT;

  DEFINE l_total INT;

  IF p_id > 0 THEN
    LET l_total = p_id * 2;
  ELSE
    LET l_total = 0;
  END IF;

  RETURN l_total;

END PROCEDURE;

Settings

Shared

SPL formatting (ifxFormat.*)

4GL formatting (ifxFormat.4gl.*)

Syntax highlighting (SPL + 4GL)

Requirements

Cursor or VS Code >= 1.74

Links

• Repository
• Issues

License

MIT