Chapter 3 Creating J2EE Applications for Sybase EAServer

The Select Query

The select query uses @attributeName for both the return value and the where criteria.

The @attributeName represents the name of a persistent attribute (CMP-field) of the EJB.

For the select query, you can use a stored-procedure. The syntax used for stored-procedures is:

select @attributeName1, @attributeName2, ... {call procedureName @attributeName1, @attributeName2, ...}

Attribute names are used in the select statement to indicate the types of the result set, and in the procedure as parameters.

Copyright (C) 2005. Sybase Inc. All rights reserved.