SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

SQL>execute empcom;
FIRST_NAME LAST_NAME DEPTNUM
--------------- -------------------- -------
ALAN TERRY 3000
DAVID TERRY 2000
PETE WELLINGTON 3100
JOHN CHOU 3500
MANFRED CONRAD 4000
DINAH CLARK 9000
DAVE FISHER 3200
GEORGE FRENCHMAN 4000
KARL HELMSTED 4000
JOHN HUGHES 3200
WALTER LANCASTER 4000
MARLENE BONNY 4000
BILL WINN 2000
MIRIAM KING 2500
GINNY FOSTER 3300
MARIA JOSEF 4000
HERB ALBERT 3300
RICHARD BARTON 1000
XAVIER SEDLEMEYER 3300
DONALD TAYLOR 3100
LARRY CLARK 1000
JIM HERMAN 3000
GEORGE STRICKER 3100
OTTO SCHNABL 3200
TIM WALKER 3000
TED MCDONALD 2000
PETER SMITH 3300
MARK FOLEY 4000
HEIDI WEIGL 3200
ROCKY LEWIS 2000
SUE CRAMER 1000
MARTIN SCHAEFFER 3200
HERBERT KARAJAN 3200
JESSICA CRINER 3500
--- 35 row(s) selected.
The following statement runs the prepared findemp statement, which has two unnamed parameters.
The values that are being passed to these parameters are ?sal and 100. Parameter ?sal had
been previously set using set param command.
SQL>execute findemp using ?sal, 100;
EMPNUM FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY
------ --------------- -------------- ------- ------- --------
213 ROBERT WHITE 1500 100 90000.00
23 JERRY HOWARD 1000 100 137000.10
1 ROGER GREEN 9000 100 175500.00
29 JANE RAYMOND 3000 100 136000.00
32 THOMAS RUDLOFF 2000 100 138000.40
43 PAUL WINTER 3100 100 90000.00
65 RACHEL MCKAY 4000 100 118000.00
--- 7 row(s) selected.
For the syntax of the execute statement, see the SQL/MX Release 3.x Reference Manual.
Executing CREATE TRIGGER statements
To run create trigger statements by using RMXCI, you must specify a “/” in the first column
on a new line at the end of the create trigger statement, for example:
44 Interactively running commands in RMXCI