Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix A Primary Command Syntax Reference : Primary Command Syntax

Primary Command Syntax
SELECT Command
This section describes the syntax for the SELECT command:
SEL[ECT] [<Sel Predicate> {<OrderList>}]
 
   <Sel Predicate>)
   {<Addop><Expr Term>}
   <Expr Factor>}
   <Expr Primary>}
   <Constant>
   (<Expression>)
   <OR>
   =
   >
   >=
   <
   <=
   LIKE
   -
   ||
   /
   +
   &
   |
   ¬
   <Number>
   <OrderTerm>}
   <FieldName>
   ASC[ENDING]
ORDERED Command
This section describes the syntax for the ORDERED command:
ORD[ERED] [<Ordering>] <FieldName> {<And> <OrderTerm>}
FIND Command
This section describes the syntax for the FIND command:
F[IND] <FieldName> <Relop> <Constant> {<And> <FieldName> <Relop> <Contant>}
CHANGE Command (Table Editor Only)
This section describes the syntax for the CHANGE command:
CH[ANGE] <FieldName> = <Constant>
<Constant> [<Change Option>]
 
   <REST>
   <ALL>
EDIT Command (Table Editor Only)
This section describes the syntax for the EDIT command:
ED[IT] <TableSpec> [WHERE <Sel Predicate>] [<OrderList>]
 
XEDIT Command (Table Editor Only)
This section describes the syntax for the XEDIT command:
XE[DIT] <TableSpec> [WHERE <Sel Predicate>] [<OrderList>]
BROWSE Command
This section describes the syntax for the BROWSE command:
BR[OWSE] <TableName> [WHERE <Sel Predicate>] [<OrderList>]
XBROWSE Command (Table Editor Only)
This section describes the syntax for the XBROWSE command:
XB[ROWSE] <TableName> [WHERE <Sel Predicate>] [<OrderList>]
EXCLUDE Command
This section describes the syntax for the EXCLUDE command:
EXC[LUDE] <FieldName> {<FieldName>}
EXPAND Command
This section describes the syntax for the EXPAND command:
EXP[AND] <ObjectName> [<ObjectType>]
 
   <report_name>
   <screen_name>
   <table_name>
   <rule_name>
   <builtin_name>
   FLD
   REPORT
   RPT
   SCREEN
   SCR
   TABLE
   TBL
   RULE
 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved