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 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

Modifier and Type Required Element and Description
  1. String
sql
Indicates the SQL stored procedure call to execute when the implemented version of the annotated method is invoked.

Required Element Detail

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)