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


Primary Commands

Primary Commands
APPLY object_command
[WHERE field relational operator value {& / | field relational operator value}]
[ORDERED
[ASCENDING/DESCENDING] field {& / | field relational operator value}
{& ORDERED [ASCENDING/DESCENDING] field
{& / | field relational operator value}}]
 
Example APPLY P WHERE UNIT =’TEST’ ORDERED DESCENDING TIME
 
FIND field relational operator value {& / | field relational operator}
[ORDERED
[ASCENDING/DESCENDING] field {& / | field relational operator value}
{& ORDERED [ASCENDING/DESCENDING] field
{& / | field relational operator value}}]
 
Example FIND LOCATION LIKE ’*ville’
 
ORDERED [ASCENDING/DESCENDING] field
{& [ASCENDING/DESCENDING] field }
Example ORDERED DEPTNO AND ORDERED DESCENDING LNAME
 
SELECT [field relational operator value {&/ | fieldrelationaloperatorvalue}]
[ORDERED
[ASCENDING/DESCENDING] field {& / | field relational operator value}
{& ORDERED [ASCENDING/DESCENDING] field
{& / | field relational operator value}}]
 
Example SELECT DEPTNO=10 ORDERED LNAME

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