Vortex Statements

• A - function definition
  • Function Scope
  • Function Parameters
  • Pass-by-Value Arguments
  • Pass-by-Reference Arguments
  • Start Functions with Parameters
• IF, ELSE, ELSEIF - conditional execution
• SWITCH - multi-choice branch
• Variable assignment - assign values to variables
• LOCAL - declare local variables
• LOOP - iterate through variables
• SQL - execute SQL statement
  • Parameter Substitution
  • Dynamic Parameters
  • SQL Command Construction
  • Multi-value Variables
  • Complex Field Names
  • Special SQL Variables
• DB - set database path
• USER, PASS - set SQL user and password
• WHILE - conditional loop
• READLN - read file a line at a time
• WRITE - write to file
• EXEC - execute program
• CAPTURE - capture output
• TIMPORT - general purpose data import
• BREAK - exit loop
• CONTINUE - continue loop
• RETURN - exit current function
• VERB - raw output