Statements

Copyright © Cloud Software Group, Inc. All Rights Reserved

Statements

Statements

For more information, refer to TIBCO Object Service Broker Programming in Rules.

CALL

rule [(argument {, argument })] /

[WHERE arg_name=arg_value {& arg_name= arg_value}];

COMMIT ;

DELETE

table [(parm_value {, parm_value})]

[WHERE primary_key = expression] ;

DISPLAY

screen;

DISPLAY & TRANSFERCALL

display screen [& TRANSFERCALL

[IN BROWSE/UPDATE]

rule [(argument {, argument })]]/

[WHERE arg_name=arg_value{& arg_name=arg_value}];

EXECUTE

[IN BROWSE/UPDATE]

rule [(argument {, argument})] /

[WHERE arg_name=arg_value {& arg_name=arg_value}];

FORALL

table [(parm_value {, parm_value})]

[WHERE [¬] field / parm_name relational_operator / LIKE expression { & / | [¬] field relational_operator / LIKE expression}]

ORDERED

[ASCENDING/DESCENDING] field {& ORDERED

[ASCENDING/DESCENDING] field}]

[UNTIL exception_name [table] {| exception_name [table]}] :

statement;

{statement;}

END;

GET

table [(parm_value {, parm_value})]

[WHERE [¬] field / parm_name relational_operator / LIKE expression {& / | [¬] field relational_operator / LIKE expression}]

[ORDERED

[ASCENDING/DESCENDING] field {& ORDERED

[ASCENDING/DESCENDING] field}]

[WITH MINLOCK];

INSERT

table [(parm_value {, parm_value})] /

[WHERE parm_name=parm_value

{& parm_name=parm_value}] ;

ON

exception_name[table]:

statement;

{statement;}

PRINT

report;

REPLACE

table [(parm_value {, parm_value})] /

[WHERE parm_name=parm_value

{& parm_name=parm_value}] ;

RETURN

(expression);

ROLLBACK ;

SIGNAL exception_name;

SCHEDULE

[IN BROWSE/UPDATE]

[TO queue]

rule [(argument {, argument})] /

[WHERE arg_name=arg_value {& arg_name=arg_value}];

TRANSFERCALL

[IN BROWSE/UPDATE]

rule [(argument {, argument})] /

[WHERE arg_name=arg_value {& arg_name=arg_value}];

UNTIL

UNTIL exception_name {| exception_name}:

statement;

{statement;}

END;

UNTIL...DISPLAY

UNTIL exception_name {| exception_name} [DISPLAY {screen}]:

statement;

{statement;}

END;