com.ibm.pdq.annotation
Annotation Type Call
-
@Target(value=METHOD)
@Retention(value=RUNTIME)
public @interface Call
Used in an interface to indicate to the pureQuery Generator that the declared annotated method executes an SQL stored procedure call. The SQL statement can be specified in the
@Call
annotation. See the IBM Optim pureQuery Runtime documentation for details on how SQL statements can be specified for annotated methods. When the pureQuery Generator is invoked
for an interface, it generates an implementation class for the interface. The generated version of a method that is annotated with @Call
executes the specified SQL stored procedure
call.
Required Element Summary
Required Element Summary Data Type | Element Name and Description |
String |
sql
Indicates the SQL stored procedure call to execute when the implemented version of the annotated method is invoked. |
sql
public abstract String sql
-
Indicates the SQL stored procedure call to execute when the implemented version of the annotated method is invoked. The SQL string can be a native-syntax stored procedure call. It also
can be a JDBC function call escape string in either of the following formats:
CALL THE_STORED_PROCEDURE(parameter1, parameter2)
? = CALL THE_STORED_PROCEDURE(parameter1, parameter2)